I think it's a problem with the database. You probably have a wrong schema for the table mdl_event. I don't know how comfortable you are with PHP and My
SQL (
phpMyAdmin helps here), but you should check the schema for the table.
The correct schema (with today's
nightly version) is:
CREATE TABLE `mdl_event` (
`id` int(10) unsigned NOT NULL auto_increment,
`name` varchar(255) NOT NULL default '',
`description` text NOT NULL,
`format` int(4) unsigned NOT NULL default '0',
`courseid` int(10) unsigned NOT NULL default '0',
`groupid` int(10) unsigned NOT NULL default '0',
`userid` int(10) unsigned NOT NULL default '0',
`modulename` varchar(20) NOT NULL default '',
`instance` int(10) unsigned NOT NULL default '0',
`eventtype` varchar(20) NOT NULL default '',
`timestart` int(10) unsigned NOT NULL default '0',
`timeduration` int(10) unsigned NOT NULL default '0',
`visible` tinyint(1) NOT NULL default '1',
`timemodified` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`),
KEY `courseid` (`courseid`),
KEY `userid` (`userid`)
) TYPE=MyISAM COMMENT='For everything with a time associated to it'; ");
If you can, drop the table you have and create a new one with the above schema, and see if it works. If you don't feel comfortable or don't know how to do it, check back here.
