26 June 2012, 9:01

Hi All

I'm having a problem upgrading from 1.4.0 to 1.5.1.  We are running the following: -

Ubuntu 10.10 (Maverick) 64 bit
MySQL 5.5.24

I'm getting an error - Could not execute command ALTER TABLE 'group' ADD CONSTRAINT.....

Here is a screenshot of the error - http://i48.tinypic.com/no6m4h.jpg

My apache error log is below.  It seems to be complaining about an allowed memory size?

[Tue Jun 26 12:49:12 2012] [error] [client 192.168.42.56] PHP Fatal error:  Allowed memory size of 268435456 bytes exhausted (tried to allocate 61605264 bytes) in /var/www/lib/adodb/adodb.inc.php on line 974, referer: http://mahara.somedomain.ac.uk/admin/upgrade.php
[Tue Jun 26 12:49:17 2012] [error] [client 192.168.42.56] [DBG] 08 (auth/user.php:1206) Destroying user with un-committed changes, referer: http://mahara.somedomain.ac.uk/admin/upgrade.php
[Tue Jun 26 12:49:18 2012] [error] [client 192.168.42.56] [WAR] 63 (lib/web.php:2758) include_once(/var/www/lib/htmlpurifiercustom/YouTubeIframe.php): failed to open stream: No such file or directory, referer: http://mahara.somedomain.ac.uk/admin/upgrade.php
[Tue Jun 26 12:49:18 2012] [error] [client 192.168.42.56] Call stack (most recent first):, referer: http://mahara.somedomain.ac.uk/admin/upgrade.php
[Tue Jun 26 12:49:18 2012] [error] [client 192.168.42.56]   * log_message("include_once(/var/www/lib/htmlpurifiercustom/YouTu...", 8, true, true, "/var/www/lib/web.php", 2758) at /var/www/lib/errors.php:446, referer: http://mahara.somedomain.ac.uk/admin/upgrade.php
[Tue Jun 26 12:49:18 2012] [error] [client 192.168.42.56]   * error(2, "include_once(/var/www/lib/htmlpurifiercustom/YouTu...", "/var/www/lib/web.php", 2758, array(size 8)) at /var/www/lib/web.php:2758, referer: http://mahara.somedomain.ac.uk/admin/upgrade.php
[Tue Jun 26 12:49:18 2012] [error] [client 192.168.42.56]   * clean_html() at /var/www/lib/web.php:2758, referer: http://mahara.somedomain.ac.uk/admin/upgrade.php
[Tue Jun 26 12:49:18 2012] [error] [client 192.168.42.56]   * clean_html("<h2 align="center"><font color="#0000ff">Meddwl</f...") at /var/maharadata/dwoo/compile/aqua/var/www/theme/raw/templates/index.tpl.d17.php:8, referer: http://mahara.somedomain.ac.uk/admin/upgrade.php
[Tue Jun 26 12:49:18 2012] [error] [client 192.168.42.56]   * include("/var/maharadata/dwoo/compile/aqua/var/www/theme/ra...") at /var/www/lib/dwoo/dwoo/Dwoo.php:364, referer: http://mahara.somedomain.ac.uk/admin/upgrade.php
[Tue Jun 26 12:49:18 2012] [error] [client 192.168.42.56]   * Dwoo->get(object(Dwoo_Template_File), array(size 24)) at /var/www/lib/dwoo/mahara/Dwoo_Mahara.php:118, referer: http://mahara.somedomain.ac.uk/admin/upgrade.php
[Tue Jun 26 12:49:18 2012] [error] [client 192.168.42.56]   * Dwoo_Mahara->fetch("index.tpl") at /var/www/lib/dwoo/mahara/Dwoo_Mahara.php:105, referer: http://mahara.somedomain.ac.uk/admin/upgrade.php
[Tue Jun 26 12:49:18 2012] [error] [client 192.168.42.56]   * Dwoo_Mahara->display("index.tpl") at /var/www/index.php:110, referer: http://mahara.somedomain.ac.uk/admin/upgrade.php
[Tue Jun 26 12:49:18 2012] [error] [client 192.168.42.56] , referer: http://mahara.somedomain.ac.uk/admin/upgrade.php
[Tue Jun 26 12:49:18 2012] [error] [client 192.168.42.56] [WAR] 63 (lib/web.php:2758) include_once(): Failed opening '/var/www/lib/htmlpurifiercustom/YouTubeIframe.php' for inclusion (include_path='/var/www/lib/htmlpurifier:/var/www/lib/:/var/www/lib/pear/:.:/usr/share/php:/usr/share/pear'), referer: http://mahara.somedomain.ac.uk/admin/upgrade.php
[Tue Jun 26 12:49:18 2012] [error] [client 192.168.42.56] Call stack (most recent first):, referer: http://mahara.somedomain.ac.uk/admin/upgrade.php
[Tue Jun 26 12:49:18 2012] [error] [client 192.168.42.56]   * log_message("include_once(): Failed opening '/var/www/lib/htmlp...", 8, true, true, "/var/www/lib/web.php", 2758) at /var/www/lib/errors.php:446, referer: http://mahara.somedomain.ac.uk/admin/upgrade.php
[Tue Jun 26 12:49:18 2012] [error] [client 192.168.42.56]   * error(2, "include_once(): Failed opening '/var/www/lib/htmlp...", "/var/www/lib/web.php", 2758, array(size 8)) at /var/www/lib/web.php:2758, referer: http://mahara.somedomain.ac.uk/admin/upgrade.php
[Tue Jun 26 12:49:18 2012] [error] [client 192.168.42.56]   * clean_html() at /var/www/lib/web.php:2758, referer: http://mahara.somedomain.ac.uk/admin/upgrade.php
[Tue Jun 26 12:49:18 2012] [error] [client 192.168.42.56]   * clean_html("<h2 align="center"><font color="#0000ff">Meddwl</f...") at /var/maharadata/dwoo/compile/aqua/var/www/theme/raw/templates/index.tpl.d17.php:8, referer: http://mahara.somedomain.ac.uk/admin/upgrade.php
[Tue Jun 26 12:49:18 2012] [error] [client 192.168.42.56]   * include("/var/maharadata/dwoo/compile/aqua/var/www/theme/ra...") at /var/www/lib/dwoo/dwoo/Dwoo.php:364, referer: http://mahara.somedomain.ac.uk/admin/upgrade.php
[Tue Jun 26 12:49:18 2012] [error] [client 192.168.42.56]   * Dwoo->get(object(Dwoo_Template_File), array(size 24)) at /var/www/lib/dwoo/mahara/Dwoo_Mahara.php:118, referer: http://mahara.somedomain.ac.uk/admin/upgrade.php
[Tue Jun 26 12:49:18 2012] [error] [client 192.168.42.56]   * Dwoo_Mahara->fetch("index.tpl") at /var/www/lib/dwoo/mahara/Dwoo_Mahara.php:105, referer: http://mahara.somedomain.ac.uk/admin/upgrade.php
[Tue Jun 26 12:49:18 2012] [error] [client 192.168.42.56]   * Dwoo_Mahara->display("index.tpl") at /var/www/index.php:110, referer: http://mahara.somedomain.ac.uk/admin/upgrade.php
[Tue Jun 26 12:49:18 2012] [error] [client 192.168.42.56] , referer: http://mahara.somedomain.ac.uk/admin/upgrade.php
[Tue Jun 26 12:49:45 2012] [error] [client 192.168.42.56] [WAR] b9 (lib/web.php:2758) include_once(/var/www/lib/htmlpurifiercustom/YouTubeIframe.php): failed to open stream: No such file or directory, referer: http://moodle.somedomain.ac.uk/moodle/myview/
[Tue Jun 26 12:49:45 2012] [error] [client 192.168.42.56] Call stack (most recent first):, referer: http://moodle.somedomain.ac.uk/moodle/myview/
[Tue Jun 26 12:49:45 2012] [error] [client 192.168.42.56]   * log_message("include_once(/var/www/lib/htmlpurifiercustom/YouTu...", 8, true, true, "/var/www/lib/web.php", 2758) at /var/www/lib/errors.php:446, referer: http://moodle.somedomain.ac.uk/moodle/myview/
[Tue Jun 26 12:49:45 2012] [error] [client 192.168.42.56]   * error(2, "include_once(/var/www/lib/htmlpurifiercustom/YouTu...", "/var/www/lib/web.php", 2758, array(size 8)) at /var/www/lib/web.php:2758, referer: http://moodle.somedomain.ac.uk/moodle/myview/
[Tue Jun 26 12:49:45 2012] [error] [client 192.168.42.56]   * clean_html() at /var/www/lib/web.php:2758, referer: http://moodle.somedomain.ac.uk/moodle/myview/
[Tue Jun 26 12:49:45 2012] [error] [client 192.168.42.56]   * clean_html("<h2 align="center"><font color="#0000ff">Meddwl</f...") at /var/maharadata/dwoo/compile/aqua/var/www/theme/raw/templates/index.tpl.d17.php:8, referer: http://moodle.somedomain.ac.uk/moodle/myview/
[Tue Jun 26 12:49:45 2012] [error] [client 192.168.42.56]   * include("/var/maharadata/dwoo/compile/aqua/var/www/theme/ra...") at /var/www/lib/dwoo/dwoo/Dwoo.php:364, referer: http://moodle.somedomain.ac.uk/moodle/myview/
[Tue Jun 26 12:49:45 2012] [error] [client 192.168.42.56]   * Dwoo->get(object(Dwoo_Template_File), array(size 24)) at /var/www/lib/dwoo/mahara/Dwoo_Mahara.php:118, referer: http://moodle.somedomain.ac.uk/moodle/myview/
[Tue Jun 26 12:49:45 2012] [error] [client 192.168.42.56]   * Dwoo_Mahara->fetch("index.tpl") at /var/www/lib/dwoo/mahara/Dwoo_Mahara.php:105, referer: http://moodle.somedomain.ac.uk/moodle/myview/
[Tue Jun 26 12:49:45 2012] [error] [client 192.168.42.56]   * Dwoo_Mahara->display("index.tpl") at /var/www/index.php:110, referer: http://moodle.somedomain.ac.uk/moodle/myview/
[Tue Jun 26 12:49:45 2012] [error] [client 192.168.42.56] , referer: http://moodle.somedomain.ac.uk/moodle/myview/
[Tue Jun 26 12:49:45 2012] [error] [client 192.168.42.56] [WAR] b9 (lib/web.php:2758) include_once(): Failed opening '/var/www/lib/htmlpurifiercustom/YouTubeIframe.php' for inclusion (include_path='/var/www/lib/htmlpurifier:/var/www/lib/:/var/www/lib/pear/:.:/usr/share/php:/usr/share/pear'), referer: http://moodle.somedomain.ac.uk/moodle/myview/
[Tue Jun 26 12:49:45 2012] [error] [client 192.168.42.56] Call stack (most recent first):, referer: http://moodle.somedomain.ac.uk/moodle/myview/
[Tue Jun 26 12:49:45 2012] [error] [client 192.168.42.56]   * log_message("include_once(): Failed opening '/var/www/lib/htmlp...", 8, true, true, "/var/www/lib/web.php", 2758) at /var/www/lib/errors.php:446, referer: http://moodle.somedomain.ac.uk/moodle/myview/
[Tue Jun 26 12:49:45 2012] [error] [client 192.168.42.56]   * error(2, "include_once(): Failed opening '/var/www/lib/htmlp...", "/var/www/lib/web.php", 2758, array(size 8)) at /var/www/lib/web.php:2758, referer: http://moodle.somedomain.ac.uk/moodle/myview/
[Tue Jun 26 12:49:45 2012] [error] [client 192.168.42.56]   * clean_html() at /var/www/lib/web.php:2758, referer: http://moodle.somedomain.ac.uk/moodle/myview/
[Tue Jun 26 12:49:45 2012] [error] [client 192.168.42.56]   * clean_html("<h2 align="center"><font color="#0000ff">Meddwl</f...") at /var/maharadata/dwoo/compile/aqua/var/www/theme/raw/templates/index.tpl.d17.php:8, referer: http://moodle.somedomain.ac.uk/moodle/myview/
[Tue Jun 26 12:49:45 2012] [error] [client 192.168.42.56]   * include("/var/maharadata/dwoo/compile/aqua/var/www/theme/ra...") at /var/www/lib/dwoo/dwoo/Dwoo.php:364, referer: http://moodle.somedomain.ac.uk/moodle/myview/
[Tue Jun 26 12:49:45 2012] [error] [client 192.168.42.56]   * Dwoo->get(object(Dwoo_Template_File), array(size 24)) at /var/www/lib/dwoo/mahara/Dwoo_Mahara.php:118, referer: http://moodle.somedomain.ac.uk/moodle/myview/
[Tue Jun 26 12:49:45 2012] [error] [client 192.168.42.56]   * Dwoo_Mahara->fetch("index.tpl") at /var/www/lib/dwoo/mahara/Dwoo_Mahara.php:105, referer: http://moodle.somedomain.ac.uk/moodle/myview/
[Tue Jun 26 12:49:45 2012] [error] [client 192.168.42.56]   * Dwoo_Mahara->display("index.tpl") at /var/www/index.php:110, referer: http://moodle.somedomain.ac.uk/moodle/myview/
[Tue Jun 26 12:49:45 2012] [error] [client 192.168.42.56] , referer: http://moodle.somedomain.ac.uk/moodle/myview/
[Tue Jun 26 12:49:48 2012] [error] [client 192.168.42.56] [DBG] cd (admin/upgrade.php:98) Not upgrading; unfinished upgrade from 2012/06/26 12:49 still in progress, referer: http://mahara.somedomain.ac.uk/
[Tue Jun 26 12:49:49 2012] [error] [client 192.168.42.56] [WAR] cd (lib/web.php:2758) include_once(/var/www/lib/htmlpurifiercustom/YouTubeIframe.php): failed to open stream: No such file or directory, referer: http://mahara.somedomain.ac.uk/
[Tue Jun 26 12:49:49 2012] [error] [client 192.168.42.56] Call stack (most recent first):, referer: http://mahara.somedomain.ac.uk/
[Tue Jun 26 12:49:49 2012] [error] [client 192.168.42.56]   * log_message("include_once(/var/www/lib/htmlpurifiercustom/YouTu...", 8, true, true, "/var/www/lib/web.php", 2758) at /var/www/lib/errors.php:446, referer: http://mahara.somedomain.ac.uk/
[Tue Jun 26 12:49:49 2012] [error] [client 192.168.42.56]   * error(2, "include_once(/var/www/lib/htmlpurifiercustom/YouTu...", "/var/www/lib/web.php", 2758, array(size 8)) at /var/www/lib/web.php:2758, referer: http://mahara.somedomain.ac.uk/
[Tue Jun 26 12:49:49 2012] [error] [client 192.168.42.56]   * clean_html() at /var/www/lib/web.php:2758, referer: http://mahara.somedomain.ac.uk/
[Tue Jun 26 12:49:49 2012] [error] [client 192.168.42.56]   * clean_html("An upgrade began at 2012/06/26 12:49 and did not c...") at /var/maharadata/dwoo/compile/default/var/www/theme/raw/templates/message.tpl.d17.php:10, referer: http://mahara.somedomain.ac.uk/
[Tue Jun 26 12:49:49 2012] [error] [client 192.168.42.56]   * include("/var/maharadata/dwoo/compile/default/var/www/theme...") at /var/www/lib/dwoo/dwoo/Dwoo.php:364, referer: http://mahara.somedomain.ac.uk/
[Tue Jun 26 12:49:49 2012] [error] [client 192.168.42.56]   * Dwoo->get(object(Dwoo_Template_File), array(size 20)) at /var/www/lib/dwoo/mahara/Dwoo_Mahara.php:118, referer: http://mahara.somedomain.ac.uk/
[Tue Jun 26 12:49:49 2012] [error] [client 192.168.42.56]   * Dwoo_Mahara->fetch("message.tpl") at /var/www/lib/dwoo/mahara/Dwoo_Mahara.php:105, referer: http://mahara.somedomain.ac.uk/
[Tue Jun 26 12:49:49 2012] [error] [client 192.168.42.56]   * Dwoo_Mahara->display("message.tpl") at /var/www/lib/errors.php:387, referer: http://mahara.somedomain.ac.uk/
[Tue Jun 26 12:49:49 2012] [error] [client 192.168.42.56]   * die_info("An upgrade began at 2012/06/26 12:49 and did not c...") at /var/www/admin/upgrade.php:99, referer: http://mahara.somedomain.ac.uk/
[Tue Jun 26 12:49:49 2012] [error] [client 192.168.42.56] , referer: http://mahara.somedomain.ac.uk/
[Tue Jun 26 12:49:49 2012] [error] [client 192.168.42.56] [WAR] cd (lib/web.php:2758) include_once(): Failed opening '/var/www/lib/htmlpurifiercustom/YouTubeIframe.php' for inclusion (include_path='/var/www/lib/htmlpurifier:/var/www/lib/:/var/www/lib/pear/:.:/usr/share/php:/usr/share/pear'), referer: http://mahara.somedomain.ac.uk/
[Tue Jun 26 12:49:49 2012] [error] [client 192.168.42.56] Call stack (most recent first):, referer: http://mahara.somedomain.ac.uk/
[Tue Jun 26 12:49:49 2012] [error] [client 192.168.42.56]   * log_message("include_once(): Failed opening '/var/www/lib/htmlp...", 8, true, true, "/var/www/lib/web.php", 2758) at /var/www/lib/errors.php:446, referer: http://mahara.somedomain.ac.uk/
[Tue Jun 26 12:49:49 2012] [error] [client 192.168.42.56]   * error(2, "include_once(): Failed opening '/var/www/lib/htmlp...", "/var/www/lib/web.php", 2758, array(size 8)) at /var/www/lib/web.php:2758, referer: http://mahara.somedomain.ac.uk/
[Tue Jun 26 12:49:49 2012] [error] [client 192.168.42.56]   * clean_html() at /var/www/lib/web.php:2758, referer: http://mahara.somedomain.ac.uk/
[Tue Jun 26 12:49:49 2012] [error] [client 192.168.42.56]   * clean_html("An upgrade began at 2012/06/26 12:49 and did not c...") at /var/maharadata/dwoo/compile/default/var/www/theme/raw/templates/message.tpl.d17.php:10, referer: http://mahara.somedomain.ac.uk/
[Tue Jun 26 12:49:49 2012] [error] [client 192.168.42.56]   * include("/var/maharadata/dwoo/compile/default/var/www/theme...") at /var/www/lib/dwoo/dwoo/Dwoo.php:364, referer: http://mahara.somedomain.ac.uk/
[Tue Jun 26 12:49:49 2012] [error] [client 192.168.42.56]   * Dwoo->get(object(Dwoo_Template_File), array(size 20)) at /var/www/lib/dwoo/mahara/Dwoo_Mahara.php:118, referer: http://mahara.somedomain.ac.uk/
[Tue Jun 26 12:49:49 2012] [error] [client 192.168.42.56]   * Dwoo_Mahara->fetch("message.tpl") at /var/www/lib/dwoo/mahara/Dwoo_Mahara.php:105, referer: http://mahara.somedomain.ac.uk/
[Tue Jun 26 12:49:49 2012] [error] [client 192.168.42.56]   * Dwoo_Mahara->display("message.tpl") at /var/www/lib/errors.php:387, referer: http://mahara.somedomain.ac.uk/
[Tue Jun 26 12:49:49 2012] [error] [client 192.168.42.56]   * die_info("An upgrade began at 2012/06/26 12:49 and did not c...") at /var/www/admin/upgrade.php:99, referer: http://mahara.somedomain.ac.uk/
[Tue Jun 26 12:49:49 2012] [error] [client 192.168.42.56] , referer: http://mahara.somedomain.ac.uk/
[Tue Jun 26 12:49:52 2012] [error] [client 192.168.42.56] [DBG] c9 (lib/mahara.php:1492) Field ctime exists. Create skipped, referer: http://mahara.somedomain.ac.uk/admin/upgrade.php?rerun=1
[Tue Jun 26 12:49:52 2012] [error] [client 192.168.42.56] [DBG] c9 (lib/mahara.php:1492) Field defaultquota exists. Create skipped, referer: http://mahara.somedomain.ac.uk/admin/upgrade.php?rerun=1
[Tue Jun 26 12:49:53 2012] [error] [client 192.168.42.56] [DBG] c9 (lib/mahara.php:1492) Field quota exists. Create skipped, referer: http://mahara.somedomain.ac.uk/admin/upgrade.php?rerun=1
[Tue Jun 26 12:49:53 2012] [error] [client 192.168.42.56] [DBG] c9 (lib/mahara.php:1492) Field quotaused exists. Create skipped, referer: http://mahara.somedomain.ac.uk/admin/upgrade.php?rerun=1
[Tue Jun 26 12:49:53 2012] [error] [client 192.168.42.56] [DBG] c9 (lib/mahara.php:1492) Field retainview exists. Create skipped, referer: http://mahara.somedomain.ac.uk/admin/upgrade.php?rerun=1
[Tue Jun 26 12:49:53 2012] [error] [client 192.168.42.56] [DBG] c9 (lib/mahara.php:1492) Field showonlineusers exists. Create skipped, referer: http://mahara.somedomain.ac.uk/admin/upgrade.php?rerun=1
[Tue Jun 26 12:49:53 2012] [error] [client 192.168.42.56] [DBG] c9 (lib/mahara.php:1492) Field institution exists. Create skipped, referer: http://mahara.somedomain.ac.uk/admin/upgrade.php?rerun=1
[Tue Jun 26 12:49:53 2012] [error] [client 192.168.42.56] [DBG] c9 (lib/dml.php:159) mysql error: [1005: Can't create table 'mahara.#sql-10af_3cd' (errno: 121)] in adodb_throw(ALTER TABLE `group` ADD CONSTRAINT grou_ins_fk FOREIGN KEY (institution) REFERENCES institution (name), ), referer: http://mahara.somedomain.ac.uk/admin/upgrade.php?rerun=1
[Tue Jun 26 12:49:53 2012] [error] [client 192.168.42.56] [DBG] c9 (lib/dml.php:159) Command was: ALTER TABLE `group` ADD CONSTRAINT grou_ins_fk FOREIGN KEY (institution) REFERENCES institution (name), referer: http://mahara.somedomain.ac.uk/admin/upgrade.php?rerun=1
[Tue Jun 26 12:49:53 2012] [error] [client 192.168.42.56] [WAR] c9 (lib/errors.php:749) Could not execute command: ALTER TABLE `group` ADD CONSTRAINT grou_ins_fk FOREIGN KEY (institution) REFERENCES institution (name), referer: http://mahara.somedomain.ac.uk/admin/upgrade.php?rerun=1
[Tue Jun 26 12:49:53 2012] [error] [client 192.168.42.56] Call stack (most recent first):, referer: http://mahara.somedomain.ac.uk/admin/upgrade.php?rerun=1
[Tue Jun 26 12:49:53 2012] [error] [client 192.168.42.56]   * log_message("Could not execute command: ALTER TABLE `group` ADD...", 8, true, true) at /var/www/lib/errors.php:109, referer: http://mahara.somedomain.ac.uk/admin/upgrade.php?rerun=1
[Tue Jun 26 12:49:53 2012] [error] [client 192.168.42.56]   * log_warn("Could not execute command: ALTER TABLE `group` ADD...") at /var/www/lib/errors.php:749, referer: http://mahara.somedomain.ac.uk/admin/upgrade.php?rerun=1
[Tue Jun 26 12:49:53 2012] [error] [client 192.168.42.56]   * SQLException->__construct("Could not execute command: ALTER TABLE `group` ADD...") at /var/www/lib/dml.php:161, referer: http://mahara.somedomain.ac.uk/admin/upgrade.php?rerun=1
[Tue Jun 26 12:49:53 2012] [error] [client 192.168.42.56]   * execute_sql("ALTER TABLE `group` ADD CONSTRAINT grou_ins_fk FOR...") at /var/www/lib/dml.php:1395, referer: http://mahara.somedomain.ac.uk/admin/upgrade.php?rerun=1
[Tue Jun 26 12:49:53 2012] [error] [client 192.168.42.56]   * execute_sql_arr(array(size 1), true, true) at /var/www/lib/ddl.php:1051, referer: http://mahara.somedomain.ac.uk/admin/upgrade.php?rerun=1
[Tue Jun 26 12:49:53 2012] [error] [client 192.168.42.56]   * add_key(object(XMLDBTable), object(XMLDBKey)) at /var/www/lib/db/upgrade.php:2385, referer: http://mahara.somedomain.ac.uk/admin/upgrade.php?rerun=1
[Tue Jun 26 12:49:53 2012] [error] [client 192.168.42.56]   * xmldb_core_upgrade("2011061002") at /var/www/lib/upgrade.php:301, referer: http://mahara.somedomain.ac.uk/admin/upgrade.php?rerun=1
[Tue Jun 26 12:49:53 2012] [error] [client 192.168.42.56]   * upgrade_core(object(stdClass)) at /var/www/admin/upgrade.json.php:94, referer: http://mahara.somedomain.ac.uk/admin/upgrade.php?rerun=1
[Tue Jun 26 12:49:53 2012] [error] [client 192.168.42.56] , referer: http://mahara.somedomain.ac.uk/admin/upgrade.php?rerun=1
[Tue Jun 26 12:52:20 2012] [error] [client 192.168.42.56] [DBG] 53 (auth/user.php:1075) Destroying user with un-committed changes, referer: http://moodle.somedomain.ac.uk/moodle/

26 June 2012, 18:36

Hi Andrew,

As has been mentioned on the other threads on this topic, the error "Could not execute command ALTER TABLE 'group' ADD CONSTRAINT....." is due to running the upgrade a second time after an initial failure.  When you get an upgrade failure on MySQL, always restore your database to its original state before attempting the upgrade again.

We'll probably put out a newer release soon with a larger memory limit, but if you want to get the upgrade done now, try the following workaround:

 https://mahara.org/interaction/forum/topic.php?id=4562#post20421

If you have more problems, you may want to try the other tweaks linked from https://mahara.org/interaction/forum/topic.php?id=4636#post20519

27 June 2012, 4:26

Tried this procedure Michael Wuttke posted: -

1. mysqldump -u root --create-options -c -e mahara > /tmp/mahara_db_unicode.sql
2. sed 's/utf8_unicode_ci/utf8_general_ci/g' /tmp/mahara_db_unicode.sql > mahara_db_general.sql
3. mysql> create database mahara character set utf8 collate utf8_general_ci;
4. mysql> use mahara15;
5. mysql> \. /tmp/mahara_db_general.sql &
6. the upgrade on the website worked

Unfortunately, that didn't work.  Tried changing max_allowed_packet in the my.cnf.  Tried changing allowed memory size in my php.ini still the same error.  Upgrades were always seemless in the past.  I'm going to give this upgrade a miss. 

27 June 2012, 17:25

Hi Richard

I've decided to have another go at this.  I did everything in the various threads and turned on error logging options you mentioned. 

Any ideas what this error is:

27 June 2012, 17:50

What's unusual is I've put that file (YouTubeIframe.php) in the new installation yet it complains it can't find it?

27 June 2012, 19:06

Andrew,

As I understand things, those warnings are a red herring (albeit a minor bug which actually affects nothing overall). You should take the file back out or it might upset things once the install happens properly.

Can you tell me what you raised your php limit to? According to the error logs you pasted last time, it's at 256mb. You will want 512 at least as I understand it.

If you made it higher than 256, did you remember to restart apache? I've found that sometimes restart doesn't work for some php things and you need to stop it properly before starting again.

Hope this helps,
Melissa

28 June 2012, 2:29

Hi Melissa

I've tried with and without that file the same results.  In my php.ini I changed the memory_limit to 512M.  Also,I went into lib/db/upgrade.php and changed the variables to this:

    ini_set('max_execution_time', 2500); // Let's be safe
    raise_memory_limit('1024M');

Still no joy.  Although I've just run into this post - http://mahara.org/interaction/forum/topic.php?id=3780  I'm not sure whether I should try that considering what Richard said.

Weird I can't link to that post - http://www.google.co.uk/#hl=en&sclient=psy-ab&q=YouTubeIframe.php+mahara&oq=YouTubeIframe.php+mahara&gs_l=hp.3...7140.8326.1.8478.8.8.0.0.0.0.124.777.4j4.8.0...0.0.-bB7qp_hMVo&pbx=1&bav=on.2,or.r_gc.r_pw.r_qf.,cf.osb&fp=1deb3a27a4d9b1ab&biw=1920&bih=951. 

Second result.

28 June 2012, 3:00

Tried running  "DELETE FROM config WHERE field = 'filters';" as specified by Richard in that other post still an error.

28 June 2012, 3:42

Hi Andrew,

Are you still getting messages in your apache error.log file about the memory? Paste the latest one for me if so.

When you ran the DELETE FROM command in the database, did it tell you how many records were changed/deleted?

Thanks,
Melissa.