Author Topic: Update from 1.4.11 to 1.5.2 mariaDB issue  (Read 205 times)

Offline jloc0

  • Newbie
  • *
  • Posts: 1
Update from 1.4.11 to 1.5.2 mariaDB issue
« on: January 04, 2022, 09:28:49 AM »
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?
« Last Edit: January 04, 2022, 10:37:28 AM by jloc0 »