[Vikingant]

Whenever I hit the History tab I get the following error.

Database error in vBulletin 4.0.7:

Invalid SQL:

SELECT revision.*, user.username, user.usergroupid, user.membergroupids,
MAX(previous.revisionid) AS prev_revisionid, MIN(next_rev.revisionid) AS next_revisionid,
roll_rev.ipaddress AS targetipaddress, rolluser.username AS targetusername,
previous.userid AS rolluserid, prev_user.username AS rollusername,
previous.ipaddress AS rollipaddress, previous.unzip AS prev_unzip

FROM vb_vault_revision AS revision
LEFT JOIN vb_vault_revision AS next_rev ON (next_rev.lastrevisionid = revision.revisionid AND next_rev.pending = 0)
LEFT JOIN vb_vault_revision AS previous ON (revision.lastrevisionid = previous.revisionid)
LEFT JOIN vb_user AS user ON (user.userid = revision.userid)
LEFT JOIN vb_vault_revision AS roll_rev ON (roll_rev.revisionid = revision.rollback)
LEFT JOIN vb_user AS rolluser ON (rolluser.userid = roll_rev.userid)
LEFT JOIN vb_user AS prev_user ON (prev_user.userid = previous.userid)

WHERE revision.threadid = 1405
GROUP BY revision.revisionid
ORDER BY dateline DESC
LIMIT 0,1;

MySQL Error : Unknown column 'next_rev.pending' in 'on clause'
Error Number : 1054
Request Date : Monday, December 6th 2010 @ 01:11:54 AM
Error Date : Monday, December 6th 2010 @ 01:11:54 AM
Script : http://mysite.com/showwiki.php?title...***&do=history
Referrer : http://mysite.com/showwiki.php?title...******&p=26213
IP Address : ***********
Username : *******
Classname : vB_Database
MySQL Version : 4.1.22-standard