Hiya All,
I have encoutered a rarther strange error on the gradebook. When I enter, I get "Could not get an uncategorized id!" so i turned debugging on and recieved this.
-----------------------------------------------------------------------------------
Out of range value adjusted for column 'weight' at row 1
INSERT INTO mdl_grade_category ( NAME, COURSEID, DROP_X_LOWEST, BONUS_POINTS, HIDDEN, WEIGHT ) VALUES ( 'uncategorised', 2, 0, 0, 0, 100 )
-----------------------------------------------------------------------------------
I am on a Windows Server 2003 system with IIS.6, PHP 5.1.2, MySQL DB 5.0.18, runs like a dream. This is the one thing we use the most here, and it doesent work.
I have searched the site and found numerous solutions and followed steps, but... to no such luck. I'me not great on MySQL, must start learning it soon.... Any help would be much appreciated. Ime on Moodle 1.5.3 Stable Branch. I picked up this code from the mysql.php file under the lib/db file in Moodle:
}
if ($oldversion < 2005032800) {
execute_sql("CREATE TABLE `{$CFG->prefix}grade_category` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(64) default NULL,
`courseid` int(10) unsigned NOT NULL default '0',
`drop_x_lowest` int(10) unsigned NOT NULL default '0',
`bonus_points` int(10) unsigned NOT NULL default '0',
`hidden` int(10) unsigned NOT NULL default '0',
`weight` decimal(4,2) default '0.00',
PRIMARY KEY (`id`),
KEY `courseid` (`courseid`)
) TYPE=MyISAM ;");
Thanks Again for Reading,
Josh