MySQL CREATE TABLE values fails because "values" is a reserved MySQL word.
The table 'versions' has been created (utf8) and analyzed and optimized
ERROR for the table values
CREATE TABLE values ( `id` VARCHAR(255) DEFAULT '' NOT NULL, `value` MEDIUMTEXT NOT NULL, `edit_date` DATETIME, PRIMARY KEY (id), INDEX edit_date (edit_date) ) TYPE=MyISAM
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 'values ( `id` VARCHAR(255) DEFAULT '' NOT NULL, `value` MEDIUMTEXT NOT NULL, `ed' at line 1
The table 'cache' has been created (utf8) and analyzed and optimized
Progress | ![]() |
Workflow | Support request |
Status | Problem has been recorded |
Apparently Date was a similar MySQL installation error previously. Will there be a fix for this or should I noodle through the code and rename references to the values table? "values" is used quite a few times when referencing things other than the values table, so a global replace is not an option.