I have installed MediaWiki 1.5.4, using MySQL 5, PHP 5, on Windows XP.
It works beautifully!
However, when I request Special:Statistics, I get a huge number (18,446,744,073,709,551,614) in the output.
I.e., the page reads:
<snip><snip><snip><snip><snip><snip><snip><snip><snip><snip><snip>
MacHershellWiki statistics
There are 1,298 total pages in the database. This includes "talk" pages, pages about MacHershellWiki, minimal "stub" pages, redirects, and others that probably don't qualify as content pages. Excluding those, there are 18,446,744,073,709,551,614 pages that are probably legitimate content pages.
There have been a total of 423 page views, and 161 page edits since the wiki was setup. That comes to 0.12 average edits per page, and 2.63 views per edit. User statistics
There are 3 registered users, of which 2 (or 66.67%) are administrators (see Project:Administrators).
<snip><snip><snip><snip><snip><snip><snip><snip><snip><snip><snip>
I've done quite a bit of searching, but haven't found any references to this odd behavior...
Could someone please help me understand this?
Chris
Christopher McIntosh wrote:
There are 1,298 total pages in the database. This includes "talk" pages, pages about MacHershellWiki, minimal "stub" pages, redirects, and others that probably don't qualify as content pages. Excluding those, there are 18,446,744,073,709,551,614 pages that are probably legitimate content pages.
Probably the counter wrapped backwards by mistake. You can manually reset the count like this in MySQL: update site_stats set ss_good_articles=NNN;
An approximation to the count might be:
select count(*) from page where page_namespace=0 and page_is_redirect and page_len > 0;
(not exact; it should check the text field for presence of a '[' char)
-- brion vibber (brion @ pobox.com)
Brion:
Thank you for your help. This is very interesting...
I performed the update as you pointed out. Now, when I visit the site as an anonymous user, the count is fine. However, if I visit as an authenticated user, I get the old, erroneous number (18,446,744,073,709,551,614). I switch browsers (using IE and Mozilla), clear their caches, and observe the same result...
Does MediaWiki actually pull from 2 different places for authenticated vs. anonymous user?
This seems counter-intuitive...
Chris
Brion Vibber wrote:
Christopher McIntosh wrote:
There are 1,298 total pages in the database. This includes "talk" pages, pages about MacHershellWiki, minimal "stub" pages, redirects, and others that probably don't qualify as content pages. Excluding those, there are 18,446,744,073,709,551,614 pages that are probably legitimate content pages.
Probably the counter wrapped backwards by mistake. You can manually reset the count like this in MySQL: update site_stats set ss_good_articles=NNN;
An approximation to the count might be:
select count(*) from page where page_namespace=0 and page_is_redirect and page_len > 0;
(not exact; it should check the text field for presence of a '[' char)
-- brion vibber (brion @ pobox.com)
MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
mediawiki-l@lists.wikimedia.org