Page 1 of 1

TIP for broadleaf mysql users

Posted: Mon Feb 27, 2012 5:49 am
by karim.hj
If you encounter this error "Specified key was too long; max key length is 1000 bytes" when creating an index.
See http://bugs.mysql.com/bug.php?id=4541

You may run an UTF-8 database without innodb engine.

Change your database engine to innodb, by example by running mysql with innoDB for default engine.

Code: Select all

 mysqld.exe --default-storage-engine=InnoDB


I hope this helped.

Re: TIP for broadleaf mysql users

Posted: Mon Feb 27, 2012 10:09 pm
by bpolster
Karim.hj,

Was this encountered with an out of box BLC entity? If so, let us know which one. Most of the out-of-box keys are longs or relatively small values which shouldn't be a problem in UTF-8.

Thanks,