Thanks Richard. Does the fix only repair new installs?

-- 
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: Fix Committed

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)



_______________________________________________
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

Reply via email to