J!Extensions Store™
Forum
Welcome, Guest
Please Login to access forum.
Re:Error SQL Index column size too large. (1 viewing) 
Go to bottom
TOPIC: Re:Error SQL Index column size too large.
#7226
BungeWerk Webdesign
Fresh Boarder
Posts: 4
User Offline
Error SQL Index column size too large. 3 Years ago 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.
#7227
BungeWerk Webdesign
Fresh Boarder
Posts: 4
User Offline
Re:Error SQL Index column size too large. 3 Years ago Karma: 0  
Joomla 3.7.2
Jredirects 1.2.5
 
Logged Logged  
  The administrator has disabled public write access.
#7228
John Dagelmore
Admin
Posts: 3551
User Offline
Re:Error SQL Index column size too large. 3 Years ago Karma: 75  
Hi,

that's because your database doesn't support long keys.
I just sent you by email a package installing as required by your database.

Regards
 
Logged Logged  
 
Last Edit: 2017/05/24 13:53 By @store$eco#mm!.
  The administrator has disabled public write access.
#7230
John Dagelmore
Admin
Posts: 3551
User Offline
Re:Error SQL Index column size too large. 3 Years ago Karma: 75  
Email didn't work, i attach the package here.
 
Logged Logged  
 
Last Edit: 2017/05/24 14:19 By @store$eco#mm!.
  The administrator has disabled public write access.
#7235
BungeWerk Webdesign
Fresh Boarder
Posts: 4
User Offline
Re:Error SQL Index column size too large. 3 Years ago Karma: 0  
Where can I find it? I don't see it?
Can I send you a mail, which you can reply?
 
Logged Logged  
  The administrator has disabled public write access.
#7237
BungeWerk Webdesign
Fresh Boarder
Posts: 4
User Offline
Re:Error SQL Index column size too large. 3 Years ago Karma: 0  
thanks! It works.
 
Logged Logged  
  The administrator has disabled public write access.
Go to top