Issue: Creating New Area Moves All Pages

Issue Tools
- View Comments

March 3, 2013 11:25 AM
pegasus

VaultWiki Team
Creating New Area Moves All Pages

When creating a new Area via the Area Manager, ALL pages (including areas) are moved to the newly created area. Somehow areas created by the importer did not cause this issue. Correcting the changes requires restoring from a database backup.

Fixed in Depot. Good thing we found this before release.

In case anyone needs to know how to restore a database without losing all data since the backup, here's an example for the current scenario. In this case, only the vw_page table was messed up, and only the areaid field on that table. If we import our backup to a separate database (e.g. vw_backup), we can run the following query:

Code:

UPDATE vw_vb.forum_vw_page AS p1 INNER JOIN vw_backup.forum_vw_page AS p2 ON (p2.pageid = p1.pageid) SET p1.areaid = p2.areaid

This will set all areaid values back to their previous values, but only for pages created before the backup. Anything after the backup will remain untouched. If there are some since the backup that were also messed up, those would need their own specific update queries.

Issue Details

Issue Number 2944

Issue Type Bug

Project VaultWiki 4.x Series

Category Admin Panel

Status Fixed

Priority 1 - Security / Login / Data Loss

Affected Version 4.0.0 Alpha 1 Depot

Fixed Version 4.0.0 Alpha 1

Milestone VaultWiki 4 Alpha 1

Software DependencyAny

License TypePaid

Users able to reproduce bug 0

Users unable to reproduce bug 0

Attachments 0

Assigned Users (none)

Tags (none)

March 3, 2013 11:49 AM
Issue Changed by pegasus
- Applicable version changed from 4.0.0 Alpha 1 Chipmunk to 4.0.0 Alpha 1
April 18, 2013 9:54 PM
Issue Changed by pegasus
- Issue marked as addressed
- Addressed version changed from Unknown to 4.0.0 Alpha 1

+ Reply

All times are GMT -4. The time now is 7:44 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: Creating New Area Moves All Pages

Issue Tools