I am getting a database error using 2.8.2Pv4 on my vB 4.2.0 PL4
PHP Code:
Database error in vBulletin 4.2.0:
Invalid SQL:
SELECT subscribeforumid, forum.forumid, forum.lastpost, forum.lastposter, forum.lastposterid, forum.lastthread, forum.lastthreadid, forum.lasticonid, forum.threadcount, forum.replycount, forum.lastpostid, forum.lastprefixid, thread.threadid, thread.field3 AS field3, thread.field2 AS field2, thread.field1 AS field1, default_tags_ids, 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
, forumread.readtime AS forumread
FROM vb_forum AS forum
LEFT JOIN vb_subscribeforum AS subscribeforum ON (subscribeforum.forumid = forum.forumid AND subscribeforum.userid = 115112)
LEFT JOIN vb_forumread AS forumread ON (forumread.forumid = forum.forumid AND forumread.userid = 115112)
LEFT JOIN vb_user AS user ON (user.userid = forum.lastposterid)
LEFT JOIN vb_userlist AS userlist ON (userlist.relationid = user.userid AND userlist.type = 'buddy' AND userlist.userid = 115112)
LEFT JOIN vb_thread AS thread ON (thread.threadid=forum.lastthreadid);
MySQL Error : Unknown column 'thread.field3' in 'field list'
Error Number : 1054
...deleted info...
Classname : vB_Database
MySQL Version : 5.1.70-cll
A field I created is now displayed twice.
I would really like to see this working again because the idea behind it is really really good.