Possible problems when updating to 3.5.4

Phoca Cart - complex e-commerce extension
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 43010
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Possible problems when updating to 3.5.4

Post by Jan » 21 Sep 2020, 14:42

Unfortunately, MySQL database does not support following query:

ALTER TABLE ... ADD COLUMN IF NOT EXISTS

so there is no option to check if some column exists in database or not with standard Joomla! update function.

If you get following problem when updating to version 3.5.4:
Duplicate column name 'sku'
or
Duplicate column name 'ean'
try to use following installation ZIP:

a) if you know that you run MariaDB database: https://github.com/PhocaCz/PhocaCart/re ... ariadb.zip

or b) if you run MySQL database or you don't know which database you are running: https://github.com/PhocaCz/PhocaCart/re ... update.zip

This should skip adding EAN or SKU columns if they exist in your Phoca Cart instance.

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