Hi,
I just bought Jredirect and after installing I encounter this problem:
JInstaller: :Installeren: Fout SQL Index column size too large. The maximum column size is 767 bytes.
Extensie Installeren: SQL fout verwerken zoekopdracht: DB functie is mislukt met het volgende foutnummer 1709
Index column size too large. The maximum column size is 767 bytes.
SQL =
CREATE TABLE IF NOT EXISTS `#__jredirects_links` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`alias` VARCHAR( 255 ) NOT NULL,
`language` char(7) NOT NULL,
`link` VARCHAR( 1024 ) NOT NULL,
`params` TEXT NOT NULL,
`evaluate_params` tinyint(1) NOT NULL default '1',
`menu_active` tinyint(1) NOT NULL default '1',
`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 '1',
PRIMARY KEY (`id`),
UNIQUE `alias_identifier` (`alias`, `language`),
INDEX `link` (`link`)
) ENGINE=InnoDB CHARACTER SET `utf8`;
Thanks for your help, Nanneke
|