When selecting "Recent Revisions" the page loads fine, if however I select "Hide Minor Revisions" or "Hide my revisions" I get the following Error:
Database error in vBulletin 3.8.3:
Invalid SQL:
Code:
SELECT COUNT(revisionid) AS rowcount
FROM vault_revision
WHERE forumid IN (38)
AND revision.userid NOT IN (0,1)
AND revision.minorchange = 0;
MySQL Error : Unknown table 'revision' in where clause
Error Number : 1109
Request Date : Sunday, August 2nd 2009 @ 08:55:44 AM
Error Date : Sunday, August 2nd 2009 @ 08:55:44 AM
Script : http://www.bluedragons.co.uk/forums/showwiki.php?title=Special:Recentchanges
Referrer : http://www.bluedragons.co.uk/forums/showwiki.php?title=Special:Recentchanges&namespace=Wiki
IP Address : 90.216.70.9
Username : xxxxx
Classname : vB_Database
MySQL Version : 4.1.22-log
Had another small error once I updated your fix, When clicking on hide minor revisions I received another error where it stated that revision.minorchange was an unknown column, So I've changed the code in vault/special/special_recentchanges.php to the following.
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.