Configuration Error

A discussion of other Open ATS systems... don't take Open/CATS into here!
Adverts for commercial products will be deleted.

Moderator: RussH

Forum rules
Just please remember to play nicely once you walk through the door. You can disagree with us, or any other commenters in this forum, but keep your comments directed to the topic at hand - not at the commenter.

Configuration Error

Postby murtaza » 01 Jun 2016, 06:30

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



Kindly guide us how to resolve this issue.
murtaza
 
Posts: 2
Joined: 01 Jun 2016, 06:03

Re: Configuration Error

Postby RussH » 06 Jul 2016, 12:33

You have 'MySQL Strict mode' enabled.

See http://stackoverflow.com/questions/3637 ... r-datetime
RussH

Report your issues and feature requests;
https://github.com/opencats/opencats/issues


Submit and vote on feature requests;
http://opencats.uservoice.com
User avatar
RussH
Site Admin
 
Posts: 622
Joined: 12 Apr 2008, 08:28
Location: UK


Return to Other open ATS systems

Who is online

Users browsing this forum: No registered users and 1 guest