Run the new recountCategories.php script on all wikis. It has to be run three times on all wikis, once with --mode pages, once with --mode files and once with --mode subcats. You might want to pick a suitable value for --throttle as well.
Description
Description
| Status | Subtype | Assigned | Task | ||
|---|---|---|---|---|---|
| Open | None | T18660 Database table cleanup (tracking) | |||
| Duplicate | None | T18036 Number of category members (PAGESINCATEGORY) is inaccurate for large categories | |||
| Resolved | TTO | T18765 Write a maintenance script to refresh category member counts | |||
| Open | None | T170737 Run recountCategories.php on Wikimedia wikis | |||
| Resolved | None | T169964 Counter of the numbers of the pages on a category shows negative result | |||
| Resolved | Urbanecm | T228585 Counter for pages in category is below zero | |||
| Open | BUG REPORT | None | T272821 Chinese Wikipedia: category has -1 page |
Event Timeline
Comment Actions
Fun, yeah, I can.
Will look at running it on the test wikis today, and see how the output looks etc :)
Comment Actions
reedy@terbium:~$ mwscript recountCategories.php --wiki=testwiki --mode=pages | tee ~/testwiki.log Finding up to 500 drifted rows starting at cat_id 500... Updating cat_pages field on 154 rows... Finding up to 500 drifted rows starting at cat_id 500... Done! Updated the pages counts of 154 categories. Now run the script using the other --mode options if you haven't already. Also run 'php cleanupEmptyCategories.php --mode remove' to remove empty, nonexistent categories from the category table. reedy@terbium:~$ mwscript recountCategories.php --wiki=testwiki --mode=subcats | tee ~/testwiki.log Finding up to 500 drifted rows starting at cat_id 500... Updating cat_subcats field on 4 rows... Finding up to 500 drifted rows starting at cat_id 500... Done! Updated the subcats counts of 4 categories. Now run the script using the other --mode options if you haven't already. reedy@terbium:~$ mwscript recountCategories.php --wiki=testwiki --mode=files | tee ~/testwiki.log Finding up to 500 drifted rows starting at cat_id 500... Updating cat_files field on 10 rows... Finding up to 500 drifted rows starting at cat_id 500... Done! Updated the files counts of 10 categories. Now run the script using the other --mode options if you haven't already. reedy@terbium:~$ mwscript cleanupEmptyCategories.php --wiki=testwiki | tee ~/testwiki.log ...Update 'cleanup empty categories' already logged as completed. reedy@terbium:~$ mwscript cleanupEmptyCategories.php --wiki=testwiki --force | tee ~/testwiki.log Adding empty categories with description pages... Removing empty categories without description pages... The category named :Sub-Sub-Category_Bleah_tst is not valid?! --mode=remove --begin=中文(简体) Category cleanup complete. reedy@terbium:~$
Comment Actions
reedy@terbium:~$ mwscript recountCategories.php --wiki=test2wiki --mode=pages | tee ~/test2wiki.log Finding up to 500 drifted rows starting at cat_id 500... Updating cat_pages field on 25 rows... Finding up to 500 drifted rows starting at cat_id 500... Done! Updated the pages counts of 25 categories. Now run the script using the other --mode options if you haven't already. Also run 'php cleanupEmptyCategories.php --mode remove' to remove empty, nonexistent categories from the category table. reedy@terbium:~$ mwscript recountCategories.php --wiki=test2wiki --mode=subcats | tee ~/test2wiki.log Finding up to 500 drifted rows starting at cat_id 500... Done! Updated the subcats counts of 0 categories. Now run the script using the other --mode options if you haven't already. reedy@terbium:~$ mwscript recountCategories.php --wiki=test2wiki --mode=files | tee ~/test2wiki.log Finding up to 500 drifted rows starting at cat_id 500... Done! Updated the files counts of 0 categories. Now run the script using the other --mode options if you haven't already. reedy@terbium:~$ mwscript cleanupEmptyCategories.php --wiki=test2wiki --force | tee ~/test2wiki.log Adding empty categories with description pages... Removing empty categories without description pages... --mode=remove --begin=Statut_UICN_EN Category cleanup complete. reedy@terbium:~$
Comment Actions
Unfortunately line 101 of the script is wrong. It should be printing $this->minimumId. I don't know if that really matters though, it looks like that was just intended to let you see how long the script is taking, and I guess you'll be running it headless.
Ping @MaxSem regardless.
Comment Actions
Not sure why this task was assigned to me; I don't have, and have never had, shell access.
For future reference, this was solved in T247215.
Comment Actions
Probably… but there's now also T224321: Run populateCategory.php and I'm not sure what's the difference.