Issue: Purged moderated wiki revision - can't clear "pending" moderation . . .

Issue Tools
- View Changes

April 23, 2012 6:27 AM

iMav

New Member

Purged moderated wiki revision - can't clear "pending" moderation . . .

User makes edit that requires moderation. Moderator goes into history and deletes moderated revision. Article is in permanent "Pending" state.

Issue Details

Issue Number 2668

Issue Type Bug

Project VaultWiki 3.x Series

Category History / Revisions

Status Fixed

Priority 3 - Loss of Functionality

Affected Version 3.0.17

Fixed Version 3.0.18

Milestone (none)

Software DependencyAny

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

April 23, 2012 6:58 AM

pegasus

VaultWiki Team

Okay, I can see that being a problem. In vault/dm/revision.php, find:

Code:

			else
			{
				// do nothing
			}

Replace with:

Code:

			else if ($this->existing['pending'] == 1)
			{
				$this->info['remove_pending'] = true;
			}

Find:

Code:

			if ($this->info['shift_back'])

Add before:

Code:

			if ($this->info['remove_pending'])
			{
				$this->dbobject->query_write("
					UPDATE " . TABLE_PREFIX . "vault_article
					SET pending = 0
					WHERE threadid = " . intval($this->existing['threadid']) . "
				");
			}

That change should allow moderators to purge edits that haven't been un-approved first without making the article go pending forever.

I will start working on the necessary upgrade script to fix already forever-pending articles.

April 23, 2012 7:09 AM
pegasus

VaultWiki Team
Script added to upgrade process, marked as fixed.

You can fix the article manually in the mean time if you run a database query:

Code:

UPDATE vault_article SET pending = 0 WHERE threadid = $THREADID

To find out the article's $THREADID to use in the query:

Visit the article in question.
Click the arrow next to the article title to open the popup menu.
Click the entry called "This page's broken links"
In the browser's address bar, you'll see "articleid=XX". The number is the ID you need.
Reply
April 23, 2012 7:23 AM
iMav

New Member
Originally Posted by pegasus

To find out the article's $THREADID to use in the query:

Visit the article in question.
Click the arrow next to the article title to open the popup menu.
Click the entry called "This page's broken links"
In the browser's address bar, you'll see "articleid=XX". The number is the ID you need.
Reply
April 23, 2012 7:29 AM

iMav

New Member

I only had one article in moderation total...so this worked:

Reply

+ Reply

All times are GMT -4. The time now is 11:16 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: Purged moderated wiki revision - can't clear "pending" moderation . . .

Issue Tools