[Mahara-contributors] [Bug 607647] Re: Error creating Group
** 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
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
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
** 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