Phoca Forum

My provider is www.webreus.nl
In Joomla 1.5.2NL i installed the module. After installation i push the 'Install' button.
I got the next faillure:

Phoca Gallery was niet succesvol geĂŻnstalleerd:
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 anybody help?
Henk

Your database cannot work with the Phoca Gallery PHP SQL Query (creating of tables)... Try to copy the SQL Query from install.bak file (you find this file in ZIP) and add it e.g. via PHPMyAdmin as SQL query into your database...


Jan

Jan,

I have don what you suggest, but i get a faillure:

Fout
SQL-query:

CREATE TABLE `#__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`
MySQL retourneerde:

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

Henk

So try to remove:

TYPE=MyISAM CHARACTER SET `utf8`

Jan,

I am a fan of yours?
Thank you very much!

Henk

Hi, I've the same problem as above, but after running the MySQL Query with TYPE=MyISAM CHARACTER SET 'utf8' removed it is not possible to create a categorie:

Error Saving Phoca Gallery Categories

Do the Phoca Gallery exist in your database?

It exists, but it has the wrong prefix, changed it to what it should be, now it works.

Thanks for the hint!

Yes the '#__phocagallery...' is ready for automatically installation, so it must replaced by e.g. 'jos_phocagallery...' ... you must add there your own prefix....

Jan