Page 1 of 1
phocacart stock status - Field 'date' doesn't have a default value
Posted: 12 Sep 2023, 10:00
by 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
Re: phocacart stock status - Field 'date' doesn't have a default value
Posted: 13 Sep 2023, 13:06
by Jan
Hi, which Phoca Cart version do you use?
Jan
Re: phocacart stock status - Field 'date' doesn't have a default value
Posted: 13 Sep 2023, 16:35
by uoppah
Hi, version 4.0.8, joomla 4.3.4
Simone
Re: phocacart stock status - Field 'date' doesn't have a default value
Posted: 16 Sep 2023, 00:26
by Jan
Do you get the same problem with the latest Beta?
https://github.com/PhocaCz/PhocaCart/re ... 9Beta5.zip
Jan
Re: phocacart stock status - Field 'date' doesn't have a default value
Posted: 16 Sep 2023, 17:42
by uoppah
Unfortunately the same error appears
Re: phocacart stock status - Field 'date' doesn't have a default value
Posted: 17 Sep 2023, 13:34
by 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)
Re: phocacart stock status - Field 'date' doesn't have a default value
Posted: 18 Sep 2023, 00:01
by Net
Nidzo wrote: ↑17 Sep 2023, 13:34
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
Re: phocacart stock status - Field 'date' doesn't have a default value
Posted: 18 Sep 2023, 14:52
by 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
Re: phocacart stock status - Field 'date' doesn't have a default value
Posted: 18 Sep 2023, 14:56
by Nidzo
Great to here that
