Using 157c (same issue found in 157b)

When adding featured products in admin, if no date is selected, the product is added successfully. If however you enter the start and end dates the following error is generated.

Newly upgraded to 157c, date format set as ddmmyyyy for use in South Africa. PHP 7.4 and MySQL 5.7

Admin directory name changed for security reasons.


08-Mar-2021 19:31:30 Africa/Johannesburg] Request URI: /xxxxxxadmin/index.php?cmd=featured&page=2&action=insert, IP address: 197.184.44.194
#1 trigger_error() called at [/includes/classes/db/mysql/query_factory.php:170]
#2 queryFactory->show_error() called at [/includes/classes/db/mysql/query_factory.php:142]
#3 queryFactory->set_error() called at [/includes/classes/db/mysql/query_factory.php:269]
#4 queryFactory->Execute() called at [/xxxxxxadmin/featured.php:39]
#5 require(/xxxxxxxadmin/featured.php) called at [/xxxxxxxadmin/index.php:11]
--> PHP Fatal error: 1292:Incorrect date value: '20213103' for column 'expires_date' at row 1 :: INSERT INTO astro_featured (products_id, featured_date_added, expires_date, status, featured_date_available)
VALUES (3725,
now(),
'20213103',
'1',
'20210103') ==> (as called by) /xxxxxxadmin/featured.php on line 39 <== in /includes/classes/db/mysql/query_factory.php on line 170.