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
Problems with cart Version 3.5.8 while installation
-
eichners
- Phoca Member

- Posts: 17
- Joined: 23 Apr 2021, 11:14
- Jan
- Phoca Hero

- Posts: 49138
- Joined: 10 Nov 2007, 18:23
- Location: Czech Republic
- Contact:
Re: Problems with cart Version 3.5.8 while installation
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
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
If you find Phoca extensions useful, please support the project