Page 2 of 2
Re: problem when switching from 6.1.2 beta to 6.1.9 beta
Posted: 21 Apr 2026, 18:33
by Jan
Hi, and running this SQL:
ALTER TABLE `#__phocacart_order_products` MODIFY `default_price` DECIMAL(15, 4) NOT NULL DEFAULT '0';
didn't help?
Re: problem when switching from 6.1.2 beta to 6.1.9 beta
Posted: 21 Apr 2026, 21:54
by Nidzo
Re: problem when switching from 6.1.2 beta to 6.1.9 beta
Posted: 21 Apr 2026, 23:30
by Jan
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.
