PDA

View Full Version : Database error in vBulletin 3.7.0


avitor
Sun 18th May '08, 1:49pm
this massage i gote to my admin mail
i try to go to my site home page and not possible
is take me to not found page

its start by self
i dident make eny changes in last few days


Database error in vBulletin 3.7.0:

Invalid SQL:
SELECT DATEDIFF(NOW(), '2008-05-09 10:11:57') AS DAYS;;

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 '(NOW(), '2008-05-09 10:11:57') AS DAYS' at line 1
Error Number : 1064
Request Date : Friday, May 9th 2008 @ 11:01:02 PM
Error Date : Friday, May 9th 2008 @ 11:01:02 PM
?????????

Steve Machol
Sun 18th May '08, 3:55pm
Invalid SQL errors are almost always related to modified code. To troubleshoot this, the first thing you need to do is remove any third-pary 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 change to the new style and view your forums with it. Do you have the same problem?