[Mahara-contributors] [Bug 607647] Re: Error creating Group

2010-09-09 Thread Richard Mansfield
** Changed in: mahara
   Status: Fix Committed = Fix Released

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

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


[Mahara-contributors] [Bug 607647] Re: Error creating Group

2010-07-21 Thread David Drummond
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


[Mahara-contributors] [Bug 607647] Re: Error creating Group

2010-07-20 Thread Stacey Walker
Just to note, I am getting a very similar error when attempting to
create a view with a secret URL access type.   Using a clean checkout of
upstream master running postgres database version 8.4.4.

[Tue Jul 20 11:17:18 2010] [error] [client 127.0.0.1] [WAR] e6 
(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 EXECUTE(INSERT INTO view_access (view, token, 
visible) VALUES (?, ?, ?)), referer: 
http://mahara-sandpit.etna/view/access.php?id=6new=1
[Tue Jul 20 11:17:18 2010] [error] [client 127.0.0.1] [WAR] e6 
(lib/errors.php:743) Command was: INSERT INTO view_access (view, token, 
visible) VALUES (?, ?, ?) and values was (6,eT1bhmUiJ5y3r4gAtIY7,1), referer: 
http://mahara-sandpit.etna/view/access.php?id=6new=1
[Tue Jul 20 11:17:18 2010] [error] [client 127.0.0.1] Call stack (most recent 
first):, referer: http://mahara-sandpit.etna/view/access.php?id=6new=1
[Tue Jul 20 11:17:18 2010] [error] [client 127.0.0.1]   * log_message(Failed 
to get a recordset: postgres7 error: [-1: E..., 8, true, true) at 
/var/www/staceys-sandbox/htdocs/lib/errors.php:109, referer: 
http://mahara-sandpit.etna/view/access.php?id=6new=1
[Tue Jul 20 11:17:18 2010] [error] [client 127.0.0.1]   * log_warn(Failed to 
get a recordset: postgres7 error: [-1: E...) at 
/var/www/staceys-sandbox/htdocs/lib/errors.php:743, referer: 
http://mahara-sandpit.etna/view/access.php?id=6new=1
[Tue Jul 20 11:17:18 2010] [error] [client 127.0.0.1]   * 
SQLException-__construct(Failed to get a recordset: postgres7 error: [-1: 
E...) at /var/www/staceys-sandbox/htdocs/lib/dml.php:1069, referer: 
http://mahara-sandpit.etna/view/access.php?id=6new=1
[Tue Jul 20 11:17:18 2010] [error] [client 127.0.0.1]   * 
insert_record(view_access, object(stdClass)) at 
/var/www/staceys-sandbox/htdocs/lib/view.php:2842, referer: 
http://mahara-sandpit.etna/view/access.php?id=6new=1
[Tue Jul 20 11:17:18 2010] [error] [client 127.0.0.1]   * View::new_token(6) at 
/var/www/staceys-sandbox/htdocs/view/newviewtoken.json.php:34, referer: 
http://mahara-sandpit.etna/view/access.php?id=6new=1
[Tue Jul 20 11:17:18 2010] [error] [client 127.0.0.1] , referer: 
http://mahara-sandpit.etna/view/access.php?id=6new=1
[Tue Jul 20 11:17:18 2010] [error] [client 127.0.0.1] [WAR] e6 
(lib/dml.php:1069) Failed to get a recordset: postgres7 error: [-1: ERROR:  new 
row for relation view_access violates check constraint view_access_check] 
in EXECUTE(INSERT INTO view_access (view, token, visible) VALUES (?, 
?, ?)), referer: http://mahara-sandpit.etna/view/access.php?id=6new=1
[Tue Jul 20 11:17:18 2010] [error] [client 127.0.0.1] [WAR] e6 
(lib/dml.php:1069) Command was: INSERT INTO view_access (view, token, 
visible) VALUES (?, ?, ?) and values was (6,eT1bhmUiJ5y3r4gAtIY7,1), referer: 
http://mahara-sandpit.etna/view/access.php?id=6new=1
[Tue Jul 20 11:17:18 2010] [error] [client 127.0.0.1] Call stack (most recent 
first):, referer: http://mahara-sandpit.etna/view/access.php?id=6new=1
[Tue Jul 20 11:17:18 2010] [error] [client 127.0.0.1]   * 
insert_record(view_access, object(stdClass)) at 
/var/www/staceys-sandbox/htdocs/lib/view.php:2842, referer: 
http://mahara-sandpit.etna/view/access.php?id=6new=1
[Tue Jul 20 11:17:18 2010] [error] [client 127.0.0.1]   * View::new_token(6) at 
/var/www/staceys-sandbox/htdocs/view/newviewtoken.json.php:34, referer: 
http://mahara-sandpit.etna/view/access.php?id=6new=1
[Tue Jul 20 11:17:18 2010] [error] [client 127.0.0.1] , referer: 
http://mahara-sandpit.etna/view/access.php?id=6new=1

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

[Mahara-contributors] [Bug 607647] Re: Error creating Group

2010-07-20 Thread Richard Mansfield
** Changed in: mahara
 Assignee: (unassigned) = Richard Mansfield (richard-mansfield)

** Changed in: mahara
   Status: New = Triaged

** Changed in: mahara
Milestone: None = 1.3.0

** Changed in: mahara
   Importance: Undecided = High

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

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