Public bug reported:
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
** Affects: mahara
Importance: Undecided
Status: New
--
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:
New
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
