MySql 5.7 issue. I have tried to install sheffield blue on new server. using zencat 1.55 I Am getting a mysql error see below. I think it is due to using 0 (zero) as the default for a date in a table being created. My Mysql version is 5.7.13 php version 7.0.8.
Code:
[06-Sep-2016 15:12:23 Europe/London] PHP Fatal error: 1067:Invalid default value for 'date_added' :: CREATE TABLE IF NOT EXISTS zen_flexible_footer_menu(
page_id int(11) NOT NULL AUTO_INCREMENT,
language_id int(11) NOT NULL DEFAULT '1',
page_title varchar(64) CHARACTER SET utf8 NOT NULL DEFAULT '',
page_url varchar(255) CHARACTER SET utf8 DEFAULT NULL,
col_header varchar(64) CHARACTER SET utf8 DEFAULT NULL,
col_image varchar(254) CHARACTER SET utf8 NOT NULL DEFAULT '',
col_html_text text CHARACTER SET utf8,
status int(1) NOT NULL DEFAULT '0',
col_sort_order int(11) NOT NULL DEFAULT '0',
col_id int(11) NOT NULL DEFAULT '0',
date_added datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
last_update datetime DEFAULT NULL,
PRIMARY KEY (`page_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=29; ==> (as called by) /**********/includes/installers/responsive_sheffield_blue/2_0.php on line 138 <== in /**********/includes/classes/db/mysql/query_factory.php on line 167
I was thinking of changing date_added datetime NOT NULL DEFAULT '0000-00-00 00:00:00', to date_added datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
do you know it this will cause and issued. I do not have access to the server setting to allow me to remove NO_ZERO_DATE or STRICT_TRANS_TABLES.
There may be another way of doing this without changing the code. If any one knows please let me know.
Thanks
Bookmarks