No me deja instalar alphacontent, me sale el siguiente error:
JInstaller: :Instalar: Error SQL DB función de error con el numero 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’ at line 11 SQL=CREATE TABLE IF NOT EXISTS `db1eg_alpha_rating` ( `ref` int(11) NOT NULL auto_increment, `id` int(11) NOT NULL default ‘0’, `total_votes` int(11) NOT NULL default ‘0’, `total_value` int(11) NOT NULL default ‘0’, `used_ips` longtext NOT NULL default ”, `component` varchar(30) NOT NULL default ”, `cid` int(11) NOT NULL default ‘0’, `rid` int(11) NOT NULL default ‘0’, PRIMARY KEY (`ref`) ) TYPE=MyISAM;
SQL =
CREATE TABLE IF NOT EXISTS `#__alpha_rating` (
`ref` int(11) NOT NULL auto_increment,
`id` int(11) NOT NULL default ‘0’,
`total_votes` int(11) NOT NULL default ‘0’,
`total_value` int(11) NOT NULL default ‘0’,
`used_ips` longtext NOT NULL default ”,
`component` varchar(30) NOT NULL default ”,
`cid` int(11) NOT NULL default ‘0’,
`rid` int(11) NOT NULL default ‘0’,
PRIMARY KEY (`ref`)
) TYPE=MyISAM;
Instalación de componentes: error en archivo SQL DB función de error con el numero 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’ at line 11 SQL=CREATE TABLE IF NOT EXISTS `db1eg_alpha_rating` ( `ref` int(11) NOT NULL auto_increment, `id` int(11) NOT NULL default ‘0’, `total_votes` int(11) NOT NULL default ‘0’, `total_value` int(11) NOT NULL default ‘0’, `used_ips` longtext NOT NULL default ”, `component` varchar(30) NOT NULL default ”, `cid` int(11) NOT NULL default ‘0’, `rid` int(11) NOT NULL default ‘0’, PRIMARY KEY (`ref`) ) TYPE=MyISAM;
SQL =
CREATE TABLE IF NOT EXISTS `#__alpha_rating` (
`ref` int(11) NOT NULL auto_increment,
`id` int(11) NOT NULL default ‘0’,
`total_votes` int(11) NOT NULL default ‘0’,
`total_value` int(11) NOT NULL default ‘0’,
`used_ips` longtext NOT NULL default ”,
`component` varchar(30) NOT NULL default ”,
`cid` int(11) NOT NULL default ‘0’,
`rid` int(11) NOT NULL default ‘0’,
PRIMARY KEY (`ref`)
) TYPE=MyISAM;
Hay alguna manera de instalar otro tipo de indice A-Z para poder poner una guia de restaurantes?