​​For about four years, MySQL has failed at the use of the old null date 0f 0000-00-00.I made a ZC1.5.7b fresh install and copied the Westminster New template files. In my admin area I selected the Westminster New template. Immediately after that the Admin site crashes with "WARNING: An Error occurred, please refresh the page and try again. If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.".
I use XAMPP v3.2.4. There are no problems using other templates.
This is the content of the log file:
"[27-Dec-2020 13:24:02 Europe/Berlin] Request URI: /zencart/_adminarea_/index.php?cmd=template_select&page=1&tID=1, IP address: ::1
#1 trigger_error() called at [C:\xampp\htdocs\zencart\includes\classes\db\mysql\query_factory.php:170]
#2 queryFactory->show_error() called at [C:\xampp\htdocs\zencart\includes\classes\db\mysql\query_factory.php:142]
#3 queryFactory->set_error() called at [C:\xampp\htdocs\zencart\includes\classes\db\mysql\query_factory.php:269]
#4 queryFactory->Execute() called at [C:\xampp\htdocs\zencart\_adminarea_\includes\installers\westminster_new\2_0.php: 209]
#5 include_once(C:\xampp\htdocs\zencart\_adminarea_\includes\installers\westminster _new\2_0.php) called at [C:\xampp\htdocs\zencart\_adminarea_\includes\init_includes\init_westminster_new. php:21]
#6 require_once(C:\xampp\htdocs\zencart\_adminarea_\includes\init_includes\init_wes tminster_new.php) called at [C:\xampp\htdocs\zencart\includes\autoload_func.php:37]
#7 require(C:\xampp\htdocs\zencart\includes\autoload_func.php) called at [C:\xampp\htdocs\zencart\my_admin\includes\application_top.php:37]
#8 require(C:\xampp\htdocs\zencart\_adminarea_\includes\application_top.php) called at [C:\xampp\htdocs\zencart\my_admin\template_select.php:8]
#9 require(C:\xampp\htdocs\zencart\_adminarea_\template_select.php) called at [C:\xampp\htdocs\zencart\my_admin\index.php:11]
--> PHP Fatal error: 1067:Invalid default value for 'date_added' :: CREATE TABLE IF NOT EXISTS 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) C:\xampp\htdocs\zencart\_adminarea_\includes\installers\westminster_new\2_0.php on line 209 <== in C:\xampp\htdocs\zencart\includes\classes\db\mysql\query_factory.php on line 170."
https://docs.zen-cart.com/user/upgra...andardization/
Bookmarks