After update 3.5.8

[mjmartino]

Hi.
After update 3.5.3 to 3.5.8
1) In control panel i don't have icon.
2) Phoca cart show still 3.5.3 ver.

https://prntscr.com/26vrmq1

how to fix?

Regards.

[Jan]

Hi, it looks like Phoca Cart was not correctly installed/upgraded. Try to reinstall it again.

No icons - this looks like the same as above, the font library which displays the icons is missing.

So it looks like some files are missing in your installation.

Jan

[mjmartino]

Jan
I can't reinstall because now have

Code: Select all

Duplicate column name 'predefined_values'.
SQL =
ALTER TABLE `#__phocacart_form_fields` ADD COLUMN `predefined_values` text;

SKU, EAN

This is alter table if exist should not be "Error SQL Duplicate column name 'predefined_values'."

[Jan]

Hi,

see similar posts here, there are two possible ways:

a) to completely uinstall and install it again - BE AWARE ALL DATA WILL BE LOST ( https://www.phoca.cz/documents/16-jooml ... m-manually )

b) or to step by step edit the SQL update files (when the system says the column exists, such needs to be removed from the update file) when installing (this procedure can be very long: https://www.phoca.cz/blog/1100-solution ... components

As written in the article, unfortunatelly, Phoca Cart does not install itself, so it has no tools to somehow prevent from such problems (which are mostly caused by installation feature and missing MySQL feature -ALTER TABLE ... ADD COLUMN IF NOT EXISTS )

Jan

[mjmartino]

Choose B)
I have manual add all sql from update.
Commenting on the query.
Update working.

Thanks, Jan

[Jan]

Ok