I never had any problems while upgrading my forums so I didn't take a backup before attempting the upgrade, I know, very stupid of me
I had 4.2.0 Installed so I downloaded 4.2.1, removed the install.php and config.php.new files and uploaded the files to my forums folder on my server overwriting all files that are there.
Half way down through the process, when I opened my website I got this error:
Warning: mysqli_query() [[URL="http://forums.tweakarena.com/function.mysqli-query"]function.mysqli-query[/URL="http://forums.tweakarena.com/function.mysqli-query"]]: (42000/1064): 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 '= 0 ORDER BY navtype, displayorder' at line 3 in [path]/includes/class_core.php on line 1391
Now if I try to go to [URL="http://forums.tweakarena.com/upgrade.php"]http://forums.tweakarena.com/upgrade.php[/URL="http://forums.tweakarena.com/upgrade.php"] I get the same page as above
Please help, what shall I do? I cannot even run the upgrade script upgrade.php since I only get the above error when I type in that URL!?
I had 4.2.0 Installed so I downloaded 4.2.1, removed the install.php and config.php.new files and uploaded the files to my forums folder on my server overwriting all files that are there.
Half way down through the process, when I opened my website I got this error:
Warning: mysqli_query() [[URL="http://forums.tweakarena.com/function.mysqli-query"]function.mysqli-query[/URL="http://forums.tweakarena.com/function.mysqli-query"]]: (42000/1064): 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 '= 0 ORDER BY navtype, displayorder' at line 3 in [path]/includes/class_core.php on line 1391
Database error | |
The Tweak Arena Forums database has encountered a problem. | |
|
|
Please try the following:
|
|
The forums.tweakarena.com forum technical staff have been notified of the error, though you may [EMAIL="[email protected]"]contact them[/EMAIL="[email protected]"] if the problem persists. | |
We apologise for any inconvenience. |
Database error in vBulletin 4.2.0:
Invalid SQL:
SELECT *
FROM navigation
WHERE state & = 0
ORDER BY navtype, displayorder;
MySQL Error : 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 '= 0
ORDER BY navtype, displayorder' at line 3
Error Number : 1064
Request Date : Thursday, April 18th 2013 @ 11:17:57 AM
Error Date : Thursday, April 18th 2013 @ 11:17:57 AM
Script : [URL="http://forums.tweakarena.com/upgrade.php"]http://forums.tweakarena.com/upgrade.php[/URL="http://forums.tweakarena.com/upgrade.php"]
Referrer :
IP Address : 92.98.10.97
Username : Matrix Leader
Classname : vB_Database_MySQLi
MySQL Version : 5.5.23-55
Invalid SQL:
SELECT *
FROM navigation
WHERE state & = 0
ORDER BY navtype, displayorder;
MySQL Error : 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 '= 0
ORDER BY navtype, displayorder' at line 3
Error Number : 1064
Request Date : Thursday, April 18th 2013 @ 11:17:57 AM
Error Date : Thursday, April 18th 2013 @ 11:17:57 AM
Script : [URL="http://forums.tweakarena.com/upgrade.php"]http://forums.tweakarena.com/upgrade.php[/URL="http://forums.tweakarena.com/upgrade.php"]
Referrer :
IP Address : 92.98.10.97
Username : Matrix Leader
Classname : vB_Database_MySQLi
MySQL Version : 5.5.23-55
Please help, what shall I do? I cannot even run the upgrade script upgrade.php since I only get the above error when I type in that URL!?
Comment