https://bugzilla.wikimedia.org/show_bug.cgi?id=56174
Web browser: ---
Bug ID: 56174
Summary: SQL postgres error while deleting files
Product: MediaWiki
Version: 1.22-git
Hardware: All
OS: Linux
Status: UNCONFIRMED
Severity: major
Priority: Unprioritized
Component: Database
Assignee: [email protected]
Reporter: [email protected]
Classification: Unclassified
Mobile Platform: ---
Mediawiki-REL1.22 (git). Postgresql 9.3.1 as database server on CentOs 6.4.
When deleting a file (any uploaded file) the following SQL error occurs:
Query:
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 = '40' AND rev_id =
'107' LIMIT 1 FOR UPDATE
Function: Revision::fetchFromConds
Error: 0A000 ERROR: FOR UPDATE cannot be applied to the nullable side of an
outer join
Files remain in the system and can not be deleted.
I guess this SQL works under mysql but not in progres. I am not familiar with
the mediawiki code, but happy to look and figure out how SQL-backend specifics
are dealt with.
--
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
