Page 1 of 1

Phoca Gallery Installation Errors

Posted: 21 Aug 2018, 22:57
by 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.

Re: Phoca Gallery Installation Errors

Posted: 22 Aug 2018, 13:02
by Benno

Re: Phoca Gallery Installation Errors

Posted: 22 Aug 2018, 21:01
by 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;

Re: Phoca Gallery Installation Errors

Posted: 27 Aug 2018, 14:57
by 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

Re: Phoca Gallery Installation Errors

Posted: 30 Aug 2018, 04:46
by a2zcs
Solved this by uninstalling PhocaMaps and then Phoca Gallery installed with no issues. Reinstalled Phoca Maps afterwards with no issues.

Re: Phoca Gallery Installation Errors

Posted: 02 Sep 2018, 01:08
by Jan
Ok