Daily Shaarli

Nextcloud update failed

Doctrine\DBAL\Exception\DriverException: An exception occurred while executing 'ALTER TABLE oc_authtoken CHANGE `password_invalid` password_invalid TINYINT(1) DEFAULT '0'':                                                                                                                                                                                            SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes         Update failed

do

SET GLOBAL innodb_large_prefix = ON;
SET GLOBAL innodb_file_format = Barracuda;
SET GLOBAL innodb_file_per_table = ON;