Error while installing IMC

[ISoliman]

HI,

I'm new to IMC and this is the 1st time to install it, I have installed MySQL 5.5.21 and now trying to install IMC but keeps getting the below error:

ERROR 1071 (42000) at line 389: Specified key was too long; max key length is 767 bytes

Note sure what is the cause of this and how to solve it, I'm not a database guy so not sure what to do :)

[Inge_Quarg]

Please check with the installation guide for MysQL your MySQL configuration. If you have done all correctly, than it must work. Check especially your root password. Use for the configuration this way:

　

Start > All Programs > MySQL 5.5 > MySQL Server Instance Configuration Wizard

Hope this help, Regards,

Inge

[ISoliman]

The MySQL version i'm using is the new one which has different steps but I have done the same as mentioned in the document from the beginning and showing the mentioned error.

[jguse]

Hi Islam!

Good to see you around again, hope you've been doing well :-)

Can't say I'm a database expert, but this looks like a MySQL issue, and the allowed key length seems to depend on the engine you're using. Perhaps the following articles can help you out:

http://stackoverflow.com/questions/3489041/mysqlerror-specified-key-was-too-long-max-key-length-is-1000-bytes

http://www.ispirer.com/wiki/sqlways/troubleshooting-guide/mysql/import/key-too-long

http://drupal.org/node/554820

http://bugs.mysql.com/bug.php?id=6604

[ISoliman]

Hi Justin,

Good To see you again :) hopo you are doing well and no angry customers :P

Nice catch ;) I know this is a database issue I searched for the error and I did change the engine but got a new error lol :D so I though I might find someone who faced this before and can help in an easy way, will try to install it in another system and check, and if same error will try to use the same MySQL version mentioned in the guide and check maybe it will help.

Thanks a lot Justin :) (Nice to see the team working hard ;) )

Hope to see you as L2 soon :)