Upgrading to 4.2.1 Help

[Jordan S Smith]

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

[nhawk]

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

[Jordan S Smith]

Originally Posted by nhawk

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