Note: You are currently viewing documentation for Moodle 2.0. Up-to-date documentation for the latest stable version is available here: error/moodle/erroreditgroup.

error/moodle/erroreditgroup

From MoodleDocs
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

Moodle Error - ErrorEditGroup

Error comment: Can be caused by missing or corrupt mdl_groups_ tables. Solution: Verify an/or repair mdl_groups_ tables.

Moodle Group Tables

mdl_groups, mdl_groups_courses_groupings, mdl_groups_courses_groups, mdl_groups_groupings, mdl_groups_groupings_groups, mdl_groups_members, mdl_group_membership

Table structure for table `mdl_groups`

CREATE TABLE IF NOT EXISTS `mdl_groups` (

 `id` int(10) unsigned NOT NULL auto_increment,
 `name` varchar(254) NOT NULL default ,
 `description` text,
 `enrolmentkey` varchar(50) NOT NULL default ,
 `lang` varchar(30) NOT NULL default 'en',
 `theme` varchar(50) NOT NULL default ,
 `picture` int(10) unsigned NOT NULL default '0',
 `hidepicture` tinyint(1) unsigned NOT NULL default '0',
 `timecreated` int(10) unsigned NOT NULL default '0',
 `timemodified` int(10) unsigned NOT NULL default '0',
 PRIMARY KEY  (`id`),
 UNIQUE KEY `id` (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Each record is a group in a course.' AUTO_INCREMENT=41 ;

Table structure for table `mdl_groups_courses_groupings`

CREATE TABLE IF NOT EXISTS `mdl_groups_courses_groupings` (

 `id` bigint(10) NOT NULL auto_increment,
 `courseid` bigint(10) unsigned NOT NULL default '0',
 `groupingid` bigint(10) unsigned NOT NULL default '0',
 PRIMARY KEY  (`id`),
 UNIQUE KEY `mdl_groucourgrou_cougro2_uix` (`courseid`,`groupingid`),
 KEY `mdl_groucourgrou_cou2_ix` (`courseid`),
 KEY `mdl_groucourgrou_gro2_ix` (`groupingid`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Link a grouping to a course (or the site).' AUTO_INCREMENT=1 ;

Table structure for table `mdl_groups_courses_groups`

CREATE TABLE IF NOT EXISTS `mdl_groups_courses_groups` (

 `id` bigint(10) NOT NULL auto_increment,
 `courseid` bigint(10) unsigned NOT NULL default '0',
 `groupid` bigint(10) unsigned NOT NULL default '0',
 PRIMARY KEY  (`id`),
 UNIQUE KEY `mdl_groucourgrou_cougro_uix` (`courseid`,`groupid`),
 KEY `mdl_groucourgrou_cou_ix` (`courseid`),
 KEY `mdl_groucourgrou_gro_ix` (`groupid`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Link a group to a course (or the site).' AUTO_INCREMENT=6 ;

Table structure for table `mdl_groups_groupings`

CREATE TABLE IF NOT EXISTS `mdl_groups_groupings` (

 `id` bigint(10) NOT NULL auto_increment,
 `name` varchar(255) NOT NULL default ,
 `description` text,
 `timecreated` bigint(10) unsigned NOT NULL default '0',
 `viewowngroup` tinyint(1) unsigned NOT NULL default '1',
 `viewallgroupsmembers` tinyint(1) unsigned NOT NULL default '0',
 `viewallgroupsactivities` tinyint(1) unsigned NOT NULL default '0',
 `teachersgroupmark` tinyint(1) unsigned NOT NULL default '0',
 `teachersgroupview` tinyint(1) unsigned NOT NULL default '0',
 `teachersoverride` tinyint(1) unsigned NOT NULL default '0',
 `teacherdeletable` tinyint(1) unsigned NOT NULL default '0',
 PRIMARY KEY  (`id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='A grouping is a collection of groups.' AUTO_INCREMENT=1 ;

Table structure for table `mdl_groups_groupings_groups`

CREATE TABLE IF NOT EXISTS `mdl_groups_groupings_groups` (

 `id` bigint(10) NOT NULL auto_increment,
 `groupingid` bigint(10) unsigned NOT NULL default '0',
 `groupid` bigint(10) unsigned NOT NULL default '0',
 `timeadded` bigint(10) unsigned NOT NULL default '0',
 PRIMARY KEY  (`id`),
 UNIQUE KEY `mdl_grougrougrou_grogro_uix` (`groupingid`,`groupid`),
 KEY `mdl_grougrougrou_gro_ix` (`groupingid`),
 KEY `mdl_grougrougrou_gro2_ix` (`groupid`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Link a group to a grouping.' AUTO_INCREMENT=1 ;

Table structure for table `mdl_groups_members`

CREATE TABLE IF NOT EXISTS `mdl_groups_members` (

 `id` int(10) unsigned NOT NULL auto_increment,
 `groupid` int(10) unsigned NOT NULL default '0',
 `userid` int(10) unsigned NOT NULL default '0',
 `timeadded` int(10) unsigned NOT NULL default '0',
 PRIMARY KEY  (`id`),
 UNIQUE KEY `id` (`id`),
 KEY `groupid` (`groupid`),
 KEY `userid` (`userid`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Lists memberships of users to groups' AUTO_INCREMENT=309 ;

Table structure for table `mdl_group_membership`

CREATE TABLE IF NOT EXISTS `mdl_group_membership` (

 `ident` int(11) NOT NULL auto_increment,
 `user_id` int(11) NOT NULL default '0' COMMENT '-> users.ident',
 `group_id` int(11) NOT NULL default '0' COMMENT '-> groups.ident',
 PRIMARY KEY  (`ident`),
 KEY `user_id` (`user_id`,`group_id`)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci AUTO_INCREMENT=1 ;

-- Enjoy John T. Macklin (AKA ViperF117a)


link Moodle Tracker Article #[https://tracker.moodle.org/browse/MDL-11879 MDL-11879] JTM