https://bugzilla.wikimedia.org/show_bug.cgi?id=19919
Summary: Article count in Special:Statistics incorrect
Product: MediaWiki
Version: 1.16-svn
Platform: All
URL: http://ksh.wikipedia.org/wiki/Spezial:Statistik?uselang=
en
OS/Version: All
Status: NEW
Severity: major
Priority: Normal
Component: Special pages
AssignedTo: [email protected]
ReportedBy: [email protected]
CC: [email protected]
In kshwiki, we seem to have an issue with the article count.
10635 non-redirect pages in the `pages` table
10596 pages according to query in the maintenance script [1]
9972 shown in Special:Statistics
[1]
http://svn.wikimedia.org/viewvc/mediawiki/trunk/phase3/maintenance/updateArticleCount.inc?revision=50942&view=markup
Here are queries made on the toolserver data base, with results:
mysql> use kshwiki_p ;
mysql> SELECT count( `page_id` ) FROM `page` \
WHERE ( `page_namespace` ) = 0 \
AND ( `page_is_redirect` = 0 ) ;
+--------------------+
| count( `page_id` ) |
+--------------------+
| 10635 |
+--------------------+
1 row in set (10.90 sec)
mysql> SELECT COUNT(DISTINCT page_namespace, page_title) \
AS pagecount FROM `page` , `pagelinks` \
WHERE `pl_from` = `page_id` AND `page_namespace` = 0 \
AND `page_is_redirect` = 0 AND `page_len` > 0 ;
+-----------+
| pagecount |
+-----------+
| 10596 |
+-----------+
1 row in set (2.93 sec)
mysql> SELECT `ss_good_articles` FROM `site_stats` ;
+------------------+
| ss_good_articles |
+------------------+
| 9972 |
+------------------+
1 row in set (0.00 sec)
Imho, the difference is likely at least in part caused by a
software update. The old parser accepted a some comments inside
redirect pages, which the new parser does not. Thus, some
existing such pages were not included in the good pages count
with the old parser. Now, when we detect them, we correct them,
the new parser sees a non-redirect becoming a redirect, and it
decrements the count of good pages. This may well have happened
~620 times, at least it appers to be a very reasonable figure.
Another issue which I observed several months ago and failed
to report: in order to duplicate two pages, including their edit
history for a page split, either I exported and re-imported
them with new page titles, or I exported, renamed, and reimported them with the
original page titles. This did not
increase the page count.
--
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
