Getting Max Keylength Errors on MariaDB 10.5 When Installing OCMS v4

Need Help
#1

Hi

We just migrated to a new cPanel server. Now when trying to install October CMS 4, I get the error:

==========
In Connection.php line 838:

SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes (Connection: mysql, Host:
localhost, Port: 3306, Database: my_database, SQL: alter table system_files add index system_files_master_index(attachment _type, attachment_id, field))

In Connection.php line 584:

SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes

This is unusual for MariaDB 10.5 and I tried to manually configure the database by setting
‘mysql’ => [
// …
‘varcharmax’ => 191,
],
in config/database.php, but it did not work and I got the same error.

I contacted the server support who told me that the server is running MariaDB 10.5 and is configured with the DYNAMIC row format which supports large indexes and that it is unlikely a server-side issue.

I’m a bit baffled here and some guidance will be appreciated.

#2

The issue is resolved. After asking the server support to try and install October CMS 4 themselves and troubleshoot the process, they eventually got it to work. It seems it was a server-side issue after all.