Page MenuHomePhabricator

maintenance/recount.sql not updated for 1.5.0
Closed, ResolvedPublic

Description

Author: dossy

Description:
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;


Version: 1.5.x
Severity: normal

Details

Reference
bz3734

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 21 2014, 8:51 PM
bzimport set Reference to bz3734.
bzimport added a subscriber: Unknown Object (MLST).

recount.sql is replaced by initStats.php. Should make sure that works cleanly.

Removed 'need-review' and 'patch' keywords as there is no
patch on this bug.

Have checked initStats.php into REL1_5 and removed
recount.sql; resolving FIXED.