11.12.2019 18:12
|
|
daswirdwas
Name: Brix
16.11.2012
Posts: 24
|
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
Joomla: 3.9.13 JoomShopping: 4.18.3 PHP: 7.3.12 MySQL: 8.0.16-7 Website Url: https://colours-of-sound.com
|
|
12.12.2019 08:22
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Posts: 25914
|
Aw: 1525 Incorrect DATETIME value: '%-%-% %' while opening "Orders" tab
Will be fixed in new version JoomSjopping
|
|
12.12.2019 09:57
|
|
daswirdwas
Name: Brix
16.11.2012
Posts: 24
|
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
|
|
12.12.2019 15:57
|
|
admin
(Support Team)
Name: Admin
05.08.2010
Posts: 25914
|
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." %'";
|
|
13.12.2019 13:53
|
|
daswirdwas
Name: Brix
16.11.2012
Posts: 24
|
Aw: 1525 Incorrect DATETIME value: '%-%-% %' while opening "Orders" tab
Done! Works! Thank you
|
|