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
[email protected]
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs