Database error
 

I just upgraded to 4.2.2 and now I'm getting this error:

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

Disable your plugins/mods and see if you still have the problem. If you no longer have the error then you have a plugin/mod that needs to be upgraded.

I deleted the old install due to the C99madShell v. 2.0 madnet edition hack.

Are you saying this is a new install? In your first post you said you upgraded. Sorry, I am a bit confused. :)

Well i ran the upgrade script. perhaps I need to go back and run the full install script?

You run the upgrade script when you are upgrading a database to the next version.
You run the install script on a new installation, blank database.

will i be able to restore my back up of the data base to the new install?

If you are trying to use the same database. You really need to fix your current installation first, before you upgrade. Upgrading will not clear out problems in a modified database due to the malware.

Make sure you follow all the recommended steps. I will re-post links to them if you do not know them.

--------------- Added 07 Nov 2013 at 03:18 ---------------
No, you cannot restore your database to a new install.

OK, so basically because of the extent of this hack and malware, I really need to start from scratch, as this would be the most effective way of cleaning the site up.

I just took this forum over and from what I can tell this "backdoor" in has been there for quite a while. a good number of things like the admincp had not been secured against intrusion.

You made a backup ... good job! :)

The following guides and best practices should get you up and running again. Be thorough when using them, and sorry you were hacked.

http://www.vbulletin.com/forum/blogs...vbulletin-site
http://www.vbulletin.com/forum/blogs...ve-been-hacked
http://www.vbulletin.com/forum/blogs...vbulletin-site
http://www.vbulletin.com/forum/forum...-1-vbulletin-5