[Mahara-contributors] [Bug 1626705] Re: Copying of group throws ADODB error
** Changed in: mahara Status: Fix Committed => Fix Released -- You received this bug notification because you are a member of Mahara Contributors, which is subscribed to Mahara. Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before editing or unsubscribing it! https://bugs.launchpad.net/bugs/1626705 Title: Copying of group throws ADODB error Status in Mahara: Fix Released Bug description: Mahara 16.10dev, upgraded site from Mahara 16.04 I upgraded my site from 16.04 and when attempting to copy a group, it throws the following error: [WAR] d3 (lib/adodb/adodb-exceptions.inc.php:45) Array to string conversion Call stack (most recent first): log_message("Array to string conversion", 8, true, true, "/home/kristina/code/1610stable/htdocs/lib/adodb/ad...", 45) at /home/kristina/code/1610stable/htdocs/lib/errors.php:513 error(8, "Array to string conversion", "/home/kristina/code/1610stable/htdocs/lib/adodb/ad...", 45, array(size 7)) at /home/kristina/code/1610stable/htdocs/lib/adodb/adodb-exceptions.inc.php:45 ADODB_Exception->__construct("postgres8", "adodb_throw", -1, "ERROR: value too long for type character varying(...", "INSERT INTO "group" ("id", "name", "description", ...", array(size 28), object(ADODB_postgres8)) at /home/kristina/code/1610stable/htdocs/lib/adodb/adodb-exceptions.inc.php:80 adodb_throw("postgres8", "adodb_throw", -1, "ERROR: value too long for type character varying(...", "INSERT INTO "group" ("id", "name", "description", ...", array(size 28), object(ADODB_postgres8)) at /home/kristina/code/1610stable/htdocs/lib/adodb/adodb.inc.php:298 ADODB_TransMonitor("postgres8", "EXECUTE", -1, "ERROR: value too long for type character varying(...", "INSERT INTO "group" ("id", "name", "description", ...", array(size 28), object(ADODB_postgres8)) at /home/kristina/code/1610stable/htdocs/lib/adodb/adodb.inc.php:1249 ADOConnection->_Execute("INSERT INTO "group" ("id", "name", "description", ...", array(size 28)) at /home/kristina/code/1610stable/htdocs/lib/adodb/adodb.inc.php:1209 ADOConnection->Execute("INSERT INTO "group" ("id", "name", "description", ...", array(size 28)) at /home/kristina/code/1610stable/htdocs/lib/dml.php:1085 insert_record("group", object(stdClass), "id", true) at /home/kristina/code/1610stable/htdocs/lib/group.php:451 group_create(array(size 31)) at /home/kristina/code/1610stable/htdocs/lib/group.php:2808 group_copy(2, "adminlist") at /home/kristina/code/1610stable/htdocs/group/copy.php:37 [WAR] d3 (lib/errors.php:819) Failed to get a recordset: postgres8 error: [-1: ERROR: value too long for type character varying(30)] in adodb_throw(INSERT INTO "group" ("id", "name", "description", "grouptype", "jointype", "ctime", "mtime", "public", "usersautoadded", "category", "viewnotify", "quota", "institution", "shortname", "request", "submittableto", "editroles", "hidden", "hidemembers", "hidemembersfrommembers", "groupparticipationreports", "invitefriends", "suggestfriends", "urlid", "editwindowend", "sendnow", "feedbacknotify", "allowarchives") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), Array) Command was: INSERT INTO "group" ("id", "name", "description", "grouptype", "jointype", "ctime", "mtime", "public", "usersautoadded", "category", "viewnotify", "quota", "institution", "shortname", "request", "submittableto", "editroles", "hidden", "hidemembers", "hidemembersfrommembers", "groupparticipationreports", "invitefriends", "suggestfriends", "urlid", "editwindowend", "sendnow", "feedbacknotify", "allowarchives") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and values was (id:10,name:HumanComputerInteraction101v.2,description:Foundationcourseforbeginners,grouptype:course,jointype:approve,ctime:2016-09-2307:15:43,mtime:2016-09-2307:15:43,public:0,usersautoadded:0,category:1,viewnotify:1,quota:52428800,institution:mahara,shortname:humancomputerinteraction101a,request:1,submittableto:1,editroles:notmember,hidden:0,hidemembers:0,hidemembersfrommembers:0,groupparticipationreports:0,invitefriends:1,suggestfriends:0,urlid:human -computer-interaction-101-v-2,editwindowend:2016-11-0700:00:00,sendnow:0,feedbacknotify:1,allowarchives:0) Call stack (most recent first): log_message("Failed to get a recordset: postgres8 error: [-1: E...", 8, true, true) at /home/kristina/code/1610stable/htdocs/lib/errors.php:95 log_warn("Failed to get a recordset: postgres8 error: [-1: E...") at /home/kristina/code/1610stable/htdocs/lib/errors.php:819 SQLException->__construct("Failed to get a recordset: postgres8 error: [-1: E...") at /home/kristina/code/1610stable/htdocs/lib/dml.php:1088 insert_record("group", object(stdClass), "id", true) at /home/kristina/code/1610stable/htdocs/lib/group.php:4
[Mahara-contributors] [Bug 1626705] Re: Copying of group throws ADODB error
** Changed in: mahara Status: In Progress => Fix Committed -- You received this bug notification because you are a member of Mahara Contributors, which is subscribed to Mahara. Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before editing or unsubscribing it! https://bugs.launchpad.net/bugs/1626705 Title: Copying of group throws ADODB error Status in Mahara: Fix Committed Bug description: Mahara 16.10dev, upgraded site from Mahara 16.04 I upgraded my site from 16.04 and when attempting to copy a group, it throws the following error: [WAR] d3 (lib/adodb/adodb-exceptions.inc.php:45) Array to string conversion Call stack (most recent first): log_message("Array to string conversion", 8, true, true, "/home/kristina/code/1610stable/htdocs/lib/adodb/ad...", 45) at /home/kristina/code/1610stable/htdocs/lib/errors.php:513 error(8, "Array to string conversion", "/home/kristina/code/1610stable/htdocs/lib/adodb/ad...", 45, array(size 7)) at /home/kristina/code/1610stable/htdocs/lib/adodb/adodb-exceptions.inc.php:45 ADODB_Exception->__construct("postgres8", "adodb_throw", -1, "ERROR: value too long for type character varying(...", "INSERT INTO "group" ("id", "name", "description", ...", array(size 28), object(ADODB_postgres8)) at /home/kristina/code/1610stable/htdocs/lib/adodb/adodb-exceptions.inc.php:80 adodb_throw("postgres8", "adodb_throw", -1, "ERROR: value too long for type character varying(...", "INSERT INTO "group" ("id", "name", "description", ...", array(size 28), object(ADODB_postgres8)) at /home/kristina/code/1610stable/htdocs/lib/adodb/adodb.inc.php:298 ADODB_TransMonitor("postgres8", "EXECUTE", -1, "ERROR: value too long for type character varying(...", "INSERT INTO "group" ("id", "name", "description", ...", array(size 28), object(ADODB_postgres8)) at /home/kristina/code/1610stable/htdocs/lib/adodb/adodb.inc.php:1249 ADOConnection->_Execute("INSERT INTO "group" ("id", "name", "description", ...", array(size 28)) at /home/kristina/code/1610stable/htdocs/lib/adodb/adodb.inc.php:1209 ADOConnection->Execute("INSERT INTO "group" ("id", "name", "description", ...", array(size 28)) at /home/kristina/code/1610stable/htdocs/lib/dml.php:1085 insert_record("group", object(stdClass), "id", true) at /home/kristina/code/1610stable/htdocs/lib/group.php:451 group_create(array(size 31)) at /home/kristina/code/1610stable/htdocs/lib/group.php:2808 group_copy(2, "adminlist") at /home/kristina/code/1610stable/htdocs/group/copy.php:37 [WAR] d3 (lib/errors.php:819) Failed to get a recordset: postgres8 error: [-1: ERROR: value too long for type character varying(30)] in adodb_throw(INSERT INTO "group" ("id", "name", "description", "grouptype", "jointype", "ctime", "mtime", "public", "usersautoadded", "category", "viewnotify", "quota", "institution", "shortname", "request", "submittableto", "editroles", "hidden", "hidemembers", "hidemembersfrommembers", "groupparticipationreports", "invitefriends", "suggestfriends", "urlid", "editwindowend", "sendnow", "feedbacknotify", "allowarchives") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), Array) Command was: INSERT INTO "group" ("id", "name", "description", "grouptype", "jointype", "ctime", "mtime", "public", "usersautoadded", "category", "viewnotify", "quota", "institution", "shortname", "request", "submittableto", "editroles", "hidden", "hidemembers", "hidemembersfrommembers", "groupparticipationreports", "invitefriends", "suggestfriends", "urlid", "editwindowend", "sendnow", "feedbacknotify", "allowarchives") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and values was (id:10,name:HumanComputerInteraction101v.2,description:Foundationcourseforbeginners,grouptype:course,jointype:approve,ctime:2016-09-2307:15:43,mtime:2016-09-2307:15:43,public:0,usersautoadded:0,category:1,viewnotify:1,quota:52428800,institution:mahara,shortname:humancomputerinteraction101a,request:1,submittableto:1,editroles:notmember,hidden:0,hidemembers:0,hidemembersfrommembers:0,groupparticipationreports:0,invitefriends:1,suggestfriends:0,urlid:human -computer-interaction-101-v-2,editwindowend:2016-11-0700:00:00,sendnow:0,feedbacknotify:1,allowarchives:0) Call stack (most recent first): log_message("Failed to get a recordset: postgres8 error: [-1: E...", 8, true, true) at /home/kristina/code/1610stable/htdocs/lib/errors.php:95 log_warn("Failed to get a recordset: postgres8 error: [-1: E...") at /home/kristina/code/1610stable/htdocs/lib/errors.php:819 SQLException->__construct("Failed to get a recordset: postgres8 error: [-1: E...") at /home/kristina/code/1610stable/htdocs/lib/dml.php:1088 insert_record("group", object(stdClass), "id", true) at /home/kristina/code/1610stable/htdocs/lib/group.php:4
[Mahara-contributors] [Bug 1626705] Re: Copying of group throws ADODB error
The problem is the value of group urlid is longer than 30. This value is generated by the function generate_urlid() at line 2799, htdocs/lib/group.php $group->urlid = generate_urlid($group->name, get_config('cleanurlviewdefault'), 3, 100); The max length should set to 30 -- You received this bug notification because you are a member of Mahara Contributors, which is subscribed to Mahara. Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before editing or unsubscribing it! https://bugs.launchpad.net/bugs/1626705 Title: Copying of group throws ADODB error Status in Mahara: In Progress Bug description: Mahara 16.10dev, upgraded site from Mahara 16.04 I upgraded my site from 16.04 and when attempting to copy a group, it throws the following error: [WAR] d3 (lib/adodb/adodb-exceptions.inc.php:45) Array to string conversion Call stack (most recent first): log_message("Array to string conversion", 8, true, true, "/home/kristina/code/1610stable/htdocs/lib/adodb/ad...", 45) at /home/kristina/code/1610stable/htdocs/lib/errors.php:513 error(8, "Array to string conversion", "/home/kristina/code/1610stable/htdocs/lib/adodb/ad...", 45, array(size 7)) at /home/kristina/code/1610stable/htdocs/lib/adodb/adodb-exceptions.inc.php:45 ADODB_Exception->__construct("postgres8", "adodb_throw", -1, "ERROR: value too long for type character varying(...", "INSERT INTO "group" ("id", "name", "description", ...", array(size 28), object(ADODB_postgres8)) at /home/kristina/code/1610stable/htdocs/lib/adodb/adodb-exceptions.inc.php:80 adodb_throw("postgres8", "adodb_throw", -1, "ERROR: value too long for type character varying(...", "INSERT INTO "group" ("id", "name", "description", ...", array(size 28), object(ADODB_postgres8)) at /home/kristina/code/1610stable/htdocs/lib/adodb/adodb.inc.php:298 ADODB_TransMonitor("postgres8", "EXECUTE", -1, "ERROR: value too long for type character varying(...", "INSERT INTO "group" ("id", "name", "description", ...", array(size 28), object(ADODB_postgres8)) at /home/kristina/code/1610stable/htdocs/lib/adodb/adodb.inc.php:1249 ADOConnection->_Execute("INSERT INTO "group" ("id", "name", "description", ...", array(size 28)) at /home/kristina/code/1610stable/htdocs/lib/adodb/adodb.inc.php:1209 ADOConnection->Execute("INSERT INTO "group" ("id", "name", "description", ...", array(size 28)) at /home/kristina/code/1610stable/htdocs/lib/dml.php:1085 insert_record("group", object(stdClass), "id", true) at /home/kristina/code/1610stable/htdocs/lib/group.php:451 group_create(array(size 31)) at /home/kristina/code/1610stable/htdocs/lib/group.php:2808 group_copy(2, "adminlist") at /home/kristina/code/1610stable/htdocs/group/copy.php:37 [WAR] d3 (lib/errors.php:819) Failed to get a recordset: postgres8 error: [-1: ERROR: value too long for type character varying(30)] in adodb_throw(INSERT INTO "group" ("id", "name", "description", "grouptype", "jointype", "ctime", "mtime", "public", "usersautoadded", "category", "viewnotify", "quota", "institution", "shortname", "request", "submittableto", "editroles", "hidden", "hidemembers", "hidemembersfrommembers", "groupparticipationreports", "invitefriends", "suggestfriends", "urlid", "editwindowend", "sendnow", "feedbacknotify", "allowarchives") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), Array) Command was: INSERT INTO "group" ("id", "name", "description", "grouptype", "jointype", "ctime", "mtime", "public", "usersautoadded", "category", "viewnotify", "quota", "institution", "shortname", "request", "submittableto", "editroles", "hidden", "hidemembers", "hidemembersfrommembers", "groupparticipationreports", "invitefriends", "suggestfriends", "urlid", "editwindowend", "sendnow", "feedbacknotify", "allowarchives") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and values was (id:10,name:HumanComputerInteraction101v.2,description:Foundationcourseforbeginners,grouptype:course,jointype:approve,ctime:2016-09-2307:15:43,mtime:2016-09-2307:15:43,public:0,usersautoadded:0,category:1,viewnotify:1,quota:52428800,institution:mahara,shortname:humancomputerinteraction101a,request:1,submittableto:1,editroles:notmember,hidden:0,hidemembers:0,hidemembersfrommembers:0,groupparticipationreports:0,invitefriends:1,suggestfriends:0,urlid:human -computer-interaction-101-v-2,editwindowend:2016-11-0700:00:00,sendnow:0,feedbacknotify:1,allowarchives:0) Call stack (most recent first): log_message("Failed to get a recordset: postgres8 error: [-1: E...", 8, true, true) at /home/kristina/code/1610stable/htdocs/lib/errors.php:95 log_warn("Failed to get a recordset: postgres8 error: [-1: E...") at /home/kristina/code/1610stable/htdocs/lib/errors.php:819 SQLException->__construct("Failed to get a recordse
[Mahara-contributors] [Bug 1626705] Re: Copying of group throws ADODB error
** Changed in: mahara Assignee: (unassigned) => Son Nguyen (ngson2000) ** Changed in: mahara Status: Confirmed => In Progress -- You received this bug notification because you are a member of Mahara Contributors, which is subscribed to Mahara. Matching subscriptions: Subscription for all Mahara Contributors -- please ask on #mahara-dev or mahara.org forum before editing or unsubscribing it! https://bugs.launchpad.net/bugs/1626705 Title: Copying of group throws ADODB error Status in Mahara: In Progress Bug description: Mahara 16.10dev, upgraded site from Mahara 16.04 I upgraded my site from 16.04 and when attempting to copy a group, it throws the following error: [WAR] d3 (lib/adodb/adodb-exceptions.inc.php:45) Array to string conversion Call stack (most recent first): log_message("Array to string conversion", 8, true, true, "/home/kristina/code/1610stable/htdocs/lib/adodb/ad...", 45) at /home/kristina/code/1610stable/htdocs/lib/errors.php:513 error(8, "Array to string conversion", "/home/kristina/code/1610stable/htdocs/lib/adodb/ad...", 45, array(size 7)) at /home/kristina/code/1610stable/htdocs/lib/adodb/adodb-exceptions.inc.php:45 ADODB_Exception->__construct("postgres8", "adodb_throw", -1, "ERROR: value too long for type character varying(...", "INSERT INTO "group" ("id", "name", "description", ...", array(size 28), object(ADODB_postgres8)) at /home/kristina/code/1610stable/htdocs/lib/adodb/adodb-exceptions.inc.php:80 adodb_throw("postgres8", "adodb_throw", -1, "ERROR: value too long for type character varying(...", "INSERT INTO "group" ("id", "name", "description", ...", array(size 28), object(ADODB_postgres8)) at /home/kristina/code/1610stable/htdocs/lib/adodb/adodb.inc.php:298 ADODB_TransMonitor("postgres8", "EXECUTE", -1, "ERROR: value too long for type character varying(...", "INSERT INTO "group" ("id", "name", "description", ...", array(size 28), object(ADODB_postgres8)) at /home/kristina/code/1610stable/htdocs/lib/adodb/adodb.inc.php:1249 ADOConnection->_Execute("INSERT INTO "group" ("id", "name", "description", ...", array(size 28)) at /home/kristina/code/1610stable/htdocs/lib/adodb/adodb.inc.php:1209 ADOConnection->Execute("INSERT INTO "group" ("id", "name", "description", ...", array(size 28)) at /home/kristina/code/1610stable/htdocs/lib/dml.php:1085 insert_record("group", object(stdClass), "id", true) at /home/kristina/code/1610stable/htdocs/lib/group.php:451 group_create(array(size 31)) at /home/kristina/code/1610stable/htdocs/lib/group.php:2808 group_copy(2, "adminlist") at /home/kristina/code/1610stable/htdocs/group/copy.php:37 [WAR] d3 (lib/errors.php:819) Failed to get a recordset: postgres8 error: [-1: ERROR: value too long for type character varying(30)] in adodb_throw(INSERT INTO "group" ("id", "name", "description", "grouptype", "jointype", "ctime", "mtime", "public", "usersautoadded", "category", "viewnotify", "quota", "institution", "shortname", "request", "submittableto", "editroles", "hidden", "hidemembers", "hidemembersfrommembers", "groupparticipationreports", "invitefriends", "suggestfriends", "urlid", "editwindowend", "sendnow", "feedbacknotify", "allowarchives") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?), Array) Command was: INSERT INTO "group" ("id", "name", "description", "grouptype", "jointype", "ctime", "mtime", "public", "usersautoadded", "category", "viewnotify", "quota", "institution", "shortname", "request", "submittableto", "editroles", "hidden", "hidemembers", "hidemembersfrommembers", "groupparticipationreports", "invitefriends", "suggestfriends", "urlid", "editwindowend", "sendnow", "feedbacknotify", "allowarchives") VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) and values was (id:10,name:HumanComputerInteraction101v.2,description:Foundationcourseforbeginners,grouptype:course,jointype:approve,ctime:2016-09-2307:15:43,mtime:2016-09-2307:15:43,public:0,usersautoadded:0,category:1,viewnotify:1,quota:52428800,institution:mahara,shortname:humancomputerinteraction101a,request:1,submittableto:1,editroles:notmember,hidden:0,hidemembers:0,hidemembersfrommembers:0,groupparticipationreports:0,invitefriends:1,suggestfriends:0,urlid:human -computer-interaction-101-v-2,editwindowend:2016-11-0700:00:00,sendnow:0,feedbacknotify:1,allowarchives:0) Call stack (most recent first): log_message("Failed to get a recordset: postgres8 error: [-1: E...", 8, true, true) at /home/kristina/code/1610stable/htdocs/lib/errors.php:95 log_warn("Failed to get a recordset: postgres8 error: [-1: E...") at /home/kristina/code/1610stable/htdocs/lib/errors.php:819 SQLException->__construct("Failed to get a recordset: postgres8 error: [-1: E...") at /home/kristina/code/1610stable/htdocs/lib/dml.php:1088 insert_record("group", object(stdClass)