Last modified: 2013-10-25 18:56:12 UTC
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:
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
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.
*** This bug has been marked as a duplicate of bug 49523 ***