Last modified: 2014-11-01 10:50:27 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 T74850, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 72850 - MediaWiki 1.12-15 respond with DBQueryError to allusers with group parameter and auprop=groups
MediaWiki 1.12-15 respond with DBQueryError to allusers with group parameter ...
Status: NEW
Product: Pywikibot
Classification: Unclassified
General (Other open bugs)
core-(2.0)
All All
: Unprioritized normal
: ---
Assigned To: Pywikipedia bugs
:
Depends on:
Blocks: pwb-oldmw
  Show dependency treegraph
 
Reported: 2014-11-01 06:39 UTC by John Mark Vandenberg
Modified: 2014-11-01 10:50 UTC (History)
0 users

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


Attachments

Description John Mark Vandenberg 2014-11-01 06:39:01 UTC
e.g. this fails

http://physics.lbl.gov/NuclearEnergy/api.php?action=query&list=allusers&augroup=bot&format=json&auprefix=D&aufrom=%21&auprop=editcount%7Cgroups%7Cregistration

API response received:
{"error":{"code":"internal_api_error_DBQueryError","info":"Database query error","*":""}}

but this succeeds:

http://physics.lbl.gov/NuclearEnergy/api.php?action=query&list=allusers&augroup=bot&format=json&auprefix=D&aufrom=%21&auprop=editcount%7Cregistration

by default pywikibot requests auprop=groups, causing tests to fail on wiki 1.12-1.15 at least ; MW fixed in 1.16.

More info on the error from 1.12.4

http://rnf.fisica.org.ar/api.php?action=query&list=allusers&augroup=bot&format=json&auprefix=D&aufrom=%21&auprop=editcount%7Cgroups%7Cregistration

{"error":{"code":"internal_api_error_DBUnexpectedError","info":"Exception Caught: A database error has occurred\nQuery: SELECT  ug2.ug_group ug_group2,user_registration,user_name,user_editcount  FROM mwuser INNER JOIN user_groups ug1 ON ug1.ug_user=user_id LEFT JOIN user_groups ug2 ON ug2.ug_user=user_id  WHERE (user_name >= '!') AND (user_name LIKE \"D%\") AND ug1.ug_group = 'bot'  ORDER BY user_name LIMIT 14  \nFunction: ApiQueryAllUsers::execute\nError: 1 ERROR:  column \"D%\" does not exist\nLINE 1: ..._id  WHERE (user_name >= '!') AND (user_name LIKE \"D%\") AND ...\n                                                             ^\n","*":"\n\n#0 \/home\/afa\/webapps\/rnf_wiki\/includes\/Database.php(799): DatabasePostgres->reportQueryError('ERROR:  column ...', 1, 'SELECT  ug2.ug_...', 'ApiQueryAllUser...', false)\n#1 \/home\/afa\/webapps\/rnf_wiki\/includes\/Database.php(1244): Database->query('SELECT  ug2.ug_...', 'ApiQueryAllUser...')\n#2 \/home\/afa\/webapps\/rnf_wiki\/includes\/api\/ApiQueryBase.php(131): Database->select(Array, Array, Array, 'ApiQueryAllUser...', Array)\n#3 \/home\/afa\/webapps\/rnf_wiki\/includes\/api\/ApiQueryAllUsers.php(96): ApiQueryBase->select('ApiQueryAllUser...')\n#4 \/home\/afa\/webapps\/rnf_wiki\/includes\/api\/ApiQuery.php(209): ApiQueryAllUsers->execute()\n#5 \/home\/afa\/webapps\/rnf_wiki\/includes\/api\/ApiMain.php(355): ApiQuery->execute()\n#6 \/home\/afa\/webapps\/rnf_wiki\/includes\/api\/ApiMain.php(223): ApiMain->executeAction()\n#7 \/home\/afa\/webapps\/rnf_wiki\/includes\/api\/ApiMain.php(208): ApiMain->executeActionWithErrorHandling()\n#8 \/home\/afa\/webapps\/rnf_wiki\/api.php(77): ApiMain->execute()\n#9 {main}\n\n"}}

Strangely, another 1.12.4 site doesnt error:
https://wiki.umsl.edu/vcities/api.php?action=query&list=allusers&augroup=sysop&format=json&auprefix=D&aufrom=%21&auprop=editcount%7Cgroups%7Cregistration

1.11 has a different problem, in that it doesnt recognise the 'registration' auprop.

http://glossary.reuters.com/api.php?action=query&list=allusers&augroup=sysop&format=json&auprefix=D&aufrom=%21&auprop=editcount%7Cgroups%7Cregistration
Comment 1 Gerrit Notification Bot 2014-11-01 09:25:29 UTC
Change 170514 had a related patch set uploaded by John Vandenberg:
Split the allusers test into multiple tests

https://gerrit.wikimedia.org/r/170514
Comment 2 Gerrit Notification Bot 2014-11-01 10:22:57 UTC
Change 170514 merged by jenkins-bot:
Split the allusers test into multiple tests

https://gerrit.wikimedia.org/r/170514

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


Navigation
Links