30 August 2011, 4:34

I have posted elsewhere that I was having big problems upgrading from 1.2 to 1.3. I eventually persuaded it to upgrade (with no errors) - but the only way I have been able to do it is to put code in the lib/db/upgrade.php file to actively stop it running twice. However, this results in a broken upgrade. The site doesn't work at all and accessing the home page results in...

[Tue Aug 30 10:58:02 2011] [error] [WAR] 89 (lib/errors.php:743) Failed to get a recordset: mysql error: [1452: Cannot add or update a child row: a foreign key constraint fails ("dev_mahara2011/view", CONSTRAINT "view_typ_fk" FOREIGN KEY ("type") REFERENCES "view_type" ("type"))] in adodb_throw(INSERT INTO "view" ("ctime", "mtime", "atime", "copynewuser") VALUES ('2011-08-30 10:58:02', '2011-08-30 10:58:02', '2011-08-30 10:58:02', 0), )
[Tue Aug 30 10:58:02 2011] [error] [WAR] 89 (lib/errors.php:743) Command was: INSERT INTO "view" ("ctime", "mtime", "atime", "copynewuser") VALUES (?, ?, ?, ?) and values was (2011-08-30 10:58:02,2011-08-30 10:58:02,2011-08-30 10:58:02,0)
[Tue Aug 30 10:58:02 2011] [error] Call stack (most recent first):
[Tue Aug 30 10:58:02 2011] [error]   * log_message("Failed to get a recordset: mysql error: [1452: Can...", 8, true, true) at /usr/local/apache/htdocs/mahara/maharatest/htdocs/lib/errors.php:109
[Tue Aug 30 10:58:02 2011] [error]   * log_warn("Failed to get a recordset: mysql error: [1452: Can...") at /usr/local/apache/htdocs/mahara/maharatest/htdocs/lib/errors.php:743[Tue Aug 30 10:58:02 2011] [error]   * SQLException->__construct("Failed to get a recordset: mysql error: [1452: Can...") at /usr/local/apache/htdocs/mahara/maharatest/htdocs/lib/dml.php:1069
[Tue Aug 30 10:58:02 2011] [error]   * insert_record("view", object(stdClass), "id", true) at /usr/local/apache/htdocs/mahara/maharatest/htdocs/lib/view.php:442
[Tue Aug 30 10:58:02 2011] [error]   * View->commit() at /usr/local/apache/htdocs/mahara/maharatest/htdocs/lib/view.php:416
[Tue Aug 30 10:58:02 2011] [error]   * View->__destruct() at /usr/local/apache/htdocs/mahara/maharatest/htdocs/auth/user.php:516
[Tue Aug 30 10:58:02 2011] [error]   * View::create_from_template(array(size 4), false, "1") at /usr/local/apache/htdocs/mahara/maharatest/htdocs/auth/user.php:516
[Tue Aug 30 10:58:02 2011] [error]   * User->install_dashboard_view() at /usr/local/apache/htdocs/mahara/maharatest/htdocs/auth/user.php:525
[Tue Aug 30 10:58:02 2011] [error]   * User->install_view("dashboard") at /usr/local/apache/htdocs/mahara/maharatest/htdocs/auth/user.php:419
[Tue Aug 30 10:58:02 2011] [error]   * User->get_view_by_type("dashboard") at /usr/local/apache/htdocs/mahara/maharatest/htdocs/index.php:52

Any thoughts? My feeling all along has been that something in the upgrade is failing but not reporting an error :(

30 August 2011, 8:19

Sorry... ignore this. I would have deleted if I could.