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 » 05 May 2019, 07:33

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: 7079
Joined: 04 Dec 2008, 11:58
Location: Germany
Contact:

Re: Error installing component

Post by Benno » 05 May 2019, 10:20

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 » 06 May 2019, 06:14

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: 41236
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Error installing component

Post by Jan » 06 May 2019, 15:57

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 » 07 May 2019, 05:45

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: 41236
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Error installing component

Post by Jan » 07 May 2019, 10:55

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 » 11 May 2019, 00:42

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: 41236
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Error installing component

Post by Jan » 11 May 2019, 10:33

Ok, great to hear it.

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

Post Reply