Problems with cart Version 3.5.8 while installation

Phoca Cart - complex e-commerce extension
eichners
Phoca Member
Phoca Member
Posts: 17
Joined: 23 Apr 2021, 11:14

Problems with cart Version 3.5.8 while installation

Post by eichners »

Duplicate column name 'active_quantity'
SQL =
ALTER TABLE `#__phocacart_shipping_methods` ADD COLUMN `active_quantity` tinyint(1) NOT NULL DEFAULT '0';

Does anybody else had the same issue? Please help!

THX
Stephan
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 49138
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Problems with cart Version 3.5.8 while installation

Post by Jan »

Hi, usually, in case, some column is included in database yet and installation ZIP with such instruction is installed, the update SQL needs to be edited and repacked.

But this update SQL:
ALTER TABLE `#__phocacart_shipping_methods` ADD COLUMN `active_quantity` tinyint(1) NOT NULL DEFAULT '0';

is a part of
administrator/components/com_phocacart/update/sql/mysql/3.0.1.sql file

So the question is, why Joomla installation process tries to update 3.0.1.sql file when you install 3.5.8 version :idea:

In fact, there were no change between 3.5.7 and 3.5.8 regarding database, so there is even no SQL update file for 3.5.8 :idea:

From which version did you try to update?

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