Last modified: 2010-05-15 18:03:52 UTC
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.
1052: Column is ambiguous
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.