Update Mysql Error to 3.5.4

Phoca Cart - complex e-commerce extension
fw115
Phoca Member
Phoca Member
Posts: 30
Joined: 27 Mar 2017, 15:25

Update Mysql Error to 3.5.4

Post by fw115 » 22 Nov 2020, 18:19

The Message is:

SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'sku'

And i get Displayed :
Phoca Cart Administrator Komponente 3.5.4 3.5.4 Unbekannt Aktualisierung https://raw.githubusercontent.com/Phoca ... nifest.xml

So it got installed twice ? I am confused. The system tells me the new version is installed but i get the above error.
Any ideas ?

christine
Phoca Hero
Phoca Hero
Posts: 2065
Joined: 28 Nov 2010, 17:20

Re: Update Mysql Error to 3.5.4

Post by christine » 22 Nov 2020, 19:00

Hi,

see here please: https://www.phoca.cz/blog/1100-solution ... components
1) SQL update files can be found in ZIP installation package, for example in Phoca Cart installation package, you can find them in following folder:

- ZIP: admin/update/sql/mysql

2) Unzip the installation ZIP package, go to the above mentioned folder and search in files for the column name which was displayed in error message.

3) Open the file where this column name occurs and comment the whole SQL command (starting with ALTER TABLE ...) or delete it (Comments in SQL files are set per double dashes (--))

For example FROM:

ALTER TABLE `#__phocacart_product_stock` ADD COLUMN `sku` varchar(255) NOT NULL DEFAULT '';
ALTER TABLE `#__phocacart_product_stock` ADD COLUMN `ean` varchar(15) NOT NULL DEFAULT '';

TO:

-- ALTER TABLE `#__phocacart_product_stock` ADD COLUMN `sku` varchar(255) NOT NULL DEFAULT '';
-- ALTER TABLE `#__phocacart_product_stock` ADD COLUMN `ean` varchar(15) NOT NULL DEFAULT '';


4) ZIP the installation package back (including newly edited files) and try to install the component again.

Kind regards
Christine

fw115
Phoca Member
Phoca Member
Posts: 30
Joined: 27 Mar 2017, 15:25

Re: Update Mysql Error to 3.5.4

Post by fw115 » 22 Nov 2020, 19:19

Thank you for that info. i totaly missed that.

after that i have no errors anymore, but the system still see an update from 3.5.4 to 3.5.4 and wants to install it, which kinda annoying.

christine
Phoca Hero
Phoca Hero
Posts: 2065
Joined: 28 Nov 2010, 17:20

Re: Update Mysql Error to 3.5.4

Post by christine » 22 Nov 2020, 19:56

Hi,

Some checks, if OK:
Extensions > Manage > Manage
Extensions > Manage > Database
Extensions > Manage > Discover

PC > Check for Update, should be shown in this way:

Image

Clear all Caches.

Kind regards
Christine

Post Reply