Reviewed: https://reviews.mahara.org/378 Committed: http://gitorious.org/mahara/mahara/commit/73d613c10127c5398b4ba39cce883abcee9fab4b Submitter: Francois Marier (franc...@catalyst.net.nz) Branch: master
commit 73d613c10127c5398b4ba39cce883abcee9fab4b Author: Hugh Davenport <h...@catalyst.net.nz> Date: Thu Jun 23 11:38:00 2011 +1200 Fix upgrade from 1.4_STABLE to master Bumps master version, and moves the upgrades that didn't happen to the new bump, checking where nessesary if they have already been applied The new version bump is the date after the 1.4_STABLE branch 2011061100 Version numbers missed: 2011052400 - ctime in view access 2011053100 - default quota for institutions 2011053101 - group quota 2011060700 - retain view access on copy 2011060701 - set onlineuserssideblockmaxusers to 10, and add showonlineusers field to institutions Bug #800917 Change-Id: I3594d22fda6c3c9eca0c5b86fde923ab37eb8752 Signed-off-by: Hugh Davenport <h...@catalyst.net.nz> -- You received this bug notification because you are a member of Mahara Contributors, which is subscribed to Mahara. https://bugs.launchpad.net/bugs/800917 Title: upgrade from 1.4_STABLE to master breaks Status in Mahara ePortfolio: Confirmed Bug description: When upgrading from 1.4_STABLE to master, certain errors are made. During the upgrade process, the following DBG message is given [DBG] ae (lib/ddl.php:486) Function find_index_name called on an index usr_fir_ix with no columns. Attempting match on index names of all indexes on usr without columns. After login, the following errors are shown 2011/06/23 10:09:07 [error] 12309#0: *4434 FastCGI sent in stderr: "[WAR] 96 (lib/errors.php:745) Failed to get a recordset: postgres7 error: [-1: ERROR: column i.showonlineusers does not exist [WAR] 96 (lib/errors.php:745) LINE 1: ...dentid,u.staff,u.admin,i.theme,i.registerallowed, i.showonli... [WAR] 96 (lib/errors.php:745) ^] in EXECUTE(" [WAR] 96 (lib/errors.php:745) SELECT u.institution,FLOOR(EXTRACT(EPOCH FROM ctime)) AS ctime,FLOOR(EXTRACT(EPOCH FROM u.expiry)) AS membership_expiry,u.studentid,u.staff,u.admin,i.theme,i.registerallowed, i.showonlineusers,i.allowinstitutionpublicviews [WAR] 96 (lib/errors.php:745) FROM "usr_institution" u INNER JOIN "institution" i ON u.institution = i.name [WAR] 96 (lib/errors.php:745) WHERE u.usr = ? ORDER BY i.priority DESC") [WAR] 96 (lib/errors.php:745) Command was: [WAR] 96 (lib/errors.php:745) SELECT u.institution,FLOOR(EXTRACT(EPOCH FROM ctime)) AS ctime,FLOOR(EXTRACT(EPOCH FROM u.expiry)) AS membership_expiry,u.studentid,u.staff,u.admin,i.theme,i.registerallowed, i.showonlineusers,i.allowinstitutionpublicviews [WAR] 96 (lib/errors.php:745) FROM "usr_institution" u INNER JOIN "institution" i ON u.institution = i.name [WAR] 96 (lib/errors.php:745) WHERE u.usr = ? ORDER BY i.priority DESC and values was (1) Call stack (most recent first): * log_message("Failed to get a recordset: postgres7 error: [-1: E...", 8, true, true) at /home/hugh/src/mahara/mahara/htdocs/lib/errors.php:109 * log_warn("Failed to get a recordset: postgres7 error: [-1: E...") at /home/hugh/src/mahara/mahara/htdocs/lib/errors.php:745 * SQLException->__construct("Failed to get a recordset: postgres7 error: [-1: E...") at /home/hugh/src/mahara/mahara/htdocs/lib/dml.php:484 * get_recordset_sql(" SELECT u.institution,FLOOR(EXTRACT(EPOCH ...", array(size 1), "", "") at /home/hugh/src/mahara/mahara/htdocs/lib/dml.php:650 * get_records_sql_assoc(" SELECT u.institution,F 2011/06/23 10:09:07 [error] 12309#0: *4434 FastCGI sent in stderr: "licviews [WAR] 96 (lib/dml.php:484) FROM "usr_institution" u INNER JOIN "institution" i ON u.institution = i.name [WAR] 96 (lib/dml.php:484) WHERE u.usr = ? ORDER BY i.priority DESC and values was (1) Call stack (most recent first): * get_recordset_sql(" SELECT u.institution,FLOOR(EXTRACT(EPOCH ...", array(size 1), "", "") at /home/hugh/src/mahara/mahara/htdocs/lib/dml.php:650 * get_records_sql_assoc(" SELECT u.institution,FLOOR(EXTRACT(EPOCH ...", array(size 1)) at /home/hugh/src/mahara/mahara/htdocs/lib/user.php:1267 * load_user_institutions("1") at /home/hugh/src/mahara/mahara/htdocs/auth/user.php:804 * User->reset_institutions() at /home/hugh/src/mahara/mahara/htdocs/auth/user.php:1302 * LiveUser->reset_institutions() at /home/hugh/src/mahara/mahara/htdocs/auth/user.php:1183 * LiveUser->authenticate(object(stdClass), "1") at /home/hugh/src/mahara/mahara/htdocs/auth/user.php:1058 * LiveUser->login("admin", "aY1sea'th0") at /home/hugh/src/mahara/mahara/htdocs/auth/lib.php:1151 * login_submit(object(Pieform), array(size 6)) at Unknown:0 * call_user_func_array("login_submit", array(size 2)) at /home/hugh/src/mahara/mahara/htdocs/lib/pieforms/pieform.php:512 * Pieform->__construct(array(size 8)) at /home/hugh/src/mahara/mahara/htdocs/auth/lib.php:478 * auth_setup() at /home/hugh/src/mahara/mahara/htdocs/init.php:268 * require("/home/hugh/src/mahara/mahara/htdocs/init.php") at /home/hugh/src/mahara/mahara/htdocs/index.php:32 To manage notifications about this bug go to: https://bugs.launchpad.net/mahara/+bug/800917/+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