mahara-contributors team mailing list archive

[Richard Mansfield <607647@xxxxxxxxxxxxxxxxxx>]

Yeah, the bug only occurred in new installs. Upgraded sites shouldn't
have it.

If you have a site that was made using a new install after the bug was
introduced (1 July), and you need to fix the db for that site, you
should do that by hand (using "ALTER TABLE view_access ALTER COLUMN
accesstype DROP DEFAULT").

That's because we generally don't bother to write upgrades to fix old
broken upgrade stuff unless it's in a stable release.  Life on the edge.

-- 
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)