Update from 1.4.11 to 1.5.2 mariaDB issue

[jloc0]

Hello,

During my update of roundcube today I came across this error. I'm looking for guidance for how to proceed to correctly update the database. I'm using mariadb 10.0.26 on a slackware 14.2 system. Also pardon my ignorance of sql, roundcube is the only software I use that uses it, and I'm stumped at what UPGRADING is telling me to do.

Code: [Select]

WARNING: If you use MySQL < 5.7.7 or MariaDB < 10.2.2 make sure to configure it with:
            innodb_large_prefix=1
            innodb_file_per_table=1
            innodb_file_format=Barracuda
What am I to give these options to? mariadb? roundcube?

Roundcube upgrade is fine, the db upgrade fails with this error (I assume because of the above unset options):

Code: [Select]

Updating database schema (2020020100)... [OK]
ERROR: Error in DDL upgrade 2020020101: [1071] Specified key was too long; max key length is 767 bytes
Updating database schema (2020020101)... [FAILED]
All done.
Thank you for any advice in advance!

EDIT: OK so I added the innodb options to /etc/my.cnf and restarted mysql, and ran the installer again (afterwards I found out I shouldn't do that), now the installer says this:

Code: [Select]

ERROR: Error in DDL upgrade 2020020101: [1091] Can't DROP 'user_id_fk_cache'; check that column/key exists
Updating database schema (2020020101)... [FAILED]
Also, when logging into the roundcube mysql db, I get this error before it kicks me out to the bash prompt again:

Code: [Select]

mysql: unknown variable 'innodb_large_prefix=1'
So now I'm stumped even more. I'm not sure what the db function is (address book?), is it possible to remove the db and start a new one? ELI5?