-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
?erých Jakub wrote:
I have nearly the same question in the same situation. Is it possible to reset "Book of deleted pages" (after many tests on preproduction MW server it is pretty full of deleted pages and it would be little bit confusing for the users of real server, if they accidentally found "This page was 10 times deleted, you can recover it...".
Thanks
Jakub
I assume you use the latest version; if you use some version like 1.4, it may be wrong.
I think that the necessary SQL command is: "TRUNCATE TABLE archive" (adjust "archive" if there is a table prefix).
I don't think that there are other records of the deleted pages (there are references to the pages and to the links from the pages in the tables page, revision, recentchanges, site_stats, pagelinks, imagelinks, categorylinks, templatelinks, externallinks and langlinks), as they should be deleted when the article is deleted (Article::doDeleteArticle), therefore this single command should do. The text will still be stored in the table "text", but no one will be able to access it.
Another easy possibility is setting the following in LocalSettings.php (the users are sysops, right?):
$wgGroupPermissions['sysop']['deletedhistory'] = false;
However, this will prevent them also from viewing the lately deleted revisions.