Issue: Recent changes numbers are negated

Issue Tools
- View Changes

July 28, 2009 9:40 AM

mickknutson

Regular Member

Recent changes numbers are negated

I actually have ADDED much text, NOT removed text as depicted on the screen shot in my recent changes.

Before the upgrade, these numbers where positive, not negative.

Issue Details

Issue Number 736

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.0

Milestone (none)

Software DependencyAny

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 2

Assigned Users (none)

Tags (none)

July 28, 2009 2:56 PM
pegasus

VaultWiki Team
Run the following query on your database:

Code:

UPDATE vault_revision SET unzip = 0

However, fixing this will mess up any new revisions made since the upgrade. If you can find the timestamp for your first revision after the upgrade (try http://www.dracon.biz/timestamp.php), you do the following query instead:

Code:

UPDATE vault_revision SET unzip = 0 WHERE dateline < {timestamp}
Reply
July 28, 2009 3:17 PM

mickknutson

Regular Member

How can I just purge all my history?

Reply
July 28, 2009 3:30 PM

pegasus

VaultWiki Team

That feature is not yet available. At this time, I recommend running one of the queries mentioned above.

Reply
July 28, 2009 4:01 PM

mickknutson

Regular Member

I tried both of the queries with no luck.
Todays changes are good, yesterday's and beyond are not.

Also, there where zero rows affected on each query I ran. Should there have been some updates?

There are only 5 rows that do not have unzip set to zero.

Should I manually set them to zero?

Reply
July 28, 2009 4:12 PM

pegasus

VaultWiki Team

Ah. Don't change the 5 rows. Those are new today and are zipped correctly.

I'm very confused why there wasn't a database error during the upgrade. Download the product-ZIP again and replace your /vault/install folder.
Then visit /vault/install/upgrade_250.php?step=5
When step 5 completes, do NOT click next. Just leave the upgrader. This should hopefully correct the problem.

Reply
July 29, 2009 9:43 AM

mickknutson

Regular Member

Originally Posted by pegasus

Ah. Don't change the 5 rows. Those are new today and are zipped correctly.

I'm very confused why there wasn't a database error during the upgrade. Download the product-ZIP again and replace your /vault/install folder.
Then visit /vault/install/upgrade_250.php?step=5
When step 5 completes, do NOT click next. Just leave the upgrader. This should hopefully correct the problem.

Did not change anything

Reply

July 29, 2009 5:12 PM

pegasus

VaultWiki Team

Got it. In vault/install/upgrade_250.php, find:

Code:

	if (!empty($titles))
	{
		foreach ($titles AS $i => $set)
		{
			$db->query_write("
				UPDATE " . TABLE_PREFIX . "vault_revision

Replace with:

Code:

	if (!empty($revisions))
	{
		foreach ($revisions AS $i => $set)
		{
			$db->query_write("
				UPDATE " . TABLE_PREFIX . "vault_revision

Then run /vault/install/upgrade_250.php?step=5
As mentioned above, don't proceed to the next step.

August 3, 2009 10:04 AM

mickknutson

Regular Member

That worked!!!

Reply

+ Reply

All times are GMT -4. The time now is 12:02 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 changes numbers are negated

Issue Tools