Welcome,
Guest
. Please
login
or
register
.
Did you miss your
activation email
?
1 Hour
1 Day
1 Week
1 Month
Forever
Login with username, password and session length
Home
Help
Search
Login
Register
Roundcube Community Forum
»
SVN Releases
»
Issues & Bugs
»
MYSQL 8 reserved table name SYSTEM conflict
« previous
next »
Print
Pages: [
1
]
Author
Topic: MYSQL 8 reserved table name SYSTEM conflict (Read 24157 times)
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?
Logged
alec
Hero Member
Posts: 1,365
Re: MYSQL 8 reserved table name SYSTEM conflict
«
Reply #1 on:
August 25, 2018, 12:29:41 PM »
Just fixed here
https://github.com/roundcube/roundcubemail/commit/72a3fb764b3962fc5d96b8e6c6299e311eed03e9#diff-cba810499e8c041b6c13e80f385a2664
, thanks.
Logged
tropic81
Newbie
Posts: 2
Re: MYSQL 8 reserved table name SYSTEM conflict
«
Reply #2 on:
August 25, 2018, 12:53:16 PM »
Thank you.
Logged
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');
Logged
Print
Pages: [
1
]
« previous
next »
Roundcube Community Forum
»
SVN Releases
»
Issues & Bugs
»
MYSQL 8 reserved table name SYSTEM conflict