Tweet
Error in 3.8.2 seem like a cron error
Hi Guys, i'm getting everyday error at 2.00AM. As follows:
Database error in vBulletin 3.8.2:
Invalid SQL:
SELECT COUNT(*) as cnt,max(lastpost) as lastupdate
FROM forum_thread AS thread
INNER JOIN forum_tagthread AS tagthread ON
(tagthread.tagid = 3 AND tagthread.threadid = thread.threadid)
WHERE thread.forumid IN()
AND thread.visible = 1
AND thread.sticky IN (0, 1)
AND thread.open <> 10
GROUP BY tagthread.tagid;
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 thread.visible = 1
AND thread.sticky IN (0, 1)' at line 5 Error Number : 1064 Request Date : Tuesday, May 15th 2012 @ 02:00:07 AM
Error Date : Tuesday, May 15th 2012 @ 02:00:07 AM
Script : XXXXXXXXXXXXXXXXX
Referrer : XXXXXXXXXXXXXXXXXXX
IP Address : 124.150.57.112
Username : Незарегистрированный
Classname : vB_Database
MySQL Version :
This error started to happen after I moved to a new server.
Thank you for your input.
Database error in vBulletin 3.8.2:
Invalid SQL:
SELECT COUNT(*) as cnt,max(lastpost) as lastupdate
FROM forum_thread AS thread
INNER JOIN forum_tagthread AS tagthread ON
(tagthread.tagid = 3 AND tagthread.threadid = thread.threadid)
WHERE thread.forumid IN()
AND thread.visible = 1
AND thread.sticky IN (0, 1)
AND thread.open <> 10
GROUP BY tagthread.tagid;
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 thread.visible = 1
AND thread.sticky IN (0, 1)' at line 5 Error Number : 1064 Request Date : Tuesday, May 15th 2012 @ 02:00:07 AM
Error Date : Tuesday, May 15th 2012 @ 02:00:07 AM
Script : XXXXXXXXXXXXXXXXX
Referrer : XXXXXXXXXXXXXXXXXXX
IP Address : 124.150.57.112
Username : Незарегистрированный
Classname : vB_Database
MySQL Version :
This error started to happen after I moved to a new server.
Thank you for your input.
Comment