Roundcube Community Forum

SVN Releases => Issues & Bugs => Topic started by: tropic81 on August 25, 2018, 12:13:03 PM

Title: MYSQL 8 reserved table name SYSTEM conflict
Post by: tropic81 on August 25, 2018, 12:13:03 PM

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?

Title: Re: MYSQL 8 reserved table name SYSTEM conflict
Post by: alec on August 25, 2018, 12:29:41 PM

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

Title: Re: MYSQL 8 reserved table name SYSTEM conflict
Post by: tropic81 on August 25, 2018, 12:53:16 PM

Thank you.

Title: Re: MYSQL 8 reserved table name SYSTEM conflict
Post by: mhuether on March 31, 2023, 01:24:15 PM

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