https://bugzilla.wikimedia.org/show_bug.cgi?id=72850

Bug ID: 72850 Summary: MediaWiki 1.14.x and 1.15.x respond with DBQueryError to allusers with group parameter and auprop=groups Product: Pywikibot Version: core (2.0) Hardware: All OS: All Status: NEW Severity: normal Priority: Unprioritized Component: General Assignee: Pywikipedia-bugs@lists.wikimedia.org Reporter: jayvdb@gmail.com Web browser: --- Mobile Platform: ---

e.g. this fails

http://physics.lbl.gov/NuclearEnergy/api.php?action=query&list=allusers&...

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&...

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=...

{"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&aug...

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

http://glossary.reuters.com/api.php?action=query&list=allusers&augro...