mahara-contributors team mailing list archive

[François Marier <francois@xxxxxxxxxx>]

** Changed in: mahara
     Assignee: (unassigned) => Hugh Davenport (hugh-catalyst)

-- 
You received this bug notification because you are a member of Mahara
Contributors, 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