![]() No other way of reproducing the error: Error Code: 1071. Since MySql version 5.6 sqlmode is no more empty by default and contains NO_ENGINE_SUBSTITUTION, moreover INNODB is the default engine, so the error is difficult to meet. ![]() To reproduce the tests restart MySql after every change in my.cnf. Unknown table engine 'INNODB'Įxplanation: INNODB is not active but the engine substitution is not permittedīy sql mode therefore the DB returns an error about the attempt of using a disabled engine.Įxplanation: INNODB is active (skip-innodb commented) and it is used also if That returns this error as they key is longer than MYISAM 1000 bytes limit.Ģ fields x 255 char x 3 bytes utf8 encoding + 2 x 1 length byte = 1532 bytesĮrror Code: 1286. Specified key was too long max key length is 1000 bytesĮxplanation: INNODB is not active, the engine is automatically switched to MYISAM Return on execution of your create statement:Įrror Code: 1071. MySql version 5.1.56 community Case 1: Options in my.cnf That is because the working engine is MYISAM, not INNODB. That is not your case, your creation statement include an index that is beyond the 1000 bytes limit of MYISAM, then the creation fails with error 1071 reporting the error of MYISAM.
0 Comments
Leave a Reply. |