Error installing component

Phoca Gallery - image gallery extension
dougabc123
Phoca Member
Phoca Member
Posts: 12
Joined: 10 Apr 2009, 03:38

Error installing component

Post by dougabc123 »

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

Tags:
User avatar
Benno
Phoca Hero
Phoca Hero
Posts: 9095
Joined: 04 Dec 2008, 11:58
Location: Germany
Contact:

Re: Error installing component

Post by Benno »

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
dougabc123
Phoca Member
Phoca Member
Posts: 12
Joined: 10 Apr 2009, 03:38

Re: Error installing component

Post by dougabc123 »

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.
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 47810
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Error installing component

Post by Jan »

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) :idea:

Jan
If you find Phoca extensions useful, please support the project
dougabc123
Phoca Member
Phoca Member
Posts: 12
Joined: 10 Apr 2009, 03:38

Re: Error installing component

Post by dougabc123 »

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.
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 47810
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Error installing component

Post by Jan »

Ok
If you find Phoca extensions useful, please support the project
dougabc123
Phoca Member
Phoca Member
Posts: 12
Joined: 10 Apr 2009, 03:38

Re: Error installing component

Post by dougabc123 »

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
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 47810
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Error installing component

Post by Jan »

Ok, great to hear it.

Jan
If you find Phoca extensions useful, please support the project
Post Reply