Help Center Live Community

Support => Installation Help & Software Support => Topic started by: gypsydogg on April 09, 2009, 06:51:08 PM



Title: New installation Error
Post by: gypsydogg on April 09, 2009, 06:51:08 PM
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;