The following warnings occurred: | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Warning [2] Undefined array key "avatartype" - Line: 783 - File: global.php PHP 8.1.31 (Linux)
|
Database error on new form - Printable Version +- 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: Database error on new form (/showthread.php?tid=2575) |
Database error on new form - lukeadamis - Aug 27th, 2013 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 |