$revision = $db->query_first("
SELECT revision.*, COUNT(revision.revisionid) - 1 AS revisioncount
FROM " . TABLE_PREFIX . "vault_revision AS revision
WHERE revision.revisionid >= " . intval($revisionid) . "
AND threadid = " . intval($threadinfo['threadid']) . "
GROUP BY threadid
ORDER BY revision.revisionid ASC
");
Replace with:
Code:
$revision = $db->query_first("
SELECT revision.*, COUNT(revision.revisionid) - 1 AS revisioncount
FROM " . TABLE_PREFIX . "vault_revision AS revision
WHERE revision.revisionid <= " . intval($revisionid) . "
AND threadid = " . intval($threadinfo['threadid']) . "
GROUP BY threadid
ORDER BY revision.revisionid DESC
");
You cannot roll back some revisions due to data loss that occurred pre-2.3.0... where some revisions were accidentally erased. The current version of that article is actually the one with the 1969 time. So that's the one you want to be rolling back.
I don't think I made the edit from 1969, not really sure how that got there. It deleted a bunch of the content for some reason.
Here's the db error for when I try to edit:
Code:
Database error in vBulletin 3.7.3:
Invalid SQL:
UPDATE user
SET vault_edits = vault_edits + 1
WHERE userid = 4384;
MySQL Error : Unknown column 'vault_edits' in 'field list'
Error Number : 1054
Request Date : Tuesday, May 12th 2009 @ 11:06:27 AM
Error Date : Tuesday, May 12th 2009 @ 11:06:27 AM
Script : hxxp://www.1perfectworld.com/wiki/International-Guides:Winged Elves Production Skills&do=edit
Referrer : hxxp://www.1perfectworld.com/wiki/International-Guides:Winged+Elves+Production+Skills&do=edit
IP Address : 71.63.142.197
Username : pNuker
Classname : vB_Database
MySQL Version : 5.0.67-community
Unfortunately as was mentioned, this issue is a consequence of data loss that occurred prior to 2.3.0. While there is no way to recover the original data, the underlying cause was fixed in 2.3.0.
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.