Everything Your Business Needs For Profitable Pay-Per-Click Marketing San Diego PPC San Diego Pay Per Click Network is the leader in Google AdWords campaigns including Remarketing

How to fix Error 1146 phocagallery_styles’ doesn’t exist SQL=SELECT When Upgrading to Phoca Gallery 4.x.x with Joomla 3.x.x

When you are upgrade Joomla from version 2.5.x to joomla 3.x.x lastest version also to Upgrade Phoca Gallery to version 4.x.x lastest version you got error 1146 Trying display a gallery gives the following error.

1146 – Table ‘#__phocagallery_styles’ doesn’t exist SQL=SELECT a.filename as filename, a.type as type, a.menulink as menulink FROM odu0o_phocagallery_styles AS a WHERE a.published = 1 ORDER BY a.type, a.ordering ASC

What happen, how to fix it?

In this case in your database missing the table called: #__phocagallery_styles, and must to add it manually:

1. To download lastest Phoca Gallery to your local, and Unzip it.

2. Open file installation ZIP: install/sql/mysql/install.utf8.sql with your editor like Notepade ++

3. Search and copy table #__phocagallery_styles Line 184 to 200 (remmeber not the same for all Phoca Gallery version)

example for Phoca Gallery version 4.1.2

 

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, ‘*’);

4. Open your PhpMyadmin in your hosting Coltrol Panel

and Rememeber to Replace #__phocagallery_styles with Your Joomla Prefix

5. Add to SQL and click Go to run,

 

Check your Home page

have goodluck, have any problem pls contact us http://joomquery.com/contact-us/