error/moodle/erroreditgroup

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 #[http://tracker.moodle.org/browse/MDL-11879 MDL-11879] JTM