Page 2 of 3
Re: Error while product creating Field 'delivery_date' doesn't have a default value
Posted: 07 Sep 2023, 23:04
by Jan
Hi, there could be e.g. some problem with uprade, where the new table column format was not set. I added some if clause there (which can prevent from such problem), try to test it with 4.0.9Beta4:
https://github.com/PhocaCz/PhocaCart/re ... 9Beta4.zip
and let me know.
Jan
Re: Error while product creating Field 'delivery_date' doesn't have a default value
Posted: 09 Sep 2023, 11:56
by Net
Jan wrote: ↑07 Sep 2023, 23:04
Hi, there could be e.g. some problem with uprade, where the new table column format was not set. I added some if clause there (which can prevent from such problem), try to test it with 4.0.9Beta4:
https://github.com/PhocaCz/PhocaCart/re ... 9Beta4.zip
and let me know.
Jan
regarding upgrade, i never did that, i literaly installed latest joomla 4.3.4 and latest phoca cart 4.0.8, with no other extension in joomla
I will try with beta, but is beta safe to use?
Re: Error while product creating Field 'delivery_date' doesn't have a default value
Posted: 09 Sep 2023, 12:53
by christine
Hi,
Of course it is "safe to use"
Make a backup beforehand. If the error disappears with the beta version, Jan will install it in the next release.
But first you should test it so that Jan knows.
Kind regards
Christine
Re: Error while product creating Field 'delivery_date' doesn't have a default value
Posted: 10 Sep 2023, 10:18
by Net
Jan wrote: ↑07 Sep 2023, 23:04
Hi, there could be e.g. some problem with uprade, where the new table column format was not set. I added some if clause there (which can prevent from such problem), try to test it with 4.0.9Beta4:
https://github.com/PhocaCz/PhocaCart/re ... 9Beta4.zip
and let me know.
Jan
Hi Jan,
with new beta version, before testing, should i revert old values in database from NULL to None in phpmyadmin?
Thank you Christine, installed latest beta.
Re: Error while product creating Field 'delivery_date' doesn't have a default value
Posted: 10 Sep 2023, 20:29
by Nidzo
Is the problem still present?
Re: Error while product creating Field 'delivery_date' doesn't have a default value
Posted: 10 Sep 2023, 23:19
by Net
Nidzo wrote: ↑10 Sep 2023, 20:29
Is the problem still present?
can you take a screenshoot of your values in table phocacart_products for modified and delivery_date rows
because if i change it to NULL it works, but stock doesnt transfer from submitted item to created product, this is now new problem, stock in created product is always 0
Re: Error while product creating Field 'delivery_date' doesn't have a default value
Posted: 11 Sep 2023, 12:38
by Nidzo
Net wrote: ↑10 Sep 2023, 23:19
Nidzo wrote: ↑10 Sep 2023, 20:29
Is the problem still present?
can you take a screenshoot of your values in table phocacart_products for modified and delivery_date rows
because if i change it to NULL it works, but stock doesnt transfer from submitted item to created product, this is now new problem, stock in created product is always 0
Re: Error while product creating Field 'delivery_date' doesn't have a default value
Posted: 11 Sep 2023, 20:45
by Nidzo
So you can use 0000-00-00 00:00:00 for both
Re: Error while product creating Field 'delivery_date' doesn't have a default value
Posted: 12 Sep 2023, 00:49
by Jan
Hi, there is no stock column in submit function.
Jan
Re: Error while product creating Field 'delivery_date' doesn't have a default value
Posted: 12 Sep 2023, 23:59
by Net
Jan wrote: ↑12 Sep 2023, 00:49
Hi, there is no stock column in submit function.
Jan
Hi,
what is unit_amount ?
It would be very useful if submit function would have stock amount.