osCommerce / oscommerce2

osCommerce Online Merchant v2.x
http://www.oscommerce.com
MIT License
281 stars 222 forks source link

MySql Strict error #651

Open tgely opened 4 years ago

tgely commented 4 years ago

https://github.com/osCommerce/oscommerce2/blob/de0e97d15d43ac6a9a6cfb2847134a82a0148f2b/catalog/admin/products_expected.php#L19

[22-Aug-2019 19:02:16 Europe/Budapest] PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect datetime value: '' for column 'products_date_available' at row 29' in \catalog\includes\OSC\OM\Db.php:94 Stack trace:

0 \catalog\includes\OSC\OM\Db.php(94): PDO->exec('update osc_prod...')

1 \catalog\admin\products_expected.php(21): OSC\OM\Db->exec('update :table_p...')

2 {main}

thrown in \catalog\includes\OSC\OM\Db.php on line 94

"Null" would be better than ""