db error

[eLsGn]

Database error in vBulletin :

Invalid SQL:
SELECT * FROM style
WHERE (styleid = 0 AND userselect = 1)
OR styleid =
ORDER BY styleid ASC
LIMIT 1

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 'ORDER BY styleid ASC
LIMIT 1' at line 4

mysql error number: 1064


----------------

i remove the all file and hacks then put fresh copy but still show the error and i cannot log to admin

[Floris]

Sounds like a hack is not fully uninstalled. Did you also revert the mysql db changes?

[eLsGn]

nothing change in mysql db

[eLsGn]

but i think the size of db is 1.2mb is it normal with small forum

[Steve Machol]

SQL Syntax errors are almost always related to modified code. To troubleshoot this, the first thing you need to do is remove any hacks or plugins, then see if you still have this problem.

If so, reupload all the original vB non-image files (except install.php). Make sure you upload these in ASCII format and overwrite the ones on the server.

Next, create a new style and choose no parent style. This will force it to use the default templates. Finally empty your browser cache, close all browser windows then try again. Make sure you chan
ge to the new style and view your forums with it. Do you have the same problem?

[eLsGn]

I did what you told me but nothing change

[Steve Machol]

Honestly I find it hard to believe you are still getting this error with the original vB code. If you have not installed any plugins or hacks (which includes portals), fill out a support ticket at:

http://members.vbulletin.com/membersupport_contactform.php

Be sure to include the login info to your Admin CP, phpMyAdmin and FTP. Please also include a complete description of the problem.