Date in backend orders is wrong

Phoca Cart - complex e-commerce extension
muweb
Phoca Enthusiast
Phoca Enthusiast
Posts: 77
Joined: 27 Mar 2019, 12:42

Re: Date in backend orders is wrong

Post by muweb » 20 May 2020, 08:32

Hello Jan

Just installed 3.5.2. It's not working.
Now the creation date stays at 0000-00-00 00:00:00. Even if I set a new status.

Language: 'de-DE' with 'de-DE.com_phocacart-j3.zip' by Benno (9 May 2020).

User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 42872
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Date in backend orders is wrong

Post by Jan » 21 May 2020, 22:21

Hi, the problem was, that the date format was used by current language. I have changed it, so the date format is not use and standard SQL format is used. So now the format is OK on your site. The problem is, it was emptied by previous problem. So it will not happen in next order but for current orders where the date was emptied, the date needs to be added manually back in e.g. phpMyAdmin.

Another way could be temporarily disable the readonly parameter for the date and add the date and then set the readonly back, open this file:
administrator\components\com_phocacart\models\forms\phocacartorder.xml

On line cca 67 remove

Code: Select all

readonly="readonly"
add the dates manually

Image

and then set back the readonly attribute.

Jan
If you find Phoca extensions useful, please support the project

Post Reply