MySQL error 1054 I recently started getting this error on my vBulletin board. It is the latest version, 3.8.3. I've disabled all hacks with no result, aswell as changed styles etc. Here's the error it shows: Code: Database error in vBulletin 3.8.3: Invalid SQL: SELECT thread.threadid, thread.forumid, IF(thread.threadprefix '', CONCAT('', thread.threadprefix, '', thread.title), thread.title) AS title, thread.prefixid, thread.taglist, postusername, postuserid, thread.lastpost, thread.replycount, forum.title AS forumtitle ,post.pagetext AS preview , NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed 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 subscribethread AS subscribethread ON (subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1) WHERE thread.threadid IN (98, 102, 96, 86, 76) AND thread.visible = 1 ORDER BY lastpost DESC; MySQL Error : Unknown column 'thread.threadprefix' in 'field list' Error Number : 1054 Request Date : Friday, July 10th 2009 @ 03:28:41 PM Error Date : Friday, July 10th 2009 @ 03:28:42 PM Script : http://forum.l2symbiosis.com/showthread.php?t=115 Referrer : http://forum.l2symbiosis.com/forumdisplay.php?f=3 IP Address : 83.183.141.111 Username : Lindrian Classname : vB_Database MySQL Version : 5.0.67 |
الساعة الآن 12:18 PM |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.5.2 TranZ By
Almuhajir