Page MenuHomePhabricator

list=allusers with prop=blockinfo and witheditsonly gives error
Closed, ResolvedPublic

Description

For the added url, I get a api-error.

<?xml version="1.0"?>
<api>

<error code="internal_api_error_DBQueryError" info="Database query error" xml:space="preserve">

#0 /usr/local/apache/common-local/wmf-deployment/includes/db/Database.php(538): DatabaseBase->reportQueryError('Column 'user_ed...', 1052, 'SELECT ipb_rea...', 'ApiQueryAllUser...', false)
#1 /usr/local/apache/common-local/wmf-deployment/includes/db/Database.php(874): DatabaseBase->query('SELECT ipb_rea...', 'ApiQueryAllUser...')
#2 /usr/local/apache/common-local/wmf-deployment/includes/api/ApiQueryBase.php(233): DatabaseBase->select(Array, Array, Array, 'ApiQueryAllUser...', Array, Array)
#3 /usr/local/apache/common-local/wmf-deployment/includes/api/ApiQueryAllUsers.php(114): ApiQueryBase->select('ApiQueryAllUser...')
#4 /usr/local/apache/common-local/wmf-deployment/includes/api/ApiQuery.php(224): ApiQueryAllUsers->execute()
#5 /usr/local/apache/common-local/wmf-deployment/includes/api/ApiMain.php(478): ApiQuery->execute()
#6 /usr/local/apache/common-local/wmf-deployment/includes/api/ApiMain.php(267): ApiMain->executeAction()
#7 /usr/local/apache/common-local/wmf-deployment/includes/api/ApiMain.php(251): ApiMain->executeActionWithErrorHandling()
#8 /usr/local/apache/common-local/wmf-deployment/api.php(116): ApiMain->execute()
#9 /usr/local/apache/common-local/live-1.5/api.php(3): require('/usr/local/apac...')
#10 {main}

</error>
</api>

Thanks.


Version: unspecified
Severity: enhancement
URL: http://en.wikipedia.org/w/api.php?action=query&list=allusers&auprop=blockinfo&auwitheditsonly

Details

Reference
bz23534

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 21 2014, 11:02 PM
bzimport set Reference to bz23534.

Bryan.TongMinh wrote:

1052: Column is ambiguous

Bryan.TongMinh wrote:

SELECT /* ApiQueryAllUsers::execute */ ipb_reason,u2.user_name AS blocker_name,u1.user_name FROM user u1 FORCE INDEX (user_name) LEFT JOIN ipblocks ON ((ipb_user=u1.user_id)) LEFT JOIN user u2 ON ((ipb_by=u2.user_id)) WHERE (user_editcount > 0) ORDER BY u1.user_name LIMIT 11

Fixed in r66486, fix deployed.