Hi,
i am testing upgrade from 4.0.5 to 4.1.6. Everything went smoothly until blog upgrade. Then i got this error message:
Unexpected Text:
<?xml version="1.0" encoding="windows-1252"?>
<?xml version="1.0" encoding="windows-1252"?>
<errors>
<error><![CDATA[<p>Database Error</p>
Invalid SQL:
UPDATE administrator SET
blogpermissions = 3
WHERE adminpermissions &;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3]]></error>
<error_html><![CDATA[<p>Database error in vBulletin 4.1.6</p>
<p>Invalid SQL:
UPDATE administrator SET
blogpermissions = 3
WHERE adminpermissions &;<p>
<p>
<strong>MySQL Error</strong> : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3<br />
<strong>Error Number</strong> : 1064<br />
<strong>Request Date</strong> : Wednesday, September 28th 2011 @ 11:31:52 PM<br />
<strong>Error Date</strong> : Wednesday, September 28th 2011 @ 11:31:52 PM<br />
<strong>Script</strong> : http://testsite/vb/install/upgrade.php<br />
<strong>Referrer</strong> : http://testsite/vb/install/upgrade.php<br />
<strong>Classname</strong> : vB_Database<br />
<strong>MySQL Version</strong> : 5.1.39-log<br />
</p>]]></error_html>
</errors>
I have deleted all old files and uploaded new files. Then i created a new style and deleted old ones. DidnĀ“t help at all. What i should try next?
i am testing upgrade from 4.0.5 to 4.1.6. Everything went smoothly until blog upgrade. Then i got this error message:
Unexpected Text:
<?xml version="1.0" encoding="windows-1252"?>
<?xml version="1.0" encoding="windows-1252"?>
<errors>
<error><![CDATA[<p>Database Error</p>
Invalid SQL:
UPDATE administrator SET
blogpermissions = 3
WHERE adminpermissions &;
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3]]></error>
<error_html><![CDATA[<p>Database error in vBulletin 4.1.6</p>
<p>Invalid SQL:
UPDATE administrator SET
blogpermissions = 3
WHERE adminpermissions &;<p>
<p>
<strong>MySQL Error</strong> : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3<br />
<strong>Error Number</strong> : 1064<br />
<strong>Request Date</strong> : Wednesday, September 28th 2011 @ 11:31:52 PM<br />
<strong>Error Date</strong> : Wednesday, September 28th 2011 @ 11:31:52 PM<br />
<strong>Script</strong> : http://testsite/vb/install/upgrade.php<br />
<strong>Referrer</strong> : http://testsite/vb/install/upgrade.php<br />
<strong>Classname</strong> : vB_Database<br />
<strong>MySQL Version</strong> : 5.1.39-log<br />
</p>]]></error_html>
</errors>
I have deleted all old files and uploaded new files. Then i created a new style and deleted old ones. DidnĀ“t help at all. What i should try next?