Hi, and running this SQL:
ALTER TABLE `#__phocacart_order_products` MODIFY `default_price` DECIMAL(15, 4) NOT NULL DEFAULT '0';
didn't help?
problem when switching from 6.1.2 beta to 6.1.9 beta
- Jan
- Phoca Hero

- Posts: 49365
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: problem when switching from 6.1.2 beta to 6.1.9 beta
If you find Phoca extensions useful, please support the project
- Nidzo
- Phoca Expert

- Posts: 501
- Joined: 07 Nov 2018, 14:55
- Jan
- Phoca Hero

- Posts: 49365
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: problem when switching from 6.1.2 beta to 6.1.9 beta
Ok, I found it. Joomla doesn't care about the real essence of the thing, but about the formatting. So if the entry in update sql is decimal( 15, 4 ) and it gets information about decimal(15,4) from the database, it's wrong for Joomla because there is no space, it's similar with zeros 0 and 0.0000 are different values. Even everything is OK in database, it wrongly says, it is not.
I changed it in version 6.1.0Beta12
https://www.phoca.cz/download/99-phoca- ... -component
It should be OK.

I changed it in version 6.1.0Beta12
https://www.phoca.cz/download/99-phoca- ... -component
It should be OK.

If you find Phoca extensions useful, please support the project

