Aug 27th, 2013, 7:20 AM
I am running 2.0.4 and have 3 forms in the system working just fine.
I tried to add a new form and it got hung up in the final Field Types step.
It can't set up the field types. If I hit Skip and try to hit Next Step I get a DB error.
Thanks for any clues.
L.
Error:
Failed query in ft_finalize_form, /home/xxxxxxxxx/www/www/formtools/global/code/forms.php, line 237:
CREATE TABLE ft_form_5 (
submission_id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT,
PRIMARY KEY(submission_id),
col_1 VARCHAR(255),
col_2 VARCHAR(255),
col_3 VARCHAR(255),
col_4 VARCHAR(255),
col_5 VARCHAR(255),
col_6 VARCHAR(255),
col_7 VARCHAR(255),
col_8 VARCHAR(255),
col_9 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 17
I tried to add a new form and it got hung up in the final Field Types step.
It can't set up the field types. If I hit Skip and try to hit Next Step I get a DB error.
Thanks for any clues.
L.
Error:
Failed query in ft_finalize_form, /home/xxxxxxxxx/www/www/formtools/global/code/forms.php, line 237:
CREATE TABLE ft_form_5 (
submission_id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT,
PRIMARY KEY(submission_id),
col_1 VARCHAR(255),
col_2 VARCHAR(255),
col_3 VARCHAR(255),
col_4 VARCHAR(255),
col_5 VARCHAR(255),
col_6 VARCHAR(255),
col_7 VARCHAR(255),
col_8 VARCHAR(255),
col_9 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 17