Database error in vBulletin 4.1.1:
Invalid SQL:
SELECT
thread.*,
post.*,
user.*,
thread.title AS threadtitle,
thread.dateline,
thread.threadid AS contentid,
'threads' AS contenttypeid,
favourite.userid IS NOT NULL AS isfavourite
, avatar.avatarpath, NOT ISNULL(customavatar.userid) AS hascustomavatar, customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight, customavatar.height_thumb AS avheight_thumb, customavatar.width_thumb AS avwidth_thumb, customavatar.filedata_thumb
FROM (SELECT threadid FROM vbthread ORDER BY threadid DESC LIMIT 1000) AS tmp
LEFT JOIN vbthread AS thread ON(thread.threadid = tmp.threadid)
LEFT JOIN vbpost AS post ON(post.postid = thread.firstpostid)
LEFT JOIN vbuser AS user ON(user.userid = thread.postuserid)
LEFT JOIN vbdbtech_livewall_settings AS currentuser_settings ON(currentuser_settings.userid = 260)
LEFT JOIN vbdbtech_livewall_settings AS actionuser_settings ON(actionuser_settings.userid = user.userid)
LEFT JOIN vbdbtech_livewall_favourite AS favourite ON(favourite.userid = 260 AND favourite.contenttypeid = 'threads' AND favourite.contentid = thread.threadid)
LEFT JOIN vbuserlist AS actionuser_friend ON(actionuser_friend.userid = user.userid AND actionuser_friend.relationid = 260)
LEFT JOIN vbavatar AS avatar ON (avatar.avatarid = user.avatarid) LEFT JOIN vbcustomavatar AS customavatar ON (customavatar.userid = user.userid)
WHERE NOT ISNULL(thread.threadid)
AND post.visible = 1
AND thread.visible = 1
AND thread.open != 10
AND thread.forumid NOT IN(0,48,132,151,149,150,133,134,135,136,137,138,139,140,141,145,146,93,50,148,17,3)
AND NOT FIND_IN_SET(0, membergroupids)
AND usergroupid NOT IN(0)
AND
(
user.userid = 260 OR
(
(
ISNULL(currentuser_settings.threads_display) OR
(
currentuser_settings.threads_display = 0 OR
(
currentuser_settings.threads_display = 1 AND
260 > 0
) OR
(
currentuser_settings.threads_display = 2 AND
actionuser_friend.type = 'buddy'
) OR
(
currentuser_settings.threads_display = 3 AND
actionuser_friend.type = 'buddy' AND
actionuser_friend.friend = 'yes'
)
)
) AND
(
ISNULL(actionuser_settings.threads_privacy) OR
(
actionuser_settings.threads_privacy = 0 OR
(
actionuser_settings.threads_privacy = 1 AND
260 > 0
) OR
(
actionuser_settings.threads_privacy = 2 AND
actionuser_friend.type = 'buddy'
) OR
(
actionuser_settings.threads_privacy = 3 AND
actionuser_friend.type = 'buddy' AND
actionuser_friend.friend = 'yes'
)
)
)
)
)
LIMIT 1
LIMIT 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 'LIMIT 1' at line 73
Error Number : 1064
Request Date : Saturday, February 25th 2012 @ 06:15:23 PM
Error Date : Saturday, February 25th 2012 @ 06:15:23 PM
Script : forums/livewall.php?do=viewcomments&contenttypeid=threads&contentid=
Referrer : /forums/private.php?do=showpm&pmid=13780
IP Address : **.***.***.***
Username : **********
Classname : ***********
MySQL Version :
