https://bugzilla.wikimedia.org/show_bug.cgi?id=44941
Web browser: --- Bug ID: 44941 Summary: Error while deleting a page Product: MediaWiki Version: 1.12.x Hardware: All OS: All Status: UNCONFIRMED Severity: normal Priority: Unprioritized Component: Database Assignee: wikibugs-l@lists.wikimedia.org Reporter: cs.saraswa...@tcs.com CC: wikibugs-l@lists.wikimedia.org Classification: Unclassified Mobile Platform: --- Created attachment 11776 --> https://bugzilla.wikimedia.org/attachment.cgi?id=11776&action=edit Page Deletion error We recently migrated from Postgres 8.2 version to Postgres9.2 version. Post which we find we are unable to delete the page and giving a Database Error A database error has occurred Query: INSERT INTO archive (ar_namespace,ar_title,ar_comment,ar_user,ar_user_text,ar_timestamp,ar_minor_edit,ar_rev_id,ar_text_id,ar_text,ar_fl ags,ar_len,ar_page_id) SELECT page_namespace,page_title,rev_comment,rev_user,rev_user_text,rev_timestamp,rev_minor_edit,rev_id,rev_text_id,'','',r ev_len,page_id FROM page,revision WHERE page_id = '71036' AND (page_id = rev_page) Function: Article::doDeleteArticle Error: 1 ERROR: cannot insert into view "archive" HINT: You need an unconditional ON INSERT DO INSTEAD rule or an INSTEAD OF INSERT trigger. We ran update.php as well. Please let me know if there is a solution for the same. -- You are receiving this mail because: You are on the CC list for the bug. You are the assignee for the bug. You are watching all bug changes. _______________________________________________ Wikibugs-l mailing list Wikibugs-l@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/wikibugs-l