Upgrading to 4.2.1 Help
 

So, we're trying to update our forum to 4.2.1 from 4.2.0 and this is the error we keep getting. Appreciate any help.


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 : Monday, April 22nd 2013 @ 03:40:23 AM
Error Date : Monday, April 22nd 2013 @ 03:40:23 AM
Script : http://www.kh-mediaflare.net/
Referrer :
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.5.30-log

Run upgrade.php. As soon as the upgrade is finished I do believe the error goes away.

Thanks so much ^^ It looks like we forgot to do that. I appreciate the response ^^