Hello, I just successfully migrated my wiki from a temporary/test server to my company's real server. Is there anyway for me to reset the page view counter (# times accessed) for each page now? I'd like a fresh count from the new server. Thank you, Colleen Robledo
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
I just successfully migrated my wiki from a temporary/test server to my company's real server. Is there anyway for me to reset the page view counter (# times accessed) for each page now? I'd like a fresh count from the new server.
UPDATE page SET page_counter = 0 WHERE page_counter <> 0;
Adjust "page" as needed if you are using a table prefix.
- -- Greg Sabino Mullane greg@turnstep.com End Point Corporation PGP Key: 0x14964AC8 200609191940 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
I just successfully migrated my wiki from a temporary/test
server to my
company's real server. Is there anyway for me to reset the page view counter (#
times accessed) for
each page now? I'd like a fresh count from the new server.
UPDATE page SET page_counter = 0 WHERE page_counter <> 0;
Adjust "page" as needed if you are using a table prefix.
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
-----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.
mediawiki-l@lists.wikimedia.org