Phoca Forum

Posted: **06 Jul 2015, 19:54**

Hello, I was given a Joomla website to edit , and I noticed that image gallery was a bit broken, and styles are missing in Control Panel. Also descriptions don't show under the images. I could add my own styles to line up the images 3 per row, but descriptions don't show up, only titles and images.

I also see that error in Styles tab : Table "rawlins_33upgrade.klg7v_phocadownload_styles" doesn't exists SQL=Select etc.

What can I do to recover this component and display descriptions under the images?
It's really urgent, the client thinks I modified and broke it, but I didn't touch anything. I guess the options don't work because of this missing table.

Thank you!

Posted: **07 Jul 2015, 22:33**

Hi, the missing table must be added manually, see the SQL queries in administrator\components\com_phocadownload\install\sql\mysql\install.utf8.sql

Code: Select all

CREATE TABLE IF NOT EXISTS `#__phocadownload_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 `#__phocadownload_styles` (`id`, `title`, `alias`, `filename`, `menulink`, `type`, `published`, `checked_out`, `checked_out_time`, `ordering`, `params`, `language`) VALUES
(1, 'Phocadownload', 'phocadownload', 'phocadownload.css', NULL, 1, 1, 0, '0000-00-00 00:00:00', 1, NULL, '*'),
(2, 'Rating', 'rating', 'rating.css', NULL, 1, 1, 0, '0000-00-00 00:00:00', 2, NULL, '*'),
(3, 'Button', 'button', 'button.css', NULL, 1, 0, 0, '0000-00-00 00:00:00', 3, NULL, '*'),
(4, 'Button (Rounded Corners)', '', 'buttonrc.css', NULL, 1, 0, 0, '0000-00-00 00:00:00', 4, NULL, '*'),
(5, 'Default', 'default', 'default.css', NULL, 2, 1, 0, '0000-00-00 00:00:00', 1, NULL, '*'),
(6, 'Bootstrap', '', 'bootstrap.min.css', NULL, 1, 0, 0, '0000-00-00 00:00:00', 5, NULL, '*');

Change #__ to your prefix.

Jan

Posted: **20 Nov 2015, 21:02**

I have the same problem but how do I ad the missing table manually via PHPmyadmin?

Posted: **20 Nov 2015, 22:24**

@lindenburg
see:

Note, you need to replace this '#_' prefix to yours before!!!

Kind regards,
Benno

Phoca Forum

Missing styles, no descriptions shown for the images

Missing styles, no descriptions shown for the images

Re: Missing styles, no descriptions shown for the images

Re: Missing styles, no descriptions shown for the images

Re: Missing styles, no descriptions shown for the images