Database error in vBulletin 3.6.8:
Invalid SQL:
SELECT thread.threadid, thread.forumid, IF(thread.threadprefix <> '', CONCAT('', thread.threadprefix, '', thread.title), thread.title) AS title, postusername, postuserid, thread.lastpost, thread.replycount, forum.title AS forumtitle
,post.pagetext AS preview
, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
FROM vb_thread AS thread
INNER JOIN vb_forum AS forum ON (forum.forumid = thread.forumid)
LEFT JOIN vb_post AS post ON (post.postid = thread.firstpostid)
LEFT JOIN vb_subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1)
WHERE thread.threadid IN (11) AND thread.visible = 1
ORDER BY lastpost DESC;
MySQL Error : Unknown column 'thread.threadprefix' in 'field list'
Error Number : 1054
Date : Saturday, September xxth xxxx @ xx:xx:xx PM
Script : http://www.xxxxxx.com/forums/showthread.php?t=10
Referrer : http://www.xxxxxx.com/forums/forumdisplay.php?f=39
IP Address : xxx.xxx.xx.xxx
Username : xxx_xxxx
Classname : vb_database