https://bugzilla.wikimedia.org/show_bug.cgi?id=49523
[email protected] changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #1 from [email protected] --- 1) Special pages 2) File list 3) Choose one of images 4) delete all 5) Submit (delete) Database error Jump to: navigation, search A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was: SELECT rev_id,rev_page,rev_text_id,rev_timestamp,rev_comment,rev_user_text,rev_user,rev_minor_edit,rev_deleted,rev_len,rev_parent_id,rev_sha1,rev_content_format,rev_content_model,page_namespace,page_title,page_id,page_latest,page_is_redirect,page_len,user_name FROM "revision" INNER JOIN "page" ON ((page_id = rev_page)) LEFT JOIN "mwuser" ON ((rev_user != 0) AND (user_id = rev_user)) WHERE page_id = '10' AND rev_id = '44' LIMIT 1 FOR UPDATE from within function "Revision::fetchFromConds". Database returned error "0A000: ERROR: SELECT FOR UPDATE/SHARE cannot be applied to the nullable side of an outer join ". Backtrace: #0 /var/www/ideas/includes/db/DatabasePostgres.php(482): DatabaseBase->reportQueryError('ERROR: SELECT ...', '0A000', 'SELECT rev_id,...', 'Revision::fetch...', false) #1 /var/www/ideas/includes/db/Database.php(983): DatabasePostgres->reportQueryError('ERROR: SELECT ...', '0A000', 'SELECT rev_id,...', 'Revision::fetch...', false) #2 /var/www/ideas/includes/db/Database.php(1434): DatabaseBase->query('SELECT rev_id,...', 'Revision::fetch...') #3 /var/www/ideas/includes/Revision.php(372): DatabaseBase->select(Array, Array, Array, 'Revision::fetch...', Array, Array) #4 /var/www/ideas/includes/Revision.php(314): Revision::fetchFromConds(Object(DatabasePostgres), Array, 3) #5 /var/www/ideas/includes/Revision.php(294): Revision::loadFromConds(Object(DatabasePostgres), Array, 3) #6 /var/www/ideas/includes/Revision.php(143): Revision::newFromConds(Array, 3) #7 /var/www/ideas/includes/WikiPage.php(575): Revision::newFromPageId(10, 44, 3) #8 /var/www/ideas/includes/WikiPage.php(615): WikiPage->loadLastEdit() #9 /var/www/ideas/includes/WikiPage.php(2543): WikiPage->getContent(3) #10 /var/www/ideas/includes/FileDeleteForm.php(185): WikiPage->doDeleteArticleReal('', false, 0, false, '', Object(User)) #11 /var/www/ideas/includes/FileDeleteForm.php(110): FileDeleteForm::doDelete(Object(Title), Object(LocalFile), '', '', false, Object(User)) #12 /var/www/ideas/includes/ImagePage.php(875): FileDeleteForm->execute() #13 /var/www/ideas/includes/actions/DeleteAction.php(45): ImagePage->delete() #14 /var/www/ideas/includes/Wiki.php(439): DeleteAction->show() #15 /var/www/ideas/includes/Wiki.php(305): MediaWiki->performAction(Object(ImagePage), Object(Title)) #16 /var/www/ideas/includes/Wiki.php(565): MediaWiki->performRequest() #17 /var/www/ideas/includes/Wiki.php(458): MediaWiki->main() #18 /var/www/ideas/index.php(59): MediaWiki->run() #19 {main} Apache/2.2.16 (Debian) Linux 2.6.32-5-amd64 PHP Version 5.3.10-1 PostgreSQL 9.1.2 -- You are receiving this mail because: You are the assignee for the bug. You are on the CC list for the bug. _______________________________________________ Wikibugs-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/wikibugs-l
