BN_IT_Support Posted August 5, 2016 Share Posted August 5, 2016 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 Link to comment Share on other sites More sharing options...
The Old Man Posted August 6, 2016 Share Posted August 6, 2016 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. Link to comment Share on other sites More sharing options...
BN_IT_Support Posted August 6, 2016 Author Share Posted August 6, 2016 Thanks @The Old Man. I'll have read through and see what I can do. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.