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

Phoca Cart - complex e-commerce extension
Net
Phoca Member
Phoca Member
Posts: 33
Joined: 29 Sep 2022, 00:28

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

Post by Net »

Nidzo wrote: 11 Sep 2023, 12:38
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
Image
Image
Hi,

i didnt mean this, but structure of table phocacart_products ...can you take screenshoot of that?
User avatar
Nidzo
Phoca Professional
Phoca Professional
Posts: 387
Joined: 07 Nov 2018, 14:55

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

Post by Nidzo »

Here you go
Image
Net
Phoca Member
Phoca Member
Posts: 33
Joined: 29 Sep 2022, 00:28

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

Post by Net »

Nidzo wrote: 13 Sep 2023, 11:42 Here you go
Image
Thank you for the screenshots.
Now seeing this, i notice now my database column "Default" is completely different in some rows than yours.....why is that? i installed latest joomla and latest phocacart.....i think wrong database structure was the root of the initial problems.
Post Reply