FORUMS


The Form Tools forums are no longer active, but the old posts have been archived here. Please see the Help page on how to get help / report issues.

Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Stuck Error step 5 > You have an error in your SQL syntax [solved]
#1
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
Reply
#2
Wink 
Thanks for your help! It was really useful!
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)