Phoca Forum

Hi Everyone!

I tried to install many phoca gallery version, even the latest version.

After I click on the install button, I recieve the following error message:
***
Phoca Gallery was not succesfully installed:
DB function failed with error number 1064
You have an error in your SQL syntax near 'CHARACTER SET `utf8`' at line 18 SQL=CREATE TABLE `jos_phocagallery`( `id` int(11) unsigned NOT NULL auto_increment, `catid` int(11) NOT NULL default '0', `sid` int(11) NOT NULL default '0', `title` varchar(250) NOT NULL default '', `alias` varchar(255) NOT NULL default '', `filename` varchar(250) NOT NULL default '', `description` text NOT NULL default '', `date` datetime NOT NULL default '0000-00-00 00:00:00', `hits` int(11) NOT NULL default '0', `published` tinyint(1) NOT NULL default '0', `checked_out` int(11) 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 NOT NULL, PRIMARY KEY (`id`), KEY `catid` (`catid`,`published`) ) TYPE=MyISAM CHARACTER SET `utf8`;
DB function failed with error number 1064
You have an error in your SQL syntax near 'CHARACTER SET `utf8`' at line 23 SQL=CREATE TABLE `jos_phocagallery_categories` ( `id` int(11) NOT NULL auto_increment, `parent_id` int(11) NOT NULL default 0, `title` varchar(255) NOT NULL default '', `name` varchar(255) NOT NULL default '', `alias` varchar(255) NOT NULL default '', `image` varchar(255) NOT NULL default '', `section` varchar(50) NOT NULL default '', `image_position` varchar(30) NOT NULL default '', `description` text NOT NULL, `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', `editor` varchar(50) default NULL, `ordering` int(11) NOT NULL default '0', `access` tinyint(3) unsigned NOT NULL default '0', `count` int(11) NOT NULL default '0', `params` text NOT NULL, PRIMARY KEY (`id`), KEY `cat_idx` (`section`,`published`,`access`), KEY `idx_access` (`access`), KEY `idx_checkout` (`checked_out`) ) TYPE=MyISAM CHARACTER SET `utf8`;
***

Can you help me about this? I don't have any idea.

I have Joomla 1.5.3. stable UTF-8 with Hungarian language installed.

Thank You!

Greetings,

Peter

I have tried to enter the SQL data manualy too, but I recieve the error too.

maybe your sql version is obsolete, did you try to install the sql query from install.bak file e.g. in phpMyAdmin?

Hi!
Yes, I've tried to enter manualy, and from the install.bak too.

The error walways the same:
#1064 - You have an error in your SQL syntax near 'CHARACTER SET `utf8`' at line 18

SQL version: MySQL 3.23.58-log
myAdmin version: phpMyAdmin 2.6.3-pl1

so try to remove the command with setting the character

Thank You Jan!

It was the easyest way, I deleted the line, and now it is working fine!

I have just only one question about categories, maybe it was subject before,
but I did not find it now.

I selected to show the entire phoca galery from my joomla's main menu.

I have 3 categories, and subcategories (subcats are the albums)... and if I click to see the galery, I see the subcategories too, not just the caregories, like categorie 1 , categorie 1 >> subcat 1, categorie 1 >> subcat 2 , categorie 2....etc...

I like to see only the main picture categories from the "root", and hide the subcategories... is it possible somehow?

You can see it at:
http://sweetydance.hu/index.php?option= ... s&Itemid=4

Thank You!

See parameters:
display subcategories:
https://www.phoca.cz/phocagallery/user-m ... figuration

don't forget to do these changes in Parameters Component:
https://www.phoca.cz/articles/joomla/com ... id-joomla/

Jan

Jan wrote:See parameters:
display subcategories:
https://www.phoca.cz/phocagallery/user-m ... figuration

don't forget to do these changes in Parameters Component:
https://www.phoca.cz/articles/joomla/com ... id-joomla/

Jan

Hi Jan!

Everything fine, thank You for your help and for this very great joomla component too!
This topic is solved I think

Now I am working on a template specialy for our website. If you think I will share it to the public after I finished it.

Do you have a list what XML codes allowed when creating a template? (set boxes width, height from the xml, and all other setting) I want to make a "just one click" full operational template without any manual parameter settings.

You shold check the present state of the template @ http://www.sweetydance.hu/index.php?opt ... s&Itemid=4

I working in png with transparency, and with it, now the "shadow1-2-3" working fine with every backgorund color, no problems.

May I ask... Is there any way to change the X (closing) button's design in the modal box (right side, top corner)? I do not know where to search it.

Thank You!

Peter

Great to hear it. There is an information about Themes:
https://www.phoca.cz/development/

The best way with png is to do them as PNG8(GIF) if they are transparency.

The cross is a part of Joomla framework and you can find it here:
media/system/images/closebox.png

Any new free theme will be appreciated.

Thank you, Jan