problem when switching from 6.1.2 beta to 6.1.9 beta

Phoca Cart - complex e-commerce extension
User avatar
Jan
Phoca Hero
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

Post 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?
If you find Phoca extensions useful, please support the project
User avatar
Nidzo
Phoca Expert
Phoca Expert
Posts: 501
Joined: 07 Nov 2018, 14:55

Re: problem when switching from 6.1.2 beta to 6.1.9 beta

Post by Nidzo »

Unfortunately not :roll:
Image
Image
User avatar
Jan
Phoca Hero
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

Post 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.

Image
If you find Phoca extensions useful, please support the project
Post Reply