Updating from 4.1.11

[Zachery]

Upgrade.php instead of update.php. The error message you were getting was caused by having not run the upgrader yet.

[BenWells]

seems I was going to the wrong php file, sorry for the post!

[BenWells]

Hello, I'm trying to update my vbulletin from 4.1.11 to the latest version. I backed up my DB, Uploaded the consents of the upload dir to the proper folder after deleting the install.php. When navigating to to the update.php file I get the following error:

Database error in vBulletin 4.1.11:

Invalid SQL:

SELECT *
FROM alpha_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 : Sunday, January 11th 2015 @ 05:50:32 PM
Error Date : Sunday, January 11th 2015 @ 05:50:32 PM
Script : http://alphaflight.net/install/update.php
Referrer :
IP Address : 142.68.127.119
Username : Ben
Classname : vB_Database
MySQL Version : 5.5.32-log