Database error

[Bladed]

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

[tbworld]

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.

[Bladed]

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

[tbworld]

Originally Posted by Bladed

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.

[Bladed]

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

[tbworld]

Originally Posted by Bladed

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.

[Bladed]

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

[tbworld]

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

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

No, you cannot restore your database to a new install.

[Bladed]

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.

[tbworld]

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