Reviewed: https://reviews.mahara.org/358 Committed: http://gitorious.org/mahara/mahara/commit/d7f62e043d29162a2014bbcc5857dc6920012a25 Submitter: Francois Marier ([email protected]) Branch: master
commit d7f62e043d29162a2014bbcc5857dc6920012a25 Author: Hugh Davenport <[email protected]> Date: Tue Jun 21 13:02:21 2011 +1200 Fix upgrade path for institutions controll of view access Bug #799992 Fixes commit 349cde3b743f957728deab5d94030eacebedc710 Change-Id: I169f74ba9073c952f220176961e245077108e2d7 Signed-off-by: Hugh Davenport <[email protected]> -- You received this bug notification because you are a member of Mahara Reviewers, which is subscribed to Mahara. https://bugs.launchpad.net/bugs/799992 Title: error on login Status in Mahara ePortfolio: Fix Committed Bug description: Produced on master, error log follows Doesn't happen on 1.4_STABLE [WAR] 5d (lib/errors.php:745) Failed to get a recordset: postgres7 error: [-1: ERROR: column i.allowinstitutionpublicviews does not exist [WAR] 5d (lib/errors.php:745) LINE 1: ...dmin,i.theme,i.registerallowed, i.showonlineusers,i.allowins... [WAR] 5d (lib/errors.php:745) ^] in EXECUTE(" [WAR] 5d (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] 5d (lib/errors.php:745) FROM "usr_institution" u INNER JOIN "institution" i ON u.institution = i.name [WAR] 5d (lib/errors.php:745) WHERE u.usr = ? ORDER BY i.priority DESC") [WAR] 5d (lib/errors.php:745) Command was: [WAR] 5d (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] 5d (lib/errors.php:745) FROM "usr_institution" u INNER JOIN "institution" i ON u.institution = i.name [WAR] 5d (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.insrs,i.allowinstitutionpublicviews [WAR] 5d (lib/dml.php:484) FROM "usr_institution" u INNER JOIN "institution" i ON u.institution = i.name [WAR] 5d (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/799992/+subscriptions _______________________________________________ Mailing list: https://launchpad.net/~mahara-core Post to : [email protected] Unsubscribe : https://launchpad.net/~mahara-core More help : https://help.launchpad.net/ListHelp

