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(a)lists.wikimedia.org Reporter: jayvdb(a)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&au… 1.11 has a different problem, in that it doesnt recognise the 'registration' auprop. http://glossary.reuters.com/api.php?action=query&list=allusers&augr… -- You are receiving this mail because: You are the assignee for the bug.