Getting database emails for errors. On the error it has vsaanp_newposts, I am guessing it stands for vsa advanced new posts. Correct me if I am wrong.
Database error in vBulletin 4.1.2:
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(23,24,31,25,26,27,28,) AND
post.dateline >= 1300992412
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 >= 1300992412
GROUP BY post.threadid' at line 4
Error Number : 1064
Request Date : Thursday, March 24th 2011 @ 12:57:28 PM
Error Date : Thursday, March 24th 2011 @ 12:57:28 PM
Script :
http://www.anfieldindex.com/forum/mi...saanp_newposts
Referrer :
http://www.anfieldindex.com/forum/index.php
IP Address : 122.177.193.206
Username : thereddyone
Classname : vB_Database
MySQL Version :
Anyone have an idea what this error means and how to fix? I do not think users actually get an onscreen error...