SQL Error when creating table

When creating a table assigned to a form I get this SQL error.


You have an error in your SQL syntax near 'ENGINE = MYISAM ' at line 1 SQL=CREATE TABLE `jos_chronoforms_1` (`cf_id` INT( 11 ) NOT NULL AUTO_INCREMENT , `recordtime` TEXT NOT NULL , `ipaddress` TEXT NOT NULL ,`name` LONGTEXT NOT NULL , `Address1` LONGTEXT NOT NULL , `Address2` LONGTEXT NOT NULL , `town` LONGTEXT NOT NULL , `pcode` LONGTEXT NOT NULL , `email` LONGTEXT NOT NULL , `phone` LONGTEXT NOT NULL , `hear` LONGTEXT NOT NULL , PRIMARY KEY ( `cf_id` )) ENGINE = MYISAM ;

Hi Andrew,

In the form edit page in V2.3.2 OR in the configuration page for ealier version make the MYSQL type to be "TYPE" instead of "ENGINE".

cheers

Max

Thanks works a treat..