I'm trying to convert my db tables to Innodb and three of them:

• ibf_cms_databases
• ibf_core_search_index
• ibf_nexus_licensekeys

are returning:

Specified key was too long; max key length is 767 bytes

Does anyone know what this means and more importantly how to fix it please?

Thanks

Hi,

Not sure how you are doing it but try this method to convert, worked fine for me without that issue occurring. Take a backup first!

Apparently it's caused by working on too large a set of data, I've read you can break it down into smaller subsets to do it in stages.

http://stackoverflow.com/questions/1814532/1071-specified-key-was-too-long-max-key-length-is-767-bytes

I'm no expert but hope this helps.

 

Thanks @The Old Man. I'll have read through and see what I can do.