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

[Net]

After the user submits an item, from the backend i want to create a product based on this submitted item, however, i am having this error showing up in the backend when i click on Create product button:

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



Is there any solution to this....must be something i am missing to configure

Thank you in advance

[Nidzo]

I tried to reproduce error but everything is O.K. With filled delivery date and with blank field.
Do you need that field to be filled by user?

[Net]

I tried to reproduce error but everything is O.K. With filled delivery date and with blank field.
Do you need that field to be filled by user?

Thank you for your response.
I dont even need that field, nor i require it from user

This is what i have defined in the back end:
title*,unit_amount,catid_multiple,sku,ean,serial_number,description,condition

Can you try with the same fields like i have above? Fill the fields in the front end, submit, then in the back-end create product from it and let me know what happens?

looks like this in the backend:



and front end:

[Nidzo]

Everything is O.K.
Koju verziju Phoca Cart koristiš?

[Net]

Everything is O.K.
Koju verziju Phoca Cart koristiš?

I am using 4.0.8 phoca cart, with latest joomla 4 version




See this video https://transfer.sh/lJMpvh5IQM/phocaCar ... tError.mp4, maybe i am doing it wrong?

[Nidzo]

You are not doing anything wrong. That is process publishing submitted item.

Try to Update Structure of Phoca Cart Database


Try to install latest Beta version just for testing purposes and see what is happening: https://github.com/PhocaCz/PhocaCart/re ... 9Beta3.zip

[Net]

You are not doing anything wrong. That is process publishing submitted item.

Try to Update Structure of Phoca Cart Database


Try to install latest Beta version just for testing purposes and see what is happening: https://github.com/PhocaCz/PhocaCart/re ... 9Beta3.zip

As you suggested, i just made update structure of phoca cart database, but i get the same error.

Just to make sure, as a first step i go to address www....cms/administrator/index.php?option=com_phocacart&view=phocacartsubmititems

Then select submited item, then click on create button, right?

Or ideally, can you completely write down exact steps on how to do this, from the fron end user side, to back end settings and steps to create product from submited item

I am still suspecting i might have done wrong in configuration or in procedure

[Nidzo]

Same procedure like you did. Check video:
https://imgur.com/dsoo22X

[Net]

we still dont know what is going on, why does this delivery_date error comes up...its probably something trivial....hopefully Jan might see this post

[Net]

I think i found a solution, i went into phpmyadmin, searched for delivery_date in database, found it in phocacart_products, see screen shoot:

I changed this value from None to NULL
I hope this will not disrupt whole installation



Can you please check this value in your database so we can compare it