Phoca Gallery Install Problem (SQL?!?)

[Peet82]

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

[Peet82]

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

[Jan]

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

[Peet82]

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

[Jan]

so try to remove the command with setting the character

[Peet82]

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!

[Jan]

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

[Peet82]

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

[Jan]

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