8.4.4 to 8.5.1 upgrade fails: Index column size too large on CollectionVersionBlocksOutputCache
When updating from the dsahboard it fails with:
An exception occurred while executing 'TRUNCATE CollectionVersionBlocksOutputCache': SQLSTATE[HY000]: General error: 1709 Index column size too large. The maximum column size is 767 bytes
This is going to a mariadb database (latest version - 10.4.6). utf8 or utf8mb4 charset.
Any ideas on how to solve? This has scuppered the upgrade... :(
Thankfully this is in a test environment but it means I am not keen on upgrading my live servers!
cd to the directory where concrete5 is installed, and run
./concrete/bin/concrete5 c5:database:charset:set utf8mb4_unicode_ci
to set the utf8mb4 charset, with the utf8mb4_unicode_ci collation
Is there some kind of internal state in concrete5 that this sets?
All my databases are utf8mb4 with the correct collation. I cant remember if the test system this was on was originally created that way but certainly the database and all the database tables are now on this.