Mariadb error 1071: Specified key was too long; max key length is 1000 bytes
Use ENGINE=InnoDB, not MyISAM.  Your attempts at changing settings were useless because you are not using InnoDB for the table in question.
That can be specified as the default in my.cnf before creating tables.  Else do it explicitly on CREATE TABLE.
Also, don't blindly use 255, instead use sensible limits.