Public bug reported:
One user may be added to an insitution, but you cannot add anyone else
to any institution on the whole site because it complains about null
ctime on the view_access record
----
[WAR] 45 (lib/errors.php:749) Failed to get a recordset: postgres7 error: [-1:
ERROR: null value in column "ctime" violates not-null constraint] in
adodb_throw(INSERT INTO "view_access" ("view", "institution", "allowcomments",
"approvecomments") VALUES (?, ?, ?, ?), Array)
Command was: INSERT INTO "view_access" ("view", "institution", "allowcomments",
"approvecomments") VALUES (?, ?, ?, ?) and values was (4,testinstitution,0,1)
Call stack (most recent first):
log_message("Failed to get a recordset: postgres7 error: [-1: E...", 8,
true, true) at /home/melissa/mahara/htdocs/lib/errors.php:109
log_warn("Failed to get a recordset: postgres7 error: [-1: E...") at
/home/melissa/mahara/htdocs/lib/errors.php:749
SQLException->__construct("Failed to get a recordset: postgres7 error: [-1:
E...") at /home/melissa/mahara/htdocs/lib/dml.php:1060
insert_record("view_access", object(stdClass), false, false) at
/home/melissa/mahara/htdocs/lib/dml.php:1147
ensure_record_exists("view_access", object(stdClass), object(stdClass)) at
/home/melissa/mahara/htdocs/lib/view.php:996
View->add_owner_institution_access(array(size 1)) at
/home/melissa/mahara/htdocs/lib/institution.php:235
Institution->addUserAsMember(object(stdClass)) at
/home/melissa/mahara/htdocs/lib/institution.php:276
Institution->add_members(array(size 1)) at
/home/melissa/mahara/htdocs/admin/users/institutionusers.php:259
institutionusers_submit(object(Pieform), array(size 5)) at Unknown:0
call_user_func_array("institutionusers_submit", array(size 2)) at
/home/melissa/mahara/htdocs/lib/pieforms/pieform.php:512
Pieform->__construct(array(size 2)) at
/home/melissa/mahara/htdocs/lib/pieforms/pieform.php:161
Pieform::process(array(size 2)) at
/home/melissa/mahara/htdocs/lib/pieforms/pieform.php:71
pieform(array(size 2)) at
/home/melissa/mahara/htdocs/admin/users/institutionusers.php:192
[WAR] 45 (lib/dml.php:1060) Failed to get a recordset: postgres7 error: [-1:
ERROR: null value in column "ctime" violates not-null constraint] in
adodb_throw(INSERT INTO "view_access" ("view", "institution", "allowcomments",
"approvecomments") VALUES (?, ?, ?, ?), Array)
Command was: INSERT INTO "view_access" ("view", "institution", "allowcomments",
"approvecomments") VALUES (?, ?, ?, ?) and values was (4,testinstitution,0,1)
Call stack (most recent first):
insert_record("view_access", object(stdClass), false, false) at
/home/melissa/mahara/htdocs/lib/dml.php:1147
ensure_record_exists("view_access", object(stdClass), object(stdClass)) at
/home/melissa/mahara/htdocs/lib/view.php:996
View->add_owner_institution_access(array(size 1)) at
/home/melissa/mahara/htdocs/lib/institution.php:235
Institution->addUserAsMember(object(stdClass)) at
/home/melissa/mahara/htdocs/lib/institution.php:276
Institution->add_members(array(size 1)) at
/home/melissa/mahara/htdocs/admin/users/institutionusers.php:259
institutionusers_submit(object(Pieform), array(size 5)) at Unknown:0
call_user_func_array("institutionusers_submit", array(size 2)) at
/home/melissa/mahara/htdocs/lib/pieforms/pieform.php:512
Pieform->__construct(array(size 2)) at
/home/melissa/mahara/htdocs/lib/pieforms/pieform.php:161
Pieform::process(array(size 2)) at
/home/melissa/mahara/htdocs/lib/pieforms/pieform.php:71
pieform(array(size 2)) at
/home/melissa/mahara/htdocs/admin/users/institutionusers.php:192
** 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/860108
Title:
Can only add one user to any institution, subsequent additions fail
Status in Mahara ePortfolio:
New
Bug description:
One user may be added to an insitution, but you cannot add anyone else
to any institution on the whole site because it complains about null
ctime on the view_access record
----
[WAR] 45 (lib/errors.php:749) Failed to get a recordset: postgres7 error:
[-1: ERROR: null value in column "ctime" violates not-null constraint] in
adodb_throw(INSERT INTO "view_access" ("view", "institution", "allowcomments",
"approvecomments") VALUES (?, ?, ?, ?), Array)
Command was: INSERT INTO "view_access" ("view", "institution",
"allowcomments", "approvecomments") VALUES (?, ?, ?, ?) and values was
(4,testinstitution,0,1)
Call stack (most recent first):
log_message("Failed to get a recordset: postgres7 error: [-1: E...", 8,
true, true) at /home/melissa/mahara/htdocs/lib/errors.php:109
log_warn("Failed to get a recordset: postgres7 error: [-1: E...") at
/home/melissa/mahara/htdocs/lib/errors.php:749
SQLException->__construct("Failed to get a recordset: postgres7 error:
[-1: E...") at /home/melissa/mahara/htdocs/lib/dml.php:1060
insert_record("view_access", object(stdClass), false, false) at
/home/melissa/mahara/htdocs/lib/dml.php:1147
ensure_record_exists("view_access", object(stdClass), object(stdClass))
at /home/melissa/mahara/htdocs/lib/view.php:996
View->add_owner_institution_access(array(size 1)) at
/home/melissa/mahara/htdocs/lib/institution.php:235
Institution->addUserAsMember(object(stdClass)) at
/home/melissa/mahara/htdocs/lib/institution.php:276
Institution->add_members(array(size 1)) at
/home/melissa/mahara/htdocs/admin/users/institutionusers.php:259
institutionusers_submit(object(Pieform), array(size 5)) at Unknown:0
call_user_func_array("institutionusers_submit", array(size 2)) at
/home/melissa/mahara/htdocs/lib/pieforms/pieform.php:512
Pieform->__construct(array(size 2)) at
/home/melissa/mahara/htdocs/lib/pieforms/pieform.php:161
Pieform::process(array(size 2)) at
/home/melissa/mahara/htdocs/lib/pieforms/pieform.php:71
pieform(array(size 2)) at
/home/melissa/mahara/htdocs/admin/users/institutionusers.php:192
[WAR] 45 (lib/dml.php:1060) Failed to get a recordset: postgres7 error: [-1:
ERROR: null value in column "ctime" violates not-null constraint] in
adodb_throw(INSERT INTO "view_access" ("view", "institution", "allowcomments",
"approvecomments") VALUES (?, ?, ?, ?), Array)
Command was: INSERT INTO "view_access" ("view", "institution",
"allowcomments", "approvecomments") VALUES (?, ?, ?, ?) and values was
(4,testinstitution,0,1)
Call stack (most recent first):
insert_record("view_access", object(stdClass), false, false) at
/home/melissa/mahara/htdocs/lib/dml.php:1147
ensure_record_exists("view_access", object(stdClass), object(stdClass))
at /home/melissa/mahara/htdocs/lib/view.php:996
View->add_owner_institution_access(array(size 1)) at
/home/melissa/mahara/htdocs/lib/institution.php:235
Institution->addUserAsMember(object(stdClass)) at
/home/melissa/mahara/htdocs/lib/institution.php:276
Institution->add_members(array(size 1)) at
/home/melissa/mahara/htdocs/admin/users/institutionusers.php:259
institutionusers_submit(object(Pieform), array(size 5)) at Unknown:0
call_user_func_array("institutionusers_submit", array(size 2)) at
/home/melissa/mahara/htdocs/lib/pieforms/pieform.php:512
Pieform->__construct(array(size 2)) at
/home/melissa/mahara/htdocs/lib/pieforms/pieform.php:161
Pieform::process(array(size 2)) at
/home/melissa/mahara/htdocs/lib/pieforms/pieform.php:71
pieform(array(size 2)) at
/home/melissa/mahara/htdocs/admin/users/institutionusers.php:192
To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/860108/+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
