← Back to team overview

mahara-contributors team mailing list archive

[Bug 860108] Re: Can only add one user to any institution, subsequent additions fail

 

Does this happen on 1.4 too?

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

** Changed in: mahara
   Importance: Undecided => High

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

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


References