hagshousehelp@att.net Posted October 31, 2020 Share Posted October 31, 2020 I am trying to upgrade to 4.5.4 and I am getting an error. Specified key was too long; max key length is 1000 bytes I have attached a screenshot of the error I am getting. Any ideas on what I need to do to correct this? Link to comment Share on other sites More sharing options...
Morrigan Posted October 31, 2020 Share Posted October 31, 2020 Reach out to support. Link to comment Share on other sites More sharing options...
AndreasW2000 Posted November 1, 2020 Share Posted November 1, 2020 Had the same problem. Only support could help. And they did 👍 Link to comment Share on other sites More sharing options...
hagshousehelp@att.net Posted November 1, 2020 Author Share Posted November 1, 2020 2 hours ago, AndreasW2000 said: Had the same problem. Only support could help. And they did 👍 Do you know what they did by chance? Link to comment Share on other sites More sharing options...
Ziv Grosu Posted November 1, 2020 Share Posted November 1, 2020 Have a look on this topic: https://stackoverflow.com/questions/8746207/1071-specified-key-was-too-long-max-key-length-is-1000-bytes Link to comment Share on other sites More sharing options...
AndreasW2000 Posted November 1, 2020 Share Posted November 1, 2020 3 hours ago, hagshousehelp@att.net said: Do you know what they did by chance? Sorry, no clue. They did some magic on the database. Link to comment Share on other sites More sharing options...
bfarber Posted November 2, 2020 Share Posted November 2, 2020 Try converting your database to InnoDB from MyISAM would be my longer term suggestion. Link to comment Share on other sites More sharing options...
Recommended Posts