HCL V2. 2. 7
Error occurs in firefox and IE
PHP 5. 2. 8
MySQL v 5. 0. 67-community
Apache 2. 0. 63

I get the following When I submit step 4 of the installation:


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 `hcl_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;