+- Form Tools (https://forums.formtools.org)
+-- Forum: Form Tools (https://forums.formtools.org/forumdisplay.php?fid=1)
+--- Forum: API (https://forums.formtools.org/forumdisplay.php?fid=17)
+--- Thread: Stuck Error step 5 > You have an error in your SQL syntax [solved] (/showthread.php?tid=4595)
Stuck Error step 5 > You have an error in your SQL syntax [solved] - ameno - Sep 8th, 2014
I am with godaddy! I would like help please!
Failed query in ft_finalize_form, G:\PleskVhosts\xxxxxxxxxxxxx.info\httpdocs\formtools\global\code\forms.php, line 237:
CREATE TABLE form_1 (
submission_id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT,
PRIMARY KEY(submission_id),
col_1 VARCHAR(255),
col_2 VARCHAR(5),
col_3 VARCHAR(5),
col_4 TEXT,
col_5 VARCHAR(5),
col_6 VARCHAR(5),
col_7 VARCHAR(5),
col_8 TEXT,
col_9 TEXT,
col_10 VARCHAR(255),
col_11 TEXT,
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 19
UPDATED: I updated the forms.php to replace type=MyISAM to > engine=MyISAM
RE: Stuck Error step 5 > You have an error in your SQL syntax [solved] - noelius - Nov 10th, 2016
Thanks for your help! It was really useful!