An exception occurred while executing 'ALTER TABLE `flow_doctrine_migrationstatus

While updating to neos 4.0 I am running into this error message:

./flow database:setcharset

An exception occurred while executing ‘ALTER TABLE flow_doctrine_migrationstatus CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci’:

Specified key was too long; max key length is 767 bytes
[ERROR] The transaction was rolled back.
Database charset/collation was converted.

Any idea how to fix that?

I assume you use MySQL/MariaDB?
You should probably use a more recent version then. MariaDB has to be 10.2 at least and you can check the requirements in the Neos documentation.

1 Like

Thanks David for your fast answer!

Yes after upgrading to new Ubuntu 18 with Maria DB 10.2 this works without any problems.

Thanks again! :wink:

1 Like