When i want install the phocadownload RC2 i have this error "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` ;"
And this for all table.
I tried to change TYPE=MyISAM CHARACTER to ENGINE=MyISAM CHARACTER and paste the query directely in myadmin, but always the same error ...
I need help
