Thread:Project:Support desk/I have no column « ar sha1 » in the mwi archive table, thus deletion of pages is impossible

Hi everyone !

I have a problem with the deletion of pages in my wiki. The version of MediaWiki is 1.19.0, the version of PHP is 5.2.17 (cgi), and the version of MySQL is 5.1.49-3-log.

I’m in the wiki as an administrator. I ask for the deletion of a page. Mediawiki asks me to confirm, I confirm, and then I have the following error message : « A database error has occurred. Did you forget to run maintenance/update.php after upgrading? See: https://www.mediawiki.org/wiki/Manual:Upgrading#Run_the_update_script Query: INSERT INTO `mwi_archive` (ar_namespace,ar_title,ar_comment,ar_user,ar_user_text,ar_timestamp,ar_minor_edit,ar_rev_id,ar_parent_id,ar_text_id,ar_text,ar_flags,ar_len,ar_page_id,ar_deleted,ar_sha1) SELECT page_namespace,page_title,rev_comment,rev_user,rev_user_text,rev_timestamp,rev_minor_edit,rev_id,rev_parent_id,rev_text_id,,,rev_len,page_id,rev_deleted,rev_sha1 FROM `mwi_page`,`mwi_revision` WHERE page_id = '3495' AND (page_id = rev_page) Function: WikiPage::doDeleteArticleReal Error: 1054 Unknown column 'ar_sha1' in 'field list' (mysql51-41.pro) »

I’ve checked what is the table mwi_archive for the 1.19 version of mediawiki : here is the table.

And it’s true I miss the last column « ar-sha1 » in the table mwi_archive in my database (I only have the 15 first columns). I don’t know why. I can add the column myself, with the settings indicated in the manual, but I’m not sure of the consequencies.

Do you think that adding manually the 16th column will solve the problem and will not compromise future updates of Mediawiki ?

Thank you.