i have a guest database error too ............ although other than this its working fine
PHP Code:
Database error in vBulletin 4.0.2:
Invalid SQL:
SELECT thread.threadid, thread.title, thread.lastpost, thread.forumid, thread.replycount, thread.postusername, thread.postuserid, thread.lastposter, thread.lastposterid, thread.dateline, thread.views, thread.visible, thread.open, user.usergroupid, user.displaygroupid
FROM thread AS thread
LEFT JOIN user AS user ON (user.userid = thread.lastposterid)
WHERE NOT ISNULL(thread.threadid) AND thread.visible = '1' AND thread.open!='10' AND thread.forumid NOT IN(229,72,28,58,74,225,224,227,228,)
ORDER BY lastpost DESC
LIMIT 0, 10;
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 ')
ORDER BY lastpost DESC
LIMIT 0, 10' at line 4
Error Number : 1064
Request Date : Friday, March 19th 2010 @ 03:28:23 AM
Error Date : Friday, March 19th 2010 @ 03:28:24 AM
Script : http://www.tabletennistalk.co.uk/forum/forumdisplay.php?f=71
Referrer :
IP Address : 66.235.116.43
Username : Unregistered
Classname : vB_Database
MySQL Version :
Is there any chance of pulling latest classified too?