Jun 17th, 2015, 7:30 AM
I get through the entire form creator and I get to the optional "Field Types" section and I cannot move past it. When I skip the step or do Smart Fill and then hit Next Step, I receive this error:
Failed query in ft_finalize_form, G:\PleskVhosts\schoolsthatlead.org\httpdocs\formtools\global\code\forms.php, line 237:
CREATE TABLE form_4 (
submission_id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT,
PRIMARY KEY(submission_id),
col_1 VARCHAR(255),
col_2 VARCHAR(255),
col_3 VARCHAR(255),
submission_date DATETIME NOT NULL,
last_modified_date DATETIME NOT NULL,
ip_address VARCHAR(15),
is_finalized ENUM('yes','no') default 'yes')
TYPE=MyISAM DEFAULT CHARSET=utf8
Debug:
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 'TYPE=MyISAM DEFAULT CHARSET=utf8' at line 11
Failed query in ft_finalize_form, G:\PleskVhosts\schoolsthatlead.org\httpdocs\formtools\global\code\forms.php, line 237:
CREATE TABLE form_4 (
submission_id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT,
PRIMARY KEY(submission_id),
col_1 VARCHAR(255),
col_2 VARCHAR(255),
col_3 VARCHAR(255),
submission_date DATETIME NOT NULL,
last_modified_date DATETIME NOT NULL,
ip_address VARCHAR(15),
is_finalized ENUM('yes','no') default 'yes')
TYPE=MyISAM DEFAULT CHARSET=utf8
Debug:
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 'TYPE=MyISAM DEFAULT CHARSET=utf8' at line 11