DO NOT PM me with questions regarding functionality of HCL!

PLEASE post your query in the relevant forum so others with the same issue can find the answer.  You WILL get a reply!

Thanks for reading.

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 '',`message` text NOT NULL,PRIMARY KEY (`id`)) TYPE=MyISAM' at line 1

CREATE TABLE `hcl2_canned` (`id` int(255) NOT NULL auto_increment,`departmentid` int(255) NOT NULL default '0',`operatorid` int(255) NOT NULL default '0',`subject` varchar(255) NOT NULL default ',`message` text NOT NULL,PRIMARY KEY (`id`)) TYPE=MyISAM;