Author Topic: MYSQL 8 reserved table name SYSTEM conflict  (Read 22166 times)

Offline tropic81

  • Newbie
  • *
  • Posts: 2
MYSQL 8 reserved table name SYSTEM conflict
« 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?


Offline tropic81

  • Newbie
  • *
  • Posts: 2
Re: MYSQL 8 reserved table name SYSTEM conflict
« Reply #2 on: August 25, 2018, 12:53:16 PM »
Thank you.

Offline mhuether

  • Newbie
  • *
  • Posts: 2
Re: MYSQL 8 reserved table name SYSTEM conflict
« Reply #3 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');