Phoca Forum

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

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

Error
Error installing component

Hi,
Which joomla! version do you use?
Which Phoca Gallery Component version do you try to install?
Which PHP version do you use?
Is it an update or an install of Phoca Gallery?
Have you already tried downloading Phoca Gallery again and installing this version again?

Kind regards,
Benno

Benno,

New Install of Phoca Gallery
Yes, I attempted to install this twice, without success.
https://github.com/PhocaCz/PhocaGallery ... 4.3.18.zip

Fresh New Website (no content yet)

System Information

Setting : Value

PHP Built On : Linux beulah 4.14.67-grsec-grsec+ #4 SMP Thu Sep 6 01:23:09 PDT 2018 x86_64

Database Type : mysql

Database Version : 5.7.25-log
Caching : Disabled

Database Collation : utf8_general_ci

Database Connection Collation : utf8mb4_general_ci

PHP Version : 7.2.11

Web Server : Apache

WebServer to PHP Interface : cgi-fcgi

Joomla! Version : Joomla! 3.9.5 Stable [ Amani ] 9-April-2019 15:00 GMT

Joomla! Platform Version : Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT

Gzip : Disabled

User Agent : Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:66.0) Gecko/20100101 Firefox/66.0

Thank you in advance for your assistance.

Hi, the error message says, that you are updating Phoca Gallery but one table (#__phocagallery_categories) is missing in your database. So seems there are information about Phoca Gallery in your Joomla! but some of the tables are missing.

So no depends on which data you have stored in your Phoca Gallery (if it will be possible to make new install (all data will be lost) or somehow fix the tables in database manually)

Jan

This site is a new site with zero content. This is the first component that I have attempted to install. After the fail, I installed Akeebackup, and it completed without error. After the first attempt failure of Phoca Gallery, I re-attempted the install, unsuccessfully. I will delete the entire site, and databases, etc, and start over. Update coming soon. Thank you.

Ok

Update - Resolved

The Joomla site was initially a 1-click install from DreamHost.com. There must have been something in their one-click installation that caused an issue with installing the Phoca Gallery.

Note this was a new site with ZERO content...

Here's what I did to resolve the issue:

1) Wiped the entire site directory, and deleted all tables

2) Downloaded and installed Joomla from the Joomla repository

3) Performed a fresh install, following the standard Joomla installation

4) Downloaded and installed the Phoca Gallery from the Phoca website

Success!

Zero errors

Ok, great to hear it.

Jan