Apologies if this is not the correct place to ask this but all searches for grade_category ended up in this forum.
I have just moved my development Moodle server onto a production box. In doing so I did a backup and restore of the MySQL tables. This failed on restore since the six entries in my mdl_grade_category table all had values of weight stored as 100.00. MySQL correctly would not import this into a field defined as decimal(4,2). I got around the problem by editing the values in the backup to 99.99 which allowed the import to proceed.
Some version numbers
Development | Production | |
OS | Win XP SP2 | Win 2003 server |
php | 5.0.4 | 5.1.2 |
MySQL | 4.1.14 | 5.0.18 |
Moodle | 1.5.3+ (2005060230) | 1.5.3+ (2005060230) |
I appreciate that I have changed several things at once but in setting up a new server I chose to use the latest stable versions.
I have checked with phpMyAdmin and the values in the original table are truly 100.00 despite the definition of the weight field not supporting this.
Regards
Steve