Phoca Forum

Hello People!

I am getting the following errors installing on joomla 1.6:

Phoca Download not successfully installed:
Función de la base de datos fallida con el número de error 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 32 SQL=CREATE TABLE `jos_phocadownload_categories` ( `id` int(11) NOT NULL auto_increment, `parent_id` int(11) NOT NULL default 0, `section` 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 '', `image_position` varchar(30) NOT NULL default '', `description` text, `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', `uploaduserid` text, `accessuserid` text, `deleteuserid` text, `date` datetime NOT NULL default '0000-00-00 00:00:00', `count` int(11) NOT NULL default '0', `params` text, `hits` int(11) NOT NULL default '0', `metakey` text, `metadesc` text, `metadata` text, `language` char(7) NOT NULL Default '', PRIMARY KEY (`id`), KEY `cat_idx` (`section`, `published`, `access`), KEY `idx_access` (`access`), KEY `idx_checkout` (`checked_out`) ) TYPE=MyISAM CHARACTER SET `utf8` ;
Función de la base de datos fallida con el número de error 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 52 SQL=CREATE TABLE `jos_phocadownload` ( `id` int(11) unsigned NOT NULL auto_increment, `catid` int(11) NOT NULL default '0', `sectionid` int(11) NOT NULL default '0', `owner_id` 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 '', `filesize` int(11) NOT NULL default '0', `filename_play` varchar(250) NOT NULL default '', `filename_preview` varchar(250) NOT NULL default '', `author` varchar(255) NOT NULL default '', `author_email` varchar(255) NOT NULL default '', `author_url` varchar(255) NOT NULL default '', `license` varchar(255) NOT NULL default '', `license_url` varchar(255) NOT NULL default '', `image_filename` varchar(255) NOT NULL default '', `image_filename_spec1` varchar(255) NOT NULL default '', `image_filename_spec2` varchar(255) NOT NULL default '', `image_download` varchar(255) NOT NULL default '', `link_external` varchar(255) NOT NULL default '', `mirror1link` varchar(255) NOT NULL default '', `mirror1title` varchar(255) NOT NULL default '', `mirror1target` varchar(10) NOT NULL default '', `mirror2link` varchar(255) NOT NULL default '', `mirror2title` varchar(255) NOT NULL default '', `mirror2target` varchar(10) NOT NULL default '', `description` text, `version` varchar(255) NOT NULL default '', `directlink` tinyint(1) NOT NULL default '0', `date` datetime NOT NULL default '0000-00-00 00:00:00', `publish_up` datetime NOT NULL default '0000-00-00 00:00:00', `publish_down` datetime NOT NULL default '0000-00-00 00:00:00', `hits` int(11) NOT NULL default '0', `textonly` tinyint(1) NOT NULL default '0', `published` tinyint(1) NOT NULL default '0', `approved` tinyint(3) unsigned 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', `access` tinyint(3) unsigned NOT NULL default '0', `confirm_license` int(11) NOT NULL default '0', `unaccessible_file` int(11) NOT NULL default '0', `params` text, `metakey` text, `metadesc` text, `metadata` text, `language` char(7) NOT NULL Default '', PRIMARY KEY (`id`), KEY `catid` (`catid`, `published`) ) TYPE=MyISAM CHARACTER SET `utf8` ;
Función de la base de datos fallida con el número de error 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 11 SQL=CREATE TABLE `jos_phocadownload_user_stat` ( `id` int(11) NOT NULL auto_increment, `fileid` int(11) NOT NULL default '0', `userid` int(11) NOT NULL default '0', `count` int(11) NOT NULL default '0', `date` datetime NOT NULL default '0000-00-00 00:00:00', `published` tinyint(1) NOT NULL default '0', `ordering` int(11) NOT NULL default '0', `language` char(7) NOT NULL Default '', PRIMARY KEY (`id`) ) TYPE=MyISAM CHARACTER SET `utf8` ;
Función de la base de datos fallida con el número de error 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 12 SQL=CREATE TABLE `jos_phocadownload_licenses` ( `id` int(11) NOT NULL auto_increment, `title` varchar(255) NOT NULL default '', `alias` varchar(255) NOT NULL default '', `description` text, `checked_out` int(11) unsigned NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `published` tinyint(1) NOT NULL default '0', `ordering` int(11) NOT NULL default '0', `language` char(7) NOT NULL Default '', PRIMARY KEY (`id`) ) TYPE=MyISAM CHARACTER SET `utf8` ;

have any idea of what is the problem?

thanks

Hi, seems like you need to change:

FROM:
TYPE=MyISAM
TO:
ENGINE=MyISAM

Get more info in this forum.

Jan