Phoca Forum

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

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

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

From which version did you try to update?

Jan