opencats.org

Hi,
I am getting the following error while installing:

! ) Deprecated: Function ereg_replace() is deprecated in C:\wamp64\www\cats-0.9.1\ajax.php on line 86
Call Stack
# Time Memory Function Location
1 0.0012 256840 {main}( ) ...\ajax.php:0

( ! ) Deprecated: Function ereg_replace() is deprecated in C:\wamp64\www\cats-0.9.1\ajax.php on line 87
Call Stack
# Time Memory Function Location
1 0.0012 256840 {main}( ) ...\ajax.php:0
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

Can someone please help?

I am using the following configuration:
Windows 10 Professional/ 64 Bit
WAMP Server (64 Bits & PHP 5.6.15 & PHP 7) 3
Apache 2.4.17/ MySQL 5.7.9 PHP 5.6.16 PHP 7 (essentially the following link http://www.wampserver.com/en/#wampserve ... 6-15-php-7)
cats-0.9.1.tar.gz

Thanks.
Nitin.

HI,

defaults have changed for MySQL 5.7 - you need to disable 'MySQL Strict mode'.