#9 Setup.php error when creating table "queries"
Apparently, a column may not be named "sql" initially. When changed to something like "sqlz", it works. Changing it back to "sql" also works.
Failed to create table queries using SQl string:
CREATE TABLE queries ( name varchar(25) NOT NULL default '', mode set('work_order','hot_job','equipment') NOT NULL default '', caption varchar(25) NOT NULL default '', title varchar(50) NOT NULL default '', groups text NOT NULL, sql text NOT NULL, col_attributes text, PRIMARY KEY (name), FULLTEXT KEY col_attributes (col_attributes), FULLTEXT KEY col_attributes_2 (col_attributes) ) TYPE=MyISAM COMMENT='SQL query store';
MySQL reported the following error:
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 'sql text NOT NULL, col_attributes text, PRIMARY KEY (name), FULLTEXT K' at line 7
