[leejohn02]

This is the error i get

Database error in vBulletin 4.2.2:

Invalid SQL:

SELECT
IF(votenum >= 1, votenum, 0) AS votenum,
IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
post.pagetext AS preview,thread.firstpostid, post.pagetext AS thumb,
thread.threadid, thread.title AS threadtitle, thread.forumid, thread.pollid, thread.open, thread.postusername, thread.postuserid, thread.iconid AS threadiconid,
thread.dateline, thread.notes, thread.visible, thread.sticky, thread.votetotal, thread.attach, thread.lastpost, thread.lastposter, thread.lastposterid, thread.lastpostid, thread.replycount, IF(thread.views<=thread.replycount, thread.replycount+1, thread.views) AS views,
thread.prefixid, thread.taglist, thread.hiddencount, thread.deletedcount, user.userid,
user.membergroupids, user.infractiongroupids, user.usergroupid, user.homepage, user.options AS useroptions, IF(userlist.friend = 'yes', 1, 0) AS isfriend,
user.lastactivity, user.lastvisit, IF(user.options & 512, 1, 0) AS invisible

, NOT ISNULL(subscribethread.subscribethreadid) AS issubscribed
, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
, threadread.readtime AS threadread
, threadredirect.expires
, thread.bop_global , disgroup.opentag AS disopen, disgroup.closetag AS disclose, prigroup.opentag AS priopen, prigroup.closetag AS priclose,
disuser.displaygroupid AS display, priuser.displaygroupid AS display, user.displaygroupid, thread.postusername AS e360postusername,
disfield.fieldfield28, prifield.fieldfield28
FROM thread AS thread
LEFT JOIN user AS user ON (user.userid = thread.lastposterid)
LEFT JOIN userlist AS userlist ON (userlist.relationid = user.userid AND userlist.type = 'buddy' AND userlist.userid = 1)

LEFT JOIN deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
LEFT JOIN subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 1 AND canview = 1)
LEFT JOIN threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = 1)
LEFT JOIN post AS post ON(post.postid = thread.firstpostid)

LEFT JOIN threadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)
LEFT JOIN user AS disuser ON ( disuser.userid = thread.postuserid ) LEFT JOIN userfield AS disfield ON ( disfield.userid = disuser.userid ) LEFT JOIN usergroup AS disgroup ON ( disgroup.usergroupid = disuser.displaygroupid ) LEFT JOIN user AS priuser ON ( priuser.userid = thread.postuserid ) LEFT JOIN userfield AS prifield ON ( prifield.userid = priuser.userid ) LEFT JOIN usergroup AS prigroup ON ( prigroup.usergroupid = priuser.usergroupid )
WHERE thread.threadid IN (0,6014,6008,6001,5875,5867,5591,5371,5324,4857,45 09,4464,3890,2996,3492,3446,3454,3448,3443,3432,33 97)
ORDER BY thread.sticky DESC, lastpost DESC;

MySQL Error : Unknown column 'disfield.fieldfield28' in 'field list'
Error Number : 1054
Request Date : Thursday, November 28th 2013 @ 10:15:23 AM
Error Date : Thursday, November 28th 2013 @ 10:15:23 AM
Script : http://www.pureglitching.com/forumdi...-Announcements
Referrer : http://www.pureglitching.com/forum.php
IP Address : 82.12.176.199
Username : Glitch_Guru
Classname : vB_Database
MySQL Version : 5.5.32-cll