** Changed in: mahara/16.10 Status: Fix Committed => Fix Released
-- You received this bug notification because you are a member of Mahara Contributors, which is subscribed to Mahara. Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before editing or unsubscribing it! https://bugs.launchpad.net/bugs/1651011 Title: Issue upgrading Mahara site to 17.04dev Status in Mahara: Fix Committed Status in Mahara 16.10 series: Fix Released Bug description: This issue arose from bug #1647885. The upgrade fails because the primary key is incorrect in the table artefact_file_mime_types Robert sayd: Rather than dropping and re-creating the table, it would be better to truncate the table and change the primary key. That way, the table structure stays the same. To replicate: 1. Install 16.04 and go through the regular setup steps. 2. Upgrade to master Expected result: The upgrade completes. Actual result: Upgrade fails on artefact.file with the following error message, which can only be seen when you attempt to run the upgrade again: [DBG] 0e (artefact/file/db/upgrade.php:446) Drop the old primary key constraint and add new id column from/to the table artefact_file_mime_types [DBG] 0e (lib/dml.php:157) postgres8 error: [-1: ERROR: multiple primary keys for table "artefact_file_mime_types" are not allowed] in adodb_throw(ALTER TABLE "artefact_file_mime_types" DROP CONSTRAINT IF EXISTS "artefilemimetype_mim_pk", ADD COLUMN id SERIAL PRIMARY KEY, ) Command was: ALTER TABLE "artefact_file_mime_types" DROP CONSTRAINT IF EXISTS "artefilemimetype_mim_pk", ADD COLUMN id SERIAL PRIMARY KEY [WAR] 0e (lib/errors.php:859) Could not execute command: ALTER TABLE "artefact_file_mime_types" DROP CONSTRAINT IF EXISTS "artefilemimetype_mim_pk", ADD COLUMN id SERIAL PRIMARY KEY Call stack (most recent first): log_message(string(size 207), integer, true, true) at /home/kristina/code/mahara/htdocs/lib/errors.php:95 log_warn(string(size 207)) at /home/kristina/code/mahara/htdocs/lib/errors.php:859 SQLException->__construct(string(size 207)) at /home/kristina/code/mahara/htdocs/lib/dml.php:158 execute_sql(string(size 180)) at /home/kristina/code/mahara/htdocs/artefact/file/db/upgrade.php:450 xmldb_artefact_file_upgrade(string(size 10)) at /home/kristina/code/mahara/htdocs/lib/upgrade.php:423 upgrade_plugin(object(stdClass)) at /home/kristina/code/mahara/htdocs/admin/upgrade.json.php:87 To manage notifications about this bug go to: https://bugs.launchpad.net/mahara/+bug/1651011/+subscriptions _______________________________________________ Mailing list: https://launchpad.net/~mahara-contributors Post to : mahara-contributors@lists.launchpad.net Unsubscribe : https://launchpad.net/~mahara-contributors More help : https://help.launchpad.net/ListHelp