Error while product creating Field 'delivery_date' doesn't have a default value

[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

[Net]

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?

[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

[Net]

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.

[Nidzo]

Is the problem still present?

[Net]

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

[Nidzo]

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

[Nidzo]

So you can use 0000-00-00 00:00:00 for both

[Jan]

Hi, there is no stock column in submit function.

Jan

[Net]

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.