Phoca Font not installing (error message)

[EvanJ]

Hello,
I am using Joomla 1.5, and whenever I try to install PhocaFont I get this error message:

Code: Select all

Phoca Font was not successfully installed:
DB function failed with error number 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyISAM CHARACTER SET `utf8`' at line 28 SQL=CREATE TABLE IF NOT EXISTS `jos_phocafont_font` ( `id` int(11) NOT NULL auto_increment, `catid` int(11) NOT NULL default 0, `title` varchar(255) NOT NULL default '', `alias` varchar(255) NOT NULL default '', `xmlfile` varchar(70) NOT NULL default '', `regular` varchar(70) NOT NULL default '', `bold` varchar(70) NOT NULL default '', `italic` varchar(70) NOT NULL default '', `bolditalic` varchar(70) NOT NULL default '', `condensed` varchar(70) NOT NULL default '', `condensedbold` varchar(70) NOT NULL default '', `condenseditalic` varchar(70) NOT NULL default '', `condensedbolditalic` varchar(70) NOT NULL default '', `alternative` varchar(255) NOT NULL default '', `format` varchar(30) NOT NULL default '', `published` tinyint(1) NOT NULL default '0', `defaultfont` 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', `access` tinyint(3) unsigned NOT NULL default '0', `params` text NOT NULL, PRIMARY KEY (`id`), KEY `cat_idx` (`published`,`access`), KEY `idx_access` (`access`), KEY `idx_checkout` (`checked_out`) ) TYPE=MyISAM CHARACTER SET `utf8`;

Anyone know how to fix this>

Thanks!
Evan

[Jan]

Hi, which Phoca Font version you are using?