TIP for broadleaf mysql users
Posted: Mon Feb 27, 2012 5:49 am
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.
I hope this helped.
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.