Issue: Recent Revisions

Issue Tools
- View Changes

August 2, 2009 3:57 AM

vimto

Regular Member

Recent Revisions

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

Issue Details

Issue Number 750

Issue Type Bug

Project VaultWiki 3.x Series

Category History / Revisions

Status Fixed

Priority 3 - Loss of Functionality

Affected Version 2.5.0

Fixed Version 2.5.1

Milestone (none)

Software DependencyAny

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

August 3, 2009 1:43 PM

pegasus

VaultWiki Team

In vault/special/special_recentchanges.php, find:

Code:

		SELECT COUNT(revisionid) AS rowcount
		FROM " . TABLE_PREFIX . "vault_revision

Replace with:

Code:

		SELECT COUNT(revisionid) AS rowcount
		FROM " . TABLE_PREFIX . "vault_revision AS revision

August 6, 2009 4:57 PM

vimto

Regular Member

Many thanks, will update when I get home from holiday

Reply
August 7, 2009 5:36 AM
vimto

Regular Member
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.

Code:

$minor_revisions = ($hide_minor ? "AND revision.minorchange = 0" : '');

Changed to:

Code:

$minor_revisions = ($hide_minor ? "AND revision.minor = 0" : '');

This seems to do the trick.
Reply
August 7, 2009 2:55 PM

pegasus

VaultWiki Team

Great. Fixed for the next build.

Reply

+ Reply

All times are GMT -4. The time now is 11:27 AM.

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.

Learn more… Accept Remind me later

Welcome to VaultWiki.org, home of the wiki add-on for vBulletin and XenForo!

Issue: Recent Revisions

Issue Tools