1525 Incorrect DATETIME value: '%-%-% %' while opening "Orders" tab

1525 Incorrect DATETIME value: '%-%-% %' while opening "Orders" tab

Hello,
after update to MySQL 8.0.16-7 and Joomla! 3.9.13 we get the Error " 1525 Incorrect DATETIME value: '%-%-% %'". Changing the date format to values without % - no help.
Date within Database(Dataset of orders) is set correct.
Do you have any suggestions where the Error come from

Thank you for assistance
Andreas

---

Aw: 1525 Incorrect DATETIME value: '%-%-% %' while opening "Orders" tab

Will be fixed in new version JoomSjopping

Aw: 1525 Incorrect DATETIME value: '%-%-% %' while opening "Orders" tab

Hello, when will this NEW version be released?
Our shop could not be continued because we could not open/edit orders or issue any invoices !!! Pre x-mas time and shop out of order = not good!!!

URGEND HELP NEEDED

Aw: 1525 Incorrect DATETIME value: '%-%-% %' while opening "Orders" tab

Change code

administrator\components\com_jshopping\models\orders.php

delete row 28
$where .= " and O.order_date like '".$year."-".$month."-".$day." %'";

and row 60
$where .= " and O.order_date like '".$year."-".$month."-".$day." %'";

Aw: 1525 Incorrect DATETIME value: '%-%-% %' while opening "Orders" tab

Done! Works! Thank you