installation error Phoca gallery.

[lui.liguo]

Help me, I can not find a solution.
I upgraded to version 3.3.3 of CMS Joomla, I have also updated the version of Phoca Gallery version 4.1.1 and the installation has succeeded. However, when I access the photo or the page style I encounter the following error:

1146 - Table 'sql583439_2.j25_phocagallery_styles' does not exist SQL = SELECT a.filename as filename, a.type as type, as a.menulink menulink j25_phocagallery_styles FROM AS a WHERE a.published = 1 ORDER BY a.type, a. ordering ASC
What could have happened?
Thank you all.

[Jan]

Hi, the styles table is missing in your database, try to add it manually, in phpMyadmin:

Code: Select all

CREATE TABLE IF NOT EXISTS `#__phocagallery_styles` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL DEFAULT '',
  `alias` varchar(255) NOT NULL DEFAULT '',
  `filename` varchar(255) NOT NULL DEFAULT '',
  `menulink` text,
  `type` tinyint(1) NOT NULL DEFAULT '0',
  `published` tinyint(1) NOT NULL DEFAULT '0',
  `checked_out` int(11) unsigned NOT NULL DEFAULT '0',
  `checked_out_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `ordering` int(11) NOT NULL DEFAULT '0',
  `params` text,
  `language` char(7) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8 ;

INSERT INTO `#__phocagallery_styles` (`id`, `title`, `alias`, `filename`, `menulink`, `type`, `published`, `checked_out`, `checked_out_time`, `ordering`, `params`, `language`) VALUES
(1, 'Phocagallery', 'phocagallery', 'phocagallery.css', '', 1, 1, 0, '0000-00-00 00:00:00', 1, NULL, '*'),
(2, 'Rating', '', 'rating.css', NULL, 1, 1, 0, '0000-00-00 00:00:00', 2, NULL, '*'),
(3, 'Default', '', 'default.css', NULL, 2, 1, 0, '0000-00-00 00:00:00', 3, NULL, '*'),
(4, 'Bootstrap', '', 'bootstrap.min.css', NULL, 1, 0, 0, '0000-00-00 00:00:00', 4, NULL, '*');

Note: prefix should be changes from #__ to your database prefix

Jan

[lui.liguo]

Hello Jan,
Meanwhile, thank you for responding.
I tried to insert your code in PhpMyadmin, but it gave me the error:

1146 - Table 'sql583439_2.j25_phocagallery_styles' does not exist SQL = SELECT a.filename as filename, a.type as type, as a.menulink menulink j25_phocagallery_styles FROM AS a WHERE a.published = 1 ORDER BY a.type, a. ordering ASC

Then I added the following code:

Code: Select all

CREATE TABLE IF NOT EXISTS `j25_phocagallery_styles` (
   id` `int (11) NOT NULL AUTO_INCREMENT,
   title` `varchar (255) NOT NULL DEFAULT '',
   alias` `varchar (255) NOT NULL DEFAULT '',
   filename` `varchar (255) NOT NULL DEFAULT '',
   `menulink` text,
   type` `tinyint (1) NOT NULL DEFAULT '0',
   published` `tinyint (1) NOT NULL DEFAULT '0',
   checked_out` `int (11) unsigned NOT NULL DEFAULT '0',
   checked_out_time` `datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
   ordering` `int (11) NOT NULL DEFAULT '0',
   `params` text,
   language` `char (7) NOT NULL DEFAULT '',
   PRIMARY KEY (`id`)
) DEFAULT CHARSET = utf8;


INSERT INTO `j25_phocagallery_styles` (id``, `title`, alias``, `filename`, menulink``, `type`, published``, `checked_out`, checked_out_time``, `ordering`,` params`, language` `) VALUES
(1, 'phocagallery', 'phocagallery', 'phocagallery.css', '', 1, 1, 0, '0000-00-00 00:00:00', 1, NULL, '*'),
(2, 'Rating', '', 'rating.css', NULL, 1, 1, 0, '0000-00-00 00:00:00', 2, NULL, '*'),
(3, 'Default', '', 'default.css', NULL, 2, 1, 0, '0000-00-00 00:00:00', 3, NULL, '*'),
(4, 'Bootstrap', '', 'bootstrap.min.css', NULL, 1, 0, 0, '0000-00-00 00:00:00', 4, NULL, '*'); 

Now I get the following error:

MySQL message: Documentation
# 1054 - Unknown column 'title' in 'field list'.

Excuse my English, I'm Italian and I use the google translator.
Best regards.

[Jan]

Hi, do you get some exact error message with more information - in which table you get t he problem, etc.

But I see there are some errors:

My code is:

Code: Select all

INSERT INTO `#__phocagallery_styles` (`id`, `title`, `alias`, `filename`, `menulink`, `type`, `published`, `checked_out`, `checked_out_time`, `ordering`, `params`, `language`) ...

Your is:

Code: Select all

INSERT INTO `j25_phocagallery_styles` (id``, `title`, alias``, `filename`, menulink``, `type`, published``, `checked_out`, checked_out_time``, `ordering`,` params`, language` `) ...

which is completely wrong (see the quotes)

Jan

[lui.liguo]

Sorry Jan
I put the prefix J25_ because the tables in my database have that same prefix.
I solved the error, I made mistakes with the copy and paste.
Now I was wondering: can I delete the tables of PhocaDownload that are in my database or do I have to keep them? Because there are tables #__phocagallery and tables #__phocadownload, is it necessary to keep them both?
Thank you very much
Luigi

[Jan]

Hi, depends on if the tables are used or not, if not you can delete them.

[lui.liguo]

I understand,
Thank you very much.
Luigi

[Jan]

Ok

[abstractimagegroup]

I followed all the steps listed. Ran the query, it created the table. There is data in the table and on the back end, all of the documents are there but I am still getting an error "1146 - Table "xxxx_xxxx.xxxxx_phocadownload_styles' doesn't exist SQL=SELECT a.filename as filename, a.type as type, a.menulink as menulink FROM xxxx_phocadownload_styles AS a WHERE a.published = 1 ORDER BY a.type, a.ordering ASC"

I also get the same error when clicking the "Styles" icon from the Phoca Download Control Panel on the backend.

What could I be doing wrong?

[abstractimagegroup]

Please disregard, I ended up uninstalling the component, dropped all the related tables from the DB and did a fresh install. That solved the issue.