SQL error when I click on a new wiki entry
Database error:
Code:
Invalid SQL:
SELECT rev.userid, rev.dateline AS dateadded, rev.ipaddress,
user.username, user.usergroupid, user.membergroupids,
user.email, user.homepage,
IF(user.displaygroupid > 0, user.displaygroupid, user.usergroupid) AS displaygroupid
FROM vb_vault_revision AS rev
LEFT JOIN vb_user AS user ON (user.userid = rev.userid)
WHERE rev.threadid = 52449
AND rev.pending = 0
GROUP BY rev.userid
ORDER BY dateadded ASC;
MySQL Error : Unknown column 'rev.ipaddress' in 'field list'
Error Number : 1054
Request Date : Wednesday, February 4th 2009 @ 03:34:30 AM
Error Date : Wednesday, February 4th 2009 @ 03:34:31 AM
Script : hxxp://xxx.com/forum/wiki.php?name=Default::Search
Referrer : hxxp://xxx.com/forum/forumdisplay.php?f=75
IP Address : 999.181.212.71
Username : admin
Classname : vB_Database
MySQL Version : 5.0.37