Public bug reported: Upgrading Ubuntu 18.04 to 20.04 gives the following roundcube error:
mysql said: ERROR 1064 (42000) at line 15: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'system SET value='2018021600' WHERE name='roundcube-version'' at line 1 This seems to come from 'usr/share/dbconfig- common/data/roundcube/upgrade/mysql/1.4.1-1' from 'roundcube- core_1.4.3+dfsg.1-1_all.deb' System is a reserved keyword and needs to be surrounded with backticks. This applies to many of the migrations. ** Affects: roundcube (Ubuntu) Importance: Undecided Status: New -- You received this bug notification because you are a member of Ubuntu Bugs, which is subscribed to Ubuntu. https://bugs.launchpad.net/bugs/1970428 Title: Roundcube dbconfig error: system SET value='2018021600' WHERE name='roundcube-version'' at line 1 To manage notifications about this bug go to: https://bugs.launchpad.net/ubuntu/+source/roundcube/+bug/1970428/+subscriptions -- ubuntu-bugs mailing list ubuntu-bugs@lists.ubuntu.com https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs