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