Last modified: 2009-10-22 15:51:41 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T23006, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 21006 - Regression: updateArticleCount.php --update option doesn't work
Regression: updateArticleCount.php --update option doesn't work
Status: RESOLVED FIXED
Product: MediaWiki
Classification: Unclassified
Maintenance scripts (Other open bugs)
unspecified
All All
: Normal enhancement (vote)
: ---
Assigned To: Chad H.
:
Depends on:
Blocks: 20998
  Show dependency treegraph
 
Reported: 2009-10-05 16:19 UTC by Brion Vibber
Modified: 2009-10-22 15:51 UTC (History)
2 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Brion Vibber 2009-10-05 16:19:35 UTC
Looks like another regression in option processing; updateArticleCount is no longer recognizing the --update option which is required for it to actually save its udpates to the database:

$ php maintenance/updateArticleCount.php --update
Counting articles...found 60.
To update the site statistics table, run the script with the --update option.

This is blocking site maintenance such as request for count rebuild in bug 20998.
Comment 1 OverlordQ 2009-10-05 16:38:01 UTC
Swear I posted this in a bug already but cannot find it; the query itself is broken for PG.

==
Query: SELECT COUNT(DISTINCT page_namespace, page_title) AS pagecount FROM page, pagelinks WHERE pl_from=page_id and page_namespace IN ( 0 ) AND page_is_redirect = 0 AND page_len > 0
Function: UpdateArticleCount::count
Error: 1 ERROR:  function count(smallint, text) does not exist
LINE 1: SELECT /* UpdateArticleCount::count  */ COUNT(DISTINCT page_...
                                                ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
==

Comment 2 Alexandre Emsenhuber [IAlex] 2009-10-05 19:15:06 UTC
Fixed Brion's bug in r57392.
Comment 3 Alexandre Emsenhuber [IAlex] 2009-10-22 15:51:41 UTC
And fixed in r58015.

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links