ellinofatsa
04-15-2010, 07:44 AM
i hope its the richt place here!!!
today i go to my mail and i see many of mails from my board !!
Database error in vBulletin 4.0.3:
Invalid SQL:
SELECT COUNT(*) AS posts, post.threadid, post.dateline, thread.forumid
FROM post as post
LEFT JOIN thread AS thread ON (thread.threadid = post.threadid)
WHERE post.visible = '1' AND thread.forumid NOT IN(138,141,150,142,) AND post.dateline >= 1271317377
GROUP BY post.threadid;
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 post.dateline >= 1271317377
GROUP BY post.threadid' at line 4
Error Number : 1064
Request Date : Thursday, April 15th 2010 @ 11:37:59 AM
Error Date : Thursday, April 15th 2010 @ 11:37:59 AM
how can i fix the dataerror?
thanks.
today i go to my mail and i see many of mails from my board !!
Database error in vBulletin 4.0.3:
Invalid SQL:
SELECT COUNT(*) AS posts, post.threadid, post.dateline, thread.forumid
FROM post as post
LEFT JOIN thread AS thread ON (thread.threadid = post.threadid)
WHERE post.visible = '1' AND thread.forumid NOT IN(138,141,150,142,) AND post.dateline >= 1271317377
GROUP BY post.threadid;
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 post.dateline >= 1271317377
GROUP BY post.threadid' at line 4
Error Number : 1064
Request Date : Thursday, April 15th 2010 @ 11:37:59 AM
Error Date : Thursday, April 15th 2010 @ 11:37:59 AM
how can i fix the dataerror?
thanks.