Gradebook

ok - I looked; both copies of the install (local and server - are both having the same problem) have users with full privileges to the relevant database. Both also have the grade_events_grades table - just not grade_events...

when trying to run the query manually to create the tables (through phpmyadmin) the following was returned: "#1101 - BLOB/TEXT column 'description' can't have a default value"

does this shed any light on anything?

the mysql.php file I downloaded looks like this:

<?php

function create_tables() {

global $CFG;
       
execute_sql("
  Create table `{$CFG->mdl_}grade_events` (
            `id` int(10) unsigned NOT NULL auto_increment,
            `course` int(10) unsigned NOT NULL default 0,
            `name` varchar(255) NOT NULL default '',
            `description` text NOT NULL default '',
            `grade` decimal(11,2) NOT NULL default 0.00,
            `timemodified` int(10) unsigned NOT NULL default 0,
            PRIMARY KEY  (`id`));
            ");
           
execute_sql("
        Create table `{$CFG->mdl_}grade_events_grades` (
                `id` int(10) unsigned NOT NULL auto_increment,
                `event` int(10) unsigned NOT NULL default 0,
                `userid` int(10) unsigned NOT NULL default 0,
                `grade` decimal(11,2) NOT NULL default 0.00,
                `teacher` int(10) unsigned NOT NULL default 0,
                `timemarked` int(10) unsigned NOT NULL default 0,
                PRIMARY KEY  (`id`));
            ");
}

?>
 -  I assume that is normal?

Any further ideas of what might be wrong?

Lael