version no for 1.4_STABLE 1.4.1testing (2011061003) version no for master 1.5.0dev (2011062100)
merge base between branches b3177ad2355306faea9a8e2ca9fd79afae12706a version no for merge base 1.4.0alpha2dev (2011051700) Basically, the upgrade doesn't run the if statements in lib/db/upgrade.db with the following version nos (taken from git diff 1.4_STABLE..master htdocs/lib/db/upgrade.php) 2011051300 - delete wwwroot 2011052400 - ctime in view access 2011053100 - default quota for institutions 2011053101 - group quota 2011060700 - retain view access on copy, and cronjob for sitemap (should be in seperate one...) 2011060701 - set onlineuserssideblockmaxusers to 10, and add showonlineusers field to institutions This will be a difficult one, and will get worse when 1.4_STABLE version no is bumped What I suggest for now - bump version no on master, add all the stuff it might of missed (making sure to test whether it has been done already or not...) - in future, when we bump version no on 1.4_STABLE, we need to check if anything will be missed on the upgrade, and bump masters version to add in stuff that may not be done ** Changed in: mahara Importance: Undecided => High ** Changed in: mahara Milestone: None => 1.5.0 ** Changed in: mahara Importance: High => Critical ** Changed in: mahara Status: New => Triaged -- 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: Triaged 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