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.