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: [email protected]
Reporter: [email protected]
Web browser: ---
Mobile Platform: ---
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
--
You are receiving this mail because:
You are on the CC list for the bug.
_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
