the new file gives me a database error:
Database error in vBulletin 4.1.0:
Invalid SQL:
SELECT thread.postusername as firstpostusername, thread.postuserid as firstpostuserid, post.dateline, post.pagetext, post.allowsmilie, post.postid,
thread.threadid, thread.title, thread.prefixid, post.attach, thread.replycount,
forum.forumid, post.title AS posttitle, post.dateline AS postdateline,
user.userid as postuserid, user.username as postusername
FROM post AS post
JOIN thread AS thread ON (thread.threadid = post.threadid)
JOIN forum AS forum ON(forum.forumid = thread.forumid)
LEFT JOIN user AS user ON (post.userid = user.userid)
WHERE 1=1
AND ( thread.forumid IN(3,4,11,5,56,6,7,8,9,10,12,13,14,15,16,17,18,19, 28,20,40,22,23,24,25,26,27,53, 54,55,29,31,32,52,30,35,41,42,43,44,45,46,47,48,49 ,50,51,36,37,38,39)
AND thread.visible = 1
AND post.visible = 1
AND thread.open <> 10
AND post.dateline > 1291844552
AND post.parentid > 0
AND post.userid IN (1)
ORDER BY post.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 post.dateline DESC
LIMIT 0,1' at line 20
Error Number : 1064
Request Date : Wednesday, December 29th 2010 @ 01:42:32 PM
Error Date : Wednesday, December 29th 2010 @ 01:42:32 PM
Script :
Referrer :
IP Address :
Username :
Classname :
MySQL Version : 5.0.51a-community
|