phocacart stock status - Field 'date' doesn't have a default value

[uoppah]

I tried to create a new "stock status" but it returns the error "Field 'date' doesn't have a default value". But there is no field date on the page.
Thank you, Simone

[Jan]

Hi, which Phoca Cart version do you use?

Jan

[uoppah]

Hi, version 4.0.8, joomla 4.3.4
Simone

[Jan]

Do you get the same problem with the latest Beta?
https://github.com/PhocaCz/PhocaCart/re ... 9Beta5.zip

Jan

[uoppah]

Unfortunately the same error appears

[Nidzo]

I can't reproduce problem. Tried with PC 4.0.7, 4.0.8, and all 4.0.9 betas
How do you fill Stock Status? Do you add image, description... or just name?
Can you optimize your database from phpMyAdmin and from Joomla backend update database structure of Phoca Cart (System>Database> Check Phoca Cart > Update Structure)

[Net]

I can't reproduce problem. Tried with PC 4.0.7, 4.0.8, and all 4.0.9 betas
How do you fill Stock Status? Do you add image, description... or just name?
Can you optimize your database from phpMyAdmin and from Joomla backend update database structure of Phoca Cart (System>Database> Check Phoca Cart > Update Structure)

I think this problem has the same root as i posted here, it comes from the phocacart new installation, the database is just not structured right, so these errors appear, since default values in database are originally missing...not sure who can fix this but Jan

[uoppah]

Hi, I tried what Nidzo wrote but it did not solve the problem. Then I tried to change the database structure. I changed the value of phocart_stock_statuses from None to NULL. In this way I was able to create a new stock status.
Thank you
Simone

[Nidzo]

Great to here that