+- Form Tools (https://forums.formtools.org)
+-- Forum: Form Tools (https://forums.formtools.org/forumdisplay.php?fid=1)
+--- Forum: General Discussion (https://forums.formtools.org/forumdisplay.php?fid=5)
+--- Thread: An error in your SQL syntax (/showthread.php?tid=2477)
An error in your SQL syntax - conradcliff - Jul 1st, 2013
Hello there, first I'd like to say that I'm so thankful for FormTools, it's been great!
I've been running a html form for a long time with FT and I just recently duplicated the form and changed it a bit for a slightly different purpose...still very similar.
When I try to add it to FT I get the following error:
Code:
Error:
Failed query in ft_finalize_form, /home/sspbooth/public_html/formtools/global/code/forms.php, line 238:
CREATE TABLE ft_form_3 (
submission_id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT,
PRIMARY KEY(submission_id),
col_1 VARCHAR(20),
col_2 VARCHAR(20),
col_3 VARCHAR(20),
col_4 VARCHAR(20),
col_5 VARCHAR(20),
col_6 VARCHAR(20),
col_7 VARCHAR(20),
col_8 VARCHAR(20),
col_9 VARCHAR(20),
col_10 VARCHAR(20),
col_11 VARCHAR(20),
col_12 VARCHAR(20),
col_13 VARCHAR(20),
col_14 VARCHAR(20),
col_15 VARCHAR(20),
col_16 VARCHAR(20),
col_17 VARCHAR(20),
col_18 VARCHAR(20),
col_19 VARCHAR(20),
col_20 VARCHAR(20),
col_21 VARCHAR(20),
col_22 VARCHAR(20),
col_23 VARCHAR(20),
col_24 VARCHAR(20),
col_25 VARCHAR(20),
col_26 VARCHAR(20),
col_27 VARCHAR(20),
col_28 VARCHAR(20),
col_29 VARCHAR(20),
col_30 VARCHAR(20),
col_31 VARCHAR(20),
col_32 VARCHAR(20),
col_33 VARCHAR(20),
col_34 VARCHAR(20),
col_35 VARCHAR(20),
col_36 VARCHAR(20),
col_37 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=InnoDB 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=InnoDB DEFAULT CHARSET=utf8' at line 45I have no idea what it's talking about
