Public bug reported:
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
** Affects: mahara
Importance: Medium
Assignee: Hugh Davenport (hugh-catalyst)
Status: Confirmed
--
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:
Confirmed
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
