mahara-contributors team mailing list archive

[David Drummond <607647@xxxxxxxxxxxxxxxxxx>]

Public bug reported:

Getting an error creating a group on current version of Master.  Using
PostgreSQL version 8.4.4 on Ubuntu 9.10

Produce by clicking Groups -> Create Group -> (fill fields) -> Save
Group.

Error log extract:

[Tue Jul 20 10:36:39 2010] [WAR] d3 (lib/errors.php:743) Failed to get a recordset: postgres7 error: [-1: ERROR:  new row for relation "view_access" violates check constraint "view_access_check"] in adodb_throw(INSERT INTO "view_access" ("view", "group", "allowcomments", "approvecomments") VALUES (?, ?, ?, ?), Array)
[Tue Jul 20 10:36:39 2010] [WAR] d3 (lib/errors.php:743) Command was: INSERT INTO "view_access" ("view", "group", "allowcomments", "approvecomments") VALUES (?, ?, ?, ?) and values was (8,3,0,0)
[Tue Jul 20 10:36:39 2010] Call stack (most recent first):
[Tue Jul 20 10:36:39 2010] * log_message("Failed to get a recordset: postgres7 error: [-1: E...", 8, true, true) at /var/www/mahararepos/master/htdocs/lib/errors.php:109
[Tue Jul 20 10:36:39 2010] * log_warn("Failed to get a recordset: postgres7 error: [-1: E...") at /var/www/mahararepos/master/htdocs/lib/errors.php:743
[Tue Jul 20 10:36:39 2010] * SQLException->__construct("Failed to get a recordset: postgres7 error: [-1: E...") at /var/www/mahararepos/master/htdocs/lib/dml.php:1069
[Tue Jul 20 10:36:39 2010] * insert_record("view_access", object(stdClass)) at /var/www/mahararepos/master/htdocs/lib/view.php:717
[Tue Jul 20 10:36:39 2010] * View->set_access(array(size 1)) at /var/www/mahararepos/master/htdocs/lib/view.php:346
[Tue Jul 20 10:36:39 2010] * View::_create(array(size 4), 0) at /var/www/mahararepos/master/htdocs/lib/view.php:213
[Tue Jul 20 10:36:39 2010] * View::create_from_template(array(size 4), "3", 0, false) at /var/www/mahararepos/master/htdocs/lib/group.php:324
[Tue Jul 20 10:36:39 2010] * group_create(array(size 9)) at /var/www/mahararepos/master/htdocs/group/create.php:132
[Tue Jul 20 10:36:39 2010] * creategroup_submit(object(Pieform), array(size 9)) at Unknown:0
[Tue Jul 20 10:36:39 2010] * call_user_func_array("creategroup_submit", array(size 2)) at /var/www/mahararepos/master/htdocs/lib/pieforms/pieform.php:511
[Tue Jul 20 10:36:39 2010] * Pieform->__construct(array(size 5)) at /var/www/mahararepos/master/htdocs/lib/pieforms/pieform.php:161
[Tue Jul 20 10:36:39 2010] * Pieform::process(array(size 5)) at /var/www/mahararepos/master/htdocs/lib/pieforms/pieform.php:71
[Tue Jul 20 10:36:39 2010] * pieform(array(size 5)) at /var/www/mahararepos/master/htdocs/group/create.php:96


Constraint in question:

"view_access_check" CHECK (accesstype IS NOT NULL AND "group" IS NULL
AND usr IS NULL AND token IS NULL OR accesstype IS NULL AND "group" IS
NOT NULL AND usr IS NULL AND token IS NULL OR accesstype IS NULL AND
"group" IS NULL AND usr IS NOT NULL AND token IS NULL OR accesstype IS
NULL AND "group" IS NULL AND usr IS NULL AND token IS NOT NULL)

** Affects: mahara
     Importance: Undecided
         Status: New

-- 
Error creating Group
https://bugs.launchpad.net/bugs/607647
You received this bug notification because you are a member of Mahara
Contributors, which is subscribed to Mahara.

Status in Mahara ePortfolio: New

Bug description:
Getting an error creating a group on current version of Master.  Using PostgreSQL version 8.4.4 on Ubuntu 9.10

Produce by clicking Groups -> Create Group -> (fill fields) -> Save Group.

Error log extract:

[Tue Jul 20 10:36:39 2010] [WAR] d3 (lib/errors.php:743) Failed to get a recordset: postgres7 error: [-1: ERROR:  new row for relation "view_access" violates check constraint "view_access_check"] in adodb_throw(INSERT INTO "view_access" ("view", "group", "allowcomments", "approvecomments") VALUES (?, ?, ?, ?), Array)
[Tue Jul 20 10:36:39 2010] [WAR] d3 (lib/errors.php:743) Command was: INSERT INTO "view_access" ("view", "group", "allowcomments", "approvecomments") VALUES (?, ?, ?, ?) and values was (8,3,0,0)
[Tue Jul 20 10:36:39 2010] Call stack (most recent first):
[Tue Jul 20 10:36:39 2010] * log_message("Failed to get a recordset: postgres7 error: [-1: E...", 8, true, true) at /var/www/mahararepos/master/htdocs/lib/errors.php:109
[Tue Jul 20 10:36:39 2010] * log_warn("Failed to get a recordset: postgres7 error: [-1: E...") at /var/www/mahararepos/master/htdocs/lib/errors.php:743
[Tue Jul 20 10:36:39 2010] * SQLException->__construct("Failed to get a recordset: postgres7 error: [-1: E...") at /var/www/mahararepos/master/htdocs/lib/dml.php:1069
[Tue Jul 20 10:36:39 2010] * insert_record("view_access", object(stdClass)) at /var/www/mahararepos/master/htdocs/lib/view.php:717
[Tue Jul 20 10:36:39 2010] * View->set_access(array(size 1)) at /var/www/mahararepos/master/htdocs/lib/view.php:346
[Tue Jul 20 10:36:39 2010] * View::_create(array(size 4), 0) at /var/www/mahararepos/master/htdocs/lib/view.php:213
[Tue Jul 20 10:36:39 2010] * View::create_from_template(array(size 4), "3", 0, false) at /var/www/mahararepos/master/htdocs/lib/group.php:324
[Tue Jul 20 10:36:39 2010] * group_create(array(size 9)) at /var/www/mahararepos/master/htdocs/group/create.php:132
[Tue Jul 20 10:36:39 2010] * creategroup_submit(object(Pieform), array(size 9)) at Unknown:0
[Tue Jul 20 10:36:39 2010] * call_user_func_array("creategroup_submit", array(size 2)) at /var/www/mahararepos/master/htdocs/lib/pieforms/pieform.php:511
[Tue Jul 20 10:36:39 2010] * Pieform->__construct(array(size 5)) at /var/www/mahararepos/master/htdocs/lib/pieforms/pieform.php:161
[Tue Jul 20 10:36:39 2010] * Pieform::process(array(size 5)) at /var/www/mahararepos/master/htdocs/lib/pieforms/pieform.php:71
[Tue Jul 20 10:36:39 2010] * pieform(array(size 5)) at /var/www/mahararepos/master/htdocs/group/create.php:96


Constraint in question:

"view_access_check" CHECK (accesstype IS NOT NULL AND "group" IS NULL AND usr IS NULL AND token IS NULL OR accesstype IS NULL AND "group" IS NOT NULL AND usr IS NULL AND token IS NULL OR accesstype IS NULL AND "group" IS NULL AND usr IS NOT NULL AND token IS NULL OR accesstype IS NULL AND "group" IS NULL AND usr IS NULL AND token IS NOT NULL)