SVN Releases > Issues & Bugs

MYSQL 8 reserved table name SYSTEM conflict

(1/1)

tropic81:
Not sure if this has been addressed or not but it appears there is a conflict with the use of table name SYSTEM  "SYSTEM (R); added in 8.0.3 (reserved)". I think this is why I'm getting a "Error creating database schema" during a new install?

DB Schema:  NOT OK(Error creating database schema: [1064] 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 (name, value) VALUES ('roundcube-version', '2016112200')' at line 1 (SQL Query: INSERT INTO system (name, value) VALUES ('roundcube-version', '2016112200')))

Thoughts?

alec:
Just fixed here https://github.com/roundcube/roundcubemail/commit/72a3fb764b3962fc5d96b8e6c6299e311eed03e9#diff-cba810499e8c041b6c13e80f385a2664, thanks.

tropic81:
Thank you.

mhuether:
Unfortunately, this error still exists in the actual kolab/calendar plugin:

REPLACE INTO system (name, value) VALUES ('calendar-database-version', '2015022700');
REPLACE INTO system (name, value) VALUES ('calendar-kolab-version', '2014041700');

Navigation

[0] Message Index