Product discount and special : 0000-00-00 date rejected during db Restore

Hi All,
I am reporting for OC V4.1.0.3.
When activating product discount the UI will accept no values to be filled in the date field.
strangely the record will be saved with a 0000-00-00 value, instead of null, which is not a valid one.
Therefore during a db restore an error will be thrown and the restore will be stopped as the
value of 0000-00-00 will be refused as a valid data of one of these two tables :

• oc_product_discount
• oc_product_special

If one have this issue restoring his database he can replace in the sql backup file all occurrences
of 0000-00-00 by null or any valid date.
As usual as a basic safety do not work with your original backup ! hth

You can also just remove NO_ZERO_DATE from sql_mode. OpenCart 4 already does this.
https://github.com/opencart/opencart/co ... 11c5e3084f

Thanks for pointing this out.
Due to an unidentified stop while restoring the base I was using CLI restore, this is why this problem occur.
If you only have Opencart on your system you could also globally accept 0000-00-00 type date in the configuration file :