General discussion of OpenCATS

Moderators: RussH, cptr13

Forum rules: Just remember to play nicely once you walk through the door. You can disagree with us, or any other commenters in this forum, but keep comments directed to the topic at hand.
By murtaza
#2306
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
User avatar
By cptr13
#2309
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?

It's essential to keep these synchronized to ensur[…]

Export part in Job Order order search

Same problem as mine. Maybe you're right, I'll che[…]

The error message you're encountering indicates th[…]

Errors restoring mysqldump backup

doesnot work for me