Cross-posted to wikitech-l, please reply to one list only.
Wouter Steenbeek wrote:
But there seems to be a technical defect on sco:. A few articles were created, among which some by Mark fyi, but the statistics ignore them... I was aiming to add the Scottish Wikipedia to the List of Wikipedias but I can't, for that reason.
For some reason (probably some theory of Jamesday's about great ways to optimise selects on single-row tables), the query for the {{NUMBEROFARTICLES}} tag looks like this:
$s = $dbr->selectRow( 'site_stats', array( 'ss_total_views', 'ss_total_edits', 'ss_good_articles' ), array( 'ss_row_id' => 1 ), $fname
i.e. using the new primary key in a way that's always meant to match. For this latest batch of wikis, I created the site_stats row using:
INSERT INTO site_stats() VALUES ()
which creates a row with default values in every column. The default for ss_row_id is 0. I'll fix this on these wikis shortly, I just thought it was a nice example of the problems you can get when you optimise things that don't really need optimising.
-- Tim Starling