Wikimedia Bugzilla is closed!

maintenance/recount.sql hasn't been updated for MW 1.5.0's DB schema.  Here's a
proposed update to the script which works on my installation:

SELECT @foo:=COUNT(*) FROM /*$wgDBprefix*/page, /*$wgDBprefix*/revision,
/*$wgDBprefix*/text
  WHERE page_namespace=0 AND page_is_redirect=0 AND rev_page = page_id AND
rev_text_id = old_id AND old_text like '%[[%';
UPDATE /*$wgDBprefix*/site_stats SET ss_good_articles=@foo, ss_total_pages=-1,
ss_users=-1, ss_admins=-1;