any ideas on how to fix this?
I'm running php 7.2 on this server with mariadb 10.1
Ubuntu/Debian is using utf8mb4 as default charset for their MariaDB installations. The cause this problem with varchar(255) fields on older MariaDB installations. Newer versions of MariaDB such as the 10.3 series run just fine with varchar(255) on utf8mb4 setups.
To workaround the problem:
Change all varchar(255) fields to varchar(250) in /install/createtable.php. I would also change ENGINE=MyISAM to ENGINE=InnoDB to get the best performance out of your MariaDB server.
