[madshark]

Originally Posted by shanevas2

Database error in vBulletin 4.1.3:

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 thread AS thread
INNER JOIN forum AS forum ON(forum.forumid = thread.forumid)
LEFT JOIN post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN user AS user ON (thread.postuserid = user.userid)
WHERE 1=1
AND (thread.forumid IN(11,12,13,14,15,19,20,21,22,23,24,25,26,1,3,16,1 7,4,5,6,30,2,18,7,8,9,10,27,28,29)
AND thread.visible = 1
AND post.visible = 1
AND open <> 10
AND thread.dateline > 1300467552



AND thread.postuserid IN (1)
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, April 8th 2011 @ 09:59:12 AM
Error Date : Friday, April 8th 2011 @ 09:59:12 AM
Script : http://texasperformanceforums.com/member.php?1-Shane
Referrer : http://texasperformanceforums.com/forum.php
IP Address : 75.1.52.44
Username : Shane
Classname : vB_Database
MySQL Version : 5.0.91-log

If you went a few pages back : https://vborg.vbsupport.ru/showpost....7&postcount=26