I recently moved my vbulletin installation farther down the filesystem tree on my host. Basically from public_html/gmtrucks to public_html/domains/gmtrucks.org. Since then, I have been receiving numerous emails everyday with the same database error:
Database error in vBulletin 3.6.6:
Invalid SQL:
SELECT page.page_id, page.page_namespace, page.page_title, SUBSTRING(txt.old_text, 1, 4096) AS page_text
FROM page page
LEFT OUTER JOIN revision rev ON page.page_latest = rev.rev_id
LEFT OUTER JOIN text txt ON rev.rev_text_id = txt.old_id
WHERE page_namespace = AND page_touched >= '20070906000000';
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 'AND page_touched >= '20070906000000'' at line 5
Error Number : 1064
Date : Wednesday, September 5th 2007 @ 06:10:09 PM
Script : http://www.gmtrucks.org/cron .php?&rand=514050
Referrer : http://www.gmtrucks.org/
IP Address : 68.125.142.232
Username : Unregistered
Classname : vB_Database
I can see that the syntax error is because there is no value after the = on the SQL statement. I looked at the cron.php and didn't see any SQL formatting that might be suspect. So, I am kinda lost. Everything works fine on the board, but I get a ton of these emails every day.
Any ideas?
Database error in vBulletin 3.6.6:
Invalid SQL:
SELECT page.page_id, page.page_namespace, page.page_title, SUBSTRING(txt.old_text, 1, 4096) AS page_text
FROM page page
LEFT OUTER JOIN revision rev ON page.page_latest = rev.rev_id
LEFT OUTER JOIN text txt ON rev.rev_text_id = txt.old_id
WHERE page_namespace = AND page_touched >= '20070906000000';
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 'AND page_touched >= '20070906000000'' at line 5
Error Number : 1064
Date : Wednesday, September 5th 2007 @ 06:10:09 PM
Script : http://www.gmtrucks.org/cron .php?&rand=514050
Referrer : http://www.gmtrucks.org/
IP Address : 68.125.142.232
Username : Unregistered
Classname : vB_Database
I can see that the syntax error is because there is no value after the = on the SQL statement. I looked at the cron.php and didn't see any SQL formatting that might be suspect. So, I am kinda lost. Everything works fine on the board, but I get a ton of these emails every day.
Any ideas?
Comment