mahara-contributors team mailing list archive

[Melissa Draper <melissa@xxxxxxxxxxxxx>]

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