Phoca Gallery Installation Errors

[a2zcs]

I'm getting the following errors when trying to install:

JInstaller: :Install: Can't find XML setup file.
JInstaller: :Install: Error SQL Table '....#__phocagallery_categories' doesn't exist
Extension Update: SQL error processing query: DB function failed with error number 1146
Table '....#__phocagallery_categories' doesn't exist
SQL =

ALTER TABLE `#__phocagallery_categories` ADD COLUMN `image_id` int(11) NOT NULL default 0;

I've installed phoca gallery several times on this particular server without issues before.

Any thoughts as to why I'm having issues now? Using Joomla 3.8.11
I have extracted the files and have tried to install from the tmp folder with the same results.

[Benno]

Hi,
see: https://www.phoca.cz/documents/16-jooml ... ase-column

Kind regards,
Benno

[a2zcs]

Hi Benno,
Thanks. I manually installed all of the tables, what next? PhocaGallery was still not showing in Components so I tried to reinstall phocagallery using extension manager, but now it gives me the following error. I don't get it. I've installed phocagallery many many times with never an issue and there is nothing unique about this particular site so not sure what is going on.

JInstaller: :Install: Can't find XML setup file.
JInstaller: :Install: Error SQL Duplicate column name 'image_id'
Extension Update: SQL error processing query: DB function failed with error number 1060
Duplicate column name 'image_id'
SQL =

ALTER TABLE `#__phocagallery_categories` ADD COLUMN `image_id` int(11) NOT NULL default 0;

[Jan]

Hi,

Duplicate column name 'image_id'

means that the image_id column exists yet, so do you get the same error when using Phoca Gallery now? (not the error in extension manager)

Jan

[a2zcs]

Solved this by uninstalling PhocaMaps and then Phoca Gallery installed with no issues. Reinstalled Phoca Maps afterwards with no issues.

[Jan]

Ok