Page 1 of 1
Update Mysql Error to 3.5.4
Posted: 22 Nov 2020, 18:19
by fw115
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 ?
Re: Update Mysql Error to 3.5.4
Posted: 22 Nov 2020, 19:00
by christine
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
Re: Update Mysql Error to 3.5.4
Posted: 22 Nov 2020, 19:19
by fw115
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.
Re: Update Mysql Error to 3.5.4
Posted: 22 Nov 2020, 19:56
by christine
Hi,
Some checks, if OK:
Extensions > Manage > Manage
Extensions > Manage > Database
Extensions > Manage > Discover
PC > Check for Update, should be shown in this way:
Clear all Caches.
Kind regards
Christine