J!Extensions Store™
Forum
Welcome, Guest
Please Login to access forum.
Error SQL Index column size too large. (1 viewing) 
Go to bottom
TOPIC: Error SQL Index column size too large.
#7226
BungeWerk Webdesign
Fresh Boarder
Posts: 4
User Offline
Error SQL Index column size too large. Karma: 0  
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
 
Logged Logged  
  The administrator has disabled public write access.
      Topics Author
    thread link
Error SQL Index column size too large.
BungeWerk Webdesign
    thread link
thread linkthread link Re:Error SQL Index column size too large.
BungeWerk Webdesign
    thread link
thread linkthread linkthread link Re:Error SQL Index column size too large.
John Dagelmore
    thread link
thread linkthread linkthread linkthread link Re:Error SQL Index column size too large.
John Dagelmore
    thread link
thread linkthread linkthread linkthread linkthread link Re:Error SQL Index column size too large.
BungeWerk Webdesign
    thread link
thread linkthread linkthread linkthread linkthread linkthread link Re:Error SQL Index column size too large.
BungeWerk Webdesign
Go to top