Hi Team, Updating to .10.38.3. Causes Error
Dear froxlor-team,
the following error has been reported by a user:
-------------------------------------------------------------
42000 SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes
File: lib/Froxlor/Database/Database.php:597
Trace:
#0 [internal function]: PDO->query('CREATE TABLE `p...')
#1 lib/Froxlor/Database/Database.php(597): call_user_func_array(Array, Array)
#2 install/updates/froxlor/update_2.x.inc.php(6
No, it installed the current latest version which is 2.0.13
Debian 9 is pretty old as well as your mariadb server.
You might want to try the following mysql-server options:
#t uf8mb4 long key index
innodb_large_prefix = 1
innodb_file_format = barracuda
Innodb_file_format_max = barracuda
innodb_file_per_table = 1