problem when switching from 6.1.2 beta to 6.1.9 beta

Phoca Cart - complex e-commerce extension
User avatar
gikass
Phoca Member
Phoca Member
Posts: 10
Joined: 28 Dec 2023, 17:06

problem when switching from 6.1.2 beta to 6.1.9 beta

Post by gikass »

Hello, I appreciate the ease of use of this component, as well as others from Joomla. I have beta 2 installed and have now installed beta 9, but I'm experiencing problems with my Joomla database. The table _phocacart_order_ptoducts is reporting that it has incorrect attributes for default price, with the decimal type set to 15, as indicated in the 6.1.0.sql file. Thank you for your work.
User avatar
Slava
Phoca Member
Phoca Member
Posts: 39
Joined: 07 Nov 2025, 18:39

Re: problem when switching from 6.1.2 beta to 6.1.9 beta

Post by Slava »

J6.0.2/6.1.0Beta9

Hi, I’ve upgraded from 6.1.0Beta2 to 6.1.0Beta9, everything is working fine.
https://github.com/PhocaCz/PhocaCart/re ... 0Beta9.zip
Last edited by Slava on 07 Feb 2026, 11:27, edited 1 time in total.
User avatar
gikass
Phoca Member
Phoca Member
Posts: 10
Joined: 28 Dec 2023, 17:06

Re: problem when switching from 6.1.2 beta to 6.1.9 beta

Post by gikass »

It works fine with beta 2, the problem appears when I update to beta 9, I get the error mentioned.
User avatar
Slava
Phoca Member
Phoca Member
Posts: 39
Joined: 07 Nov 2025, 18:39

Re: problem when switching from 6.1.2 beta to 6.1.9 beta

Post by Slava »

What actions lead to the error (I’ll test them on my website)?
User avatar
gikass
Phoca Member
Phoca Member
Posts: 10
Joined: 28 Dec 2023, 17:06

Re: problem when switching from 6.1.2 beta to 6.1.9 beta

Post by gikass »

I'm getting a database error in Joomla 6.0.2. I've tried fixing it through Joomla, but it doesn't resolve the issue. Basically, Joomla is displaying an error message related to the database.
User avatar
Slava
Phoca Member
Phoca Member
Posts: 39
Joined: 07 Nov 2025, 18:39

Re: problem when switching from 6.1.2 beta to 6.1.9 beta

Post by Slava »

Reinstall the stable version of Phoca Cart if you can access the Joomla admin panel.
https://github.com/PhocaCz/PhocaCart/re ... v6.0.0.zip
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 49255
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, except that info message in your Joomla database area, do you get any error on the website?

The SQL update query is stored here:
ALTER TABLE `#__phocacart_order_products` MODIFY `default_price` DECIMAL(15, 4) NOT NULL DEFAULT '0';

Jan
If you find Phoca extensions useful, please support the project
User avatar
gikass
Phoca Member
Phoca Member
Posts: 10
Joined: 28 Dec 2023, 17:06

Re: problem when switching from 6.1.2 beta to 6.1.9 beta

Post by gikass »

solved thanks, I'm still trying this application
Post Reply