[Mahara-contributors] [Bug 1626705] Re: Copying of group throws ADODB error

2016-10-20 Thread Robert Lyon
** 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 

[Mahara-contributors] [Bug 1626705] Re: Copying of group throws ADODB error

2016-10-06 Thread Robert Lyon
** 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 

[Mahara-contributors] [Bug 1626705] Re: Copying of group throws ADODB error

2016-09-22 Thread Son Nguyen
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 

[Mahara-contributors] [Bug 1626705] Re: Copying of group throws ADODB error

2016-09-22 Thread Son Nguyen
** 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",