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:<p>Foundationcourseforbeginners</p>,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: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/dml.php:1088) 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:<p>Foundationcourseforbeginners</p>,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):

      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

To manage notifications about this bug go to:
https://bugs.launchpad.net/mahara/+bug/1626705/+subscriptions

_______________________________________________
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

Reply via email to