vb.org Archive - Forums Database Error after uploading all files of 4.2.1

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
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.

Quote:

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 [DATE]1366302677[/DATE] at [TIME]1366302677[/TIME] ---------------

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

Quote:

Originally Posted by Trevor Hannant;n3963107

Try going to http://forums.tweakarena.com/install/upgrade.php

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.00907 seconds Memory Usage 1,717KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (1)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: