PDA

View Full Version : Forums Database Error after uploading all files of 4.2.1


MaXimus
04-18-2013, 03:27 PM
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() [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:

Load the page again by clicking the [URL="http://forums.tweakarena.com/upgrade.php#"]Refresh[/URL="http://forums.tweakarena.com/upgrade.php#"] button in your web browser.
Open the [URL="http://forums.tweakarena.com/"]forums.tweakarena.com[/URL="http://forums.tweakarena.com/"] home page, then try to open another page.
Click the Back button to try another link.

The forums.tweakarena.com forum technical staff have been notified of the error, though you may [EMAIL="admin@tweakarena.com"]contact them[/EMAIL="admin@tweakarena.com"] 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

Now if I try to go to 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!?

--------------- Added 1366302677 at 1366302677 ---------------

Hmm, nevermind, someone from vBulletin replied and it solved the issue, the URL was wrong :)

Try going to [url]http://forums.tweakarena.com/install/upgrade.php (http://forums.tweakarena.com/function.mysqli-query)