opencats.org

Query Error -- Please Report This Bug!

MySQL Query Failed: Invalid default value for 'date_created'

CREATE TABLE `activity` (
`activity_id` int(11) NOT NULL auto_increment,
`data_item_id` int(11) NOT NULL default '0',
`data_item_type` int(11) NOT NULL default '0',
`joborder_id` int(11) default NULL,
`site_id` int(11) NOT NULL default '0',
`entered_by` int(11) NOT NULL default '0',
`date_created` datetime NOT NULL default '0000-00-00 00:00:00',
`type` int(11) NOT NULL default '0',
`notes` text collate utf8_unicode_ci,
`date_modified` datetime NOT NULL default '0000-00-00 00:00:00',
PRIMARY KEY (`activity_id`),
KEY `IDX_entered_by` (`entered_by`),
KEY `IDX_site_id` (`site_id`),
KEY `IDX_type` (`type`),
KEY `IDX_data_item_type` (`data_item_type`),
KEY `IDX_type_id` (`data_item_type`,`data_item_id`),
KEY `IDX_joborder_id` (`joborder_id`),
KEY `IDX_date_created` (`date_created`),
KEY `IDX_date_modified` (`date_modified`),
KEY `IDX_data_item_id_type_site` (`site_id`,`data_item_id`,`data_item_type`),
KEY `IDX_site_created` (`site_id`,`date_created`),
KEY `IDX_activity_site_type_created_job` (`site_id`,`data_item_type`,`date_created`,`entered_by`,`joborder_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

Hi, can you provide some more information?

what version of OpenCATS are you running?
what platform are you running it on (WAMP/LAMP)

does your OpenCATS run on a Dedicated server, VPS, or shared?

Have you checked your error logs for your webserver? Do they tell you anything useful? Post them!
can you reproduce your error?

have you searched the site to see if it's already reported?