mahara-contributors team mailing list archive

[François Marier <francois@xxxxxxxxxx>]

** Changed in: mahara
       Status: Triaged => Confirmed

** Changed in: mahara
    Milestone: 1.5.0 => None

-- 
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