People «
Phil Welch - philmorew
MySQL CREATE TABLE values fails because "values" is a reserved MySQL word.
Started by Phil Welch, edited by Christian Loubechine on Mar. 11 2009
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
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
Phil, this is a late answer, but actually your issue is probably due to the absence of table prefix. By default, this is 'yacs_', meaning the table name is 'yacs_values', which is not a reserved keyword by MySQL. I think you have set an empty prefix, therefore the issue. My recommendation to you would be to use some table prefix. If 'yacs_' does not suit you, please select another prefix.
By Bernard Paques on Feb. 23 2009
Business cardPhil Welch
Websites made with Yacs
