Code:
Database error in vBulletin 4.1.0:
Invalid SQL:
SELECT thread.threadid, thread.title, thread.prefixid, post.attach, post.userid AS postuserid, post.username AS postusername,
thread.postusername, thread.dateline, thread.lastpostid, thread.lastpost, thread.lastposterid, thread.lastposter, thread.replycount,
forum.forumid, forum.title_clean as forumtitle,
post.pagetext AS message, post.allowsmilie, post.postid,
user.userid, user.username, thread.lastposter AS lastpostername
FROM vbulletin_thread AS thread
INNER JOIN vbulletin_forum AS forum ON(forum.forumid = thread.forumid)
LEFT JOIN vbulletin_post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN vbulletin_user AS user ON (thread.postuserid = user.userid)
WHERE 1=1
AND (thread.forumid IN(3,71,157,158,162,163,164,165,45,135,44,46,47,48,78,93,105,145,147,138,139,148,140,141,142,143,144,146,23,9,10,16,17,50,51,52,107,29,30,31,32,33,34,35,36,37,38,94,39,40,41,42,43,26,136,19,20,21,22,149,55,92,102,103,96,112,76,49,81,83,86,119,120,121,127,128,129,130,87,88,89,90,91,95,97,98,116,117,122,125,126,24,14,137,15,150,151,152,153,154,155,156,65,66,67,54,118,131,160,25,13,77,57,59,58,60,61,62,63,82,84,70,64,68,80,99,100,104,108,109,111,114,124,132,161,27,11,28,75,159,73,85,74,53,56,69,101,106,110,113,123)
AND thread.visible = 1
AND post.visible = 1
AND open <> 10
AND thread.dateline > 1292009442
AND thread.postuserid IN (27350)
ORDER BY thread.dateline DESC
LIMIT 0,1;
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 thread.dateline DESC
LIMIT 0,1' at line 20
Error Number : 1064
Request Date : Friday, December 31st 2010 @ 01:30:42 PM
Error Date : Friday, December 31st 2010 @ 01:30:42 PM
Script : http://www.*********.com/forum/member.php/27350
Referrer : http://www.*********.com/forum/showthread.php/*********
IP Address : xxx.xxx.xxx.xxx
Username : *********
Classname : vB_Database
MySQL Version : 5.0.91-community