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/

 

How to creat joomla template 3.0 step by step: work with templateDetails.xml

What is templateDetails.xml file

The templateDetails.xml file holds a variety of meta-data used by the Template Manager in installation and maintenance. It is helpful to recognize the different sections of the file. Typically, each section of data is indented to make the file more readable, but this indentation is not necessary.

The templateDetails.xml file is essential. Without it, your template won’t be seen by Joomla!. The file holds key metadata about the template.

The syntax of the file is different for each Joomla version.


Continue reading…