Please import the missing wikis from this list: https://wikiteam.googlecode.com/svn/trunk/listsofwikis/mediawikis_2013_checked.txt note that it has some overlap with Pavlo's list in the same directory, which was already imported previously.
Version: unspecified
Severity: enhancement
fwiw, arbitrary string "See the schedule at [[Wikimedia Foundation Annual Plan]]." in there
hmm.. some are ending in index.php, not api.php, i would like one type only, the api.php ones..
total number in list: 13220
ending in api.php: 10268
reduced list to SQL: for wiki in $(cat mediawikis_2013_checked_api.txt); do echo "INSERT IGNORE INTO mediawikis (statsurl,method) VALUES (\"$wiki\",\"8\");"; done > mediawikis_2013_checked_api.sql
mysql wikistats < mediawikis_2013_checked_api.sql
duplicates are skipped, results in new wikis without names in the table:
8997
importing new wikis, get names and stats from APIs:
sudo -u wikistatsuser /usr/bin/php /usr/lib/wikistats/update.php mw import
(which is a special import run that also sets the name)
minimal fix to the import itself: https://gerrit.wikimedia.org/r/#/c/157322/
now running ...
A(126/8992)