Page 1 of 1
Incorrect datetime value DB ERROR on editing closing time
Posted: 07 Mar 2023, 11:48
by 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?
Re: Incorrect datetime value DB ERROR on editing closing time
Posted: 07 Mar 2023, 14:49
by 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
Re: Incorrect datetime value DB ERROR on editing closing time
Posted: 07 Mar 2023, 18:53
by morphinestyle
Hi Jan!
I will try as soon!
Re: Incorrect datetime value DB ERROR on editing closing time
Posted: 08 Mar 2023, 00:00
by Jan
Re: Incorrect datetime value DB ERROR on editing closing time
Posted: 08 Mar 2023, 01:42
by 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?
Re: Incorrect datetime value DB ERROR on editing closing time
Posted: 08 Mar 2023, 14:14
by 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
Re: Incorrect datetime value DB ERROR on editing closing time
Posted: 08 Mar 2023, 21:27
by 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.