mahara-contributors team mailing list archive

[Robert Lyon <robertl@xxxxxxxxxxxxxxx>]

Ideally, now that the htdocs/lib/db/upgrade.php file is getting quite
long it would be neater if we could split it up into versions

so have:
...
htdocs/lib/db/upgrade/1_7.php
htdocs/lib/db/upgrade/1_8.php
htdocs/lib/db/upgrade/1_9.php
...

we could possibly get it so that if something needs to be backported
from 1_9 to 1_8 we only need to add the code change once somehow. [ I've
not worked out how yet :) ]

-- 
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/1288490

Title:
  upgrade from 1.8 error

Status in Mahara ePortfolio:
  Confirmed

Bug description:
  when I upgrade from 1.8_STABLE to 1.9dev I get this error:

   Could not execute command: ALTER TABLE usr_custom_layout ADD CONSTRAINT usrcustlayo_gro_fk FOREIGN KEY (`group`) REFERENCES `group` (id)
  Call stack (most recent first):

      execute_sql("ALTER TABLE usr_custom_layout ADD CONSTRAINT usrcu...") at /home/robertl/htdocs/mahara-devel/mahara/htdocs/lib/dml.php:1388
      execute_sql_arr(array(size 1), true, true) at /home/robertl/htdocs/mahara-devel/mahara/htdocs/lib/ddl.php:1210
      add_key(object(XMLDBTable), object(XMLDBKey)) at /home/robertl/htdocs/mahara-devel/mahara/htdocs/lib/db/upgrade.php:2937
      xmldb_core_upgrade("2013101408") at /home/robertl/htdocs/mahara-devel/mahara/htdocs/lib/upgrade.php:295
      upgrade_core(object(stdClass)) at /home/robertl/htdocs/mahara-devel/mahara/htdocs/admin/upgrade.json.php:78

  This is because a fix 09b2f5ba730d4d03950c713c1baaf1cb3174cde2 was
  added to master and also backported to 1.8

  The version in master needs to check if foreign keys already exist or
  not.

To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1288490/+subscriptions