MySQL Key too long
Problem reported by frank osako - December 26, 2018 at 8:51 AM
Submitted
Clean install and restoring a backup of Smarter Track 14 throwing this error on MySQL 5.6 and 5.7.

Problem: MySql.Data.MySqlClient.MySqlException (0x80004005): Specified key was too long; max key length is 767 bytes

1 Reply

Reply to Thread
0
Andrew Barker Replied
Employee Post
Which specific version of MySql 5.7 were you using? Based on a little research I've done, it appears that this may be a MySql problem that was resolved in 5.7.7 for the InnoDB engine. If you are using 5.7.7 or later with the InnoDB engine, then you may be able to resolve the issue by setting innodb_large_prefix=on and ROW_FORMAT=DYNAMIC.

Andrew Barker
Software Developer
SmarterTools Inc.
(877) 357-6278
www.smartertools.com

Reply to Thread