Database issues on last bench update

Install / Update
8

Hi Nitto,

My problem came from loosing the MySql/MariaDB config file I had. When I restored those settings everything came back to normal.

The settings were:

[mysqld]
innodb-file-format=barracuda
innodb-file-per-table=1
innodb-large-prefix=1
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci

[mysql]
default-character-set = utf8mb4

So you will need to add this to your MariaDB config file in the corresponding sections. After that you might need to restart the database and do bench update again.

On my server this file was located in /etc/mysql/my.cnf

This thread also talks about it:

https://discuss.frappe.io/t/1709-index-column-size-too-large-the-maximum-column-size-is-767-bytes-when-trying-to-restore-automated-backup/6026

I hope this helps. Kind regards from Spain,

Alberto