Phoca Gallery Install Problem (SQL?!?)

Phoca Gallery - image gallery extension
Peet82
Phoca Member
Phoca Member
Posts: 10
Joined: 20 Jun 2008, 11:17

Phoca Gallery Install Problem (SQL?!?)

Post by 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. :x

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

Thank You!

Greetings,

Peter
Last edited by Peet82 on 20 Jun 2008, 14:41, edited 1 time in total.
Peet82
Phoca Member
Phoca Member
Posts: 10
Joined: 20 Jun 2008, 11:17

Re: Phoca Gallery Install Problem (SQL?!?)

Post by Peet82 »

I have tried to enter the SQL data manualy too, but I recieve the error too.
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 48403
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Phoca Gallery Install Problem (SQL?!?)

Post by Jan »

maybe your sql version is obsolete, did you try to install the sql query from install.bak file e.g. in phpMyAdmin?
If you find Phoca extensions useful, please support the project
Peet82
Phoca Member
Phoca Member
Posts: 10
Joined: 20 Jun 2008, 11:17

Re: Phoca Gallery Install Problem (SQL?!?)

Post by 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
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 48403
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Phoca Gallery Install Problem (SQL?!?)

Post by Jan »

so try to remove the command with setting the character
If you find Phoca extensions useful, please support the project
Peet82
Phoca Member
Phoca Member
Posts: 10
Joined: 20 Jun 2008, 11:17

Re: Phoca Gallery Install Problem (SQL?!?)

Post by 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!
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 48403
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Phoca Gallery Install Problem (SQL?!?)

Post by 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
If you find Phoca extensions useful, please support the project
Peet82
Phoca Member
Phoca Member
Posts: 10
Joined: 20 Jun 2008, 11:17

Re: Phoca Gallery Install Problem (SQL?!?)

Post by Peet82 »

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
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 48403
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Phoca Gallery Install Problem (SQL?!?)

Post by 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
If you find Phoca extensions useful, please support the project
Post Reply