Phoca Forum

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.

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

Kind regards,
Benno

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;

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

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

Ok