Incorrect datetime value DB ERROR on editing closing time

[morphinestyle]

Hello,
when i edit (not making new, only on editing) closing time i get this error:

Save failed with the following error: Incorrect datetime value: '' for column `XXXXXX`.`XXXXX_phocacart_opening_times`.`date` at row 1

it's a my installation issue and i can solve by myself, or there's some issue on editing?

[Jan]

Hi, are you able to test Beta version, this should be OK in latest Beta:

https://github.com/PhocaCz/PhocaCart/re ... Beta37.zip

Jan

[morphinestyle]

Hi Jan!
I will try as soon!

[Jan]

You can try the Beta38 now:
https://github.com/PhocaCz/PhocaCart/re ... Beta38.zip

[morphinestyle]

May I try this beta on a developing website without problems?
Phoca Cart will be updated as regular on final 4.0.6 version?

[Jan]

You can test the RC version:

https://www.phoca.cz/download/category/ ... -component

Usually, the installator should add all new columns when installting the developement vesion and then when updating to stable there will be no more update of columns, etc. (all the instructions set in update sql).

So usually it should work without any problem.

But of course if some problem happens, mostly e.g. adding manually new columns per update sql in phpMyAdmin helps.

Jan

[Nidzo]

From my experience with lates releases if you have db problem try to go Joomla System settings and in Maintenance tab check do you have Database or Global Checkin warnings. Fixing them fixed my problems with Phoca Cart db structure.