Jump to content

Issue during upgrade from 3.4.7 to 4.0.13


SmackDaddy70

Recommended Posts

Posted

I am getting the following error during the upgrade process -- retry does nothing but does give me a "Continue" but I am afraid if I continue something will go wrong:

 

Specified key was too long; max key length is 1000 bytes 
(EDITED)/forums/applications/core/sources/Setup/Upgrade.php::655

(NOTE: "(EDITED)" above is simply me removing my structure information)

Posted

The only thing I can see on this via google is myISAM versus INNODB types in the DB:

https://confluence.atlassian.com/display/FISHKB/MySQL+Database+Migration+fails+with+Specified+key+was+too+long+max+key+length+is+1000+bytes

There is a known bug with MySQL related to MyISAM, the UTF8 character set and indexes

 

  1. Make sure MySQL is configured with the InnoDB storage engine.
  2. Change the storage engine used by default so that new tables will always be created appropriately:

    set GLOBAL storage_engine='InnoDb';

Can something be done in the middle of an upgrade to "fix" this or can I just click "Continue" and see what happens? 

Archived

This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...