Migration from 7.14.x to 8.7 - 1709 Index column size too large

📦 Install & Upgrade Help
,
1

Hi,

I’m migrating my 7.14.x SuiteCRM instance to 8.7.0. Get through all the steps except the last one, upgrade-finalize. It gives an error on step run-migrations. Here’s the error in prod.log

console.CRITICAL: Error thrown while running command “doctrine:migrations:migrate --no-interaction --allow-no-migration”. Message: “An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1709 Index column size too large. The maximum column size is 767 bytes.”

Any idea what might cause the error? The log is not very explicit about the source.

2

Check the database character set.

Check these MySQL configuration:

SET GLOBAL innodb_large_prefix = ON;
SET GLOBAL innodb_file_format = BARRACUDA;
SET GLOBAL innodb_file_per_table = ON;
3

Looks like my tables are all in MyISAM. It seems that my SuiteCRM is quite old. Could it be the problem?