When clicking on the History tab of any article, the following vBulletin database error is displayed:
Code:
Database error in vBulletin 3.8.1:
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, previous.username AS rollusername, previous.ipaddress AS rollipaddress
FROM vault_revision AS revision
LEFT JOIN vault_revision AS previous ON (previous.revisionid < revision.revisionid AND previous.threadid = revision.threadid)
LEFT JOIN vault_revision AS next_rev ON (next_rev.revisionid > revision.revisionid AND next_rev.threadid = revision.threadid)
LEFT JOIN user AS user ON (user.userid = revision.userid)
LEFT JOIN vault_revision AS roll_rev ON (roll_rev.revisionid = revision.rollback)
LEFT JOIN user AS rolluser ON (rolluser.userid = roll_rev.userid)
WHERE revision.threadid = 11744
GROUP BY revision.revisionid
ORDER BY dateline DESC
LIMIT 0,50;
MySQL Error : Unknown column 'previous.username' in 'field list'
Error Number : 1054
Request Date : Friday, March 20th 2009 @ 03:44:33 PM
Error Date : Friday, March 20th 2009 @ 03:44:33 PM
Script : hxxp://www.pdatotaal.info/forum/showwiki.php?title=Default:GSM+Roaming&do=history
I cannot find that error anywhere in the public version of 2.2.0. Not sure when you installed it, possibly when it was still flagged as "Unstable"? I would recommend downloading 2.2.0 of the product again and patching all your files.
This site uses cookies to help personalize content, to tailor your experience, and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.