+- Form Tools (https://forums.formtools.org)
+-- Forum: Modules / Other (https://forums.formtools.org/forumdisplay.php?fid=8)
+--- Forum: Modules (https://forums.formtools.org/forumdisplay.php?fid=16)
+--- Thread: FT1 Data Import Error (/showthread.php?tid=638)
FT1 Data Import Error - jkeisers - Apr 6th, 2010
Hi,
I get the following during the import:
Code:
Error:
Failed query in ft_finalize_form, /var/www/html/foo/ftools/global/code/forms.php, line 238:
CREATE TABLE ft_form_36 (
submission_id MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT,
PRIMARY KEY(submission_id),
VARCHAR(5),
VARCHAR(5),
col_2 MEDIUMTEXT,
col_2 MEDIUMTEXT,
col_3 MEDIUMTEXT,
col_3 MEDIUMTEXT,
col_4 MEDIUMTEXT,
col_4 MEDIUMTEXT,
col_5 MEDIUMTEXT,
col_5 MEDIUMTEXT,
col_6 MEDIUMTEXT,
col_6 MEDIUMTEXT,
col_1 TEXT,
col_1 TEXT,
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 'VARCHAR(5), VARCHAR(5), col_2 MEDIUMTEXT, col_2 MEDIUMTEXT, col_3 MEDIUMTEXT, c' at line 4What could this be?
Thank you.
--John
RE: FT1 Data Import Error - jkeisers - Apr 13th, 2010
Never mind, I found what caused the problem. The database table of one of the forms was changed manually by adding a tinyint(1) field somewhere. The import module, and the functions in /global/code/forms.php, could not handle this, of course. When I deleted this field, the module imported all the data for our 125 forms without problems.
RE: FT1 Data Import Error - Ben - Apr 18th, 2010
Ah, good to hear. Thanks for posting the fix, John!
- Ben