Last modified: 2013-02-16 17:56:32 UTC
Created attachment 11776 [details] 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.
Hi cs.saraswathi, which MediaWiki version is this problem about?
It is Mediawiki 1.12
Basically I feel some mismatch in timestamp format
We found that date format (YYYYMMDDHH24MISS) in Archive view was the issue. We updated the date format in schema and recreated the DB in 9.2 post which we were able to delete. But the challenge we see there are couple of tables for which data is not getting imported archive archive2 image imagelinks categorylinks externallinks filearchive logging oldimage Need some guidance on the same.
1.12 was released five years ago and is not supported anymore. Feel free to ask on https://www.mediawiki.org/wiki/Project:Support_desk and reopen this bug report if the problem still happens in a supported stable version (1.19 or 1.20). Thanks!