FT1 Data Import Error

[jkeisers]

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 4

What could this be?

Thank you.

--John

[jkeisers]

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.

[Ben]

Ah, good to hear. Thanks for posting the fix, John!

- Ben