error/moodle/erroreditgroup: Difference between revisions
John Macklin (talk | contribs) (Error Moodle Groups [erroreditgroup]) |
John Macklin (talk | contribs) |
||
(One intermediate revision by the same user not shown) | |||
Line 9: | Line 9: | ||
mdl_group_membership | 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) | |||
[http://tracker.moodle.org/browse/MDL-11879 link Moodle Tracker Article #MDL-11879] | [http://tracker.moodle.org/browse/MDL-11879 link Moodle Tracker Article #MDL-11879] | ||
JTM | |||
[[Category:Error|Group]] | [[Category:Error|Group]] | ||
[[Category:Groups|Error]] | [[Category:Groups|Error]] |
Latest revision as of 18:28, 9 April 2008
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