Roundcube Community Forum

 

MYSQL 8 reserved table name SYSTEM conflict

Started by tropic81, August 25, 2018, 12:13:03 PM

Previous topic - Next topic

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?



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');