Specified key was too long; max key length is 767 bytes
or
Index column size too large. The maximum column size is 767 bytes:
Those are steps to fix this:
1. In your SSH, as root, run:
Code: Select all
mcedit /etc/mysql/mariadb.cnf
Code: Select all
innodb-file-format=barracuda
innodb-file-per-table=ON
innodb-large-prefix=ON
innodb_default_row_format = 'DYNAMIC'
Code: Select all
systemctl restart mysql
Code: Select all
ALTER TABLE `table_name` ROW_FORMAT=DYNAMIC;