The following warnings occurred:
Warning [2] Undefined array key "avatartype" - Line: 783 - File: global.php PHP 8.1.27 (Linux)
File Line Function
/global.php 783 errorHandler->error
/printthread.php 16 require_once
Warning [2] Undefined array key "avatartype" - Line: 783 - File: global.php PHP 8.1.27 (Linux)
File Line Function
/global.php 783 errorHandler->error
/printthread.php 16 require_once
Warning [2] Undefined variable $newpmmsg - Line: 40 - File: global.php(841) : eval()'d code PHP 8.1.27 (Linux)
File Line Function
/global.php(841) : eval()'d code 40 errorHandler->error
/global.php 841 eval
/printthread.php 16 require_once
Warning [2] Undefined array key "style" - Line: 909 - File: global.php PHP 8.1.27 (Linux)
File Line Function
/global.php 909 errorHandler->error
/printthread.php 16 require_once
Warning [2] Undefined property: MyLanguage::$lang_select_default - Line: 5024 - File: inc/functions.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions.php 5024 errorHandler->error
/global.php 909 build_theme_select
/printthread.php 16 require_once
Warning [2] Undefined array key "additionalgroups" - Line: 7162 - File: inc/functions.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions.php 7162 errorHandler->error
/inc/functions.php 5044 is_member
/global.php 909 build_theme_select
/printthread.php 16 require_once
Warning [2] Undefined array key 1 - Line: 1415 - File: inc/functions.php PHP 8.1.27 (Linux)
File Line Function
/inc/functions.php 1415 errorHandler->error
/inc/functions.php 1370 fetch_forum_permissions
/printthread.php 76 forum_permissions
Warning [2] Undefined array key "showimages" - Line: 160 - File: printthread.php PHP 8.1.27 (Linux)
File Line Function
/printthread.php 160 errorHandler->error
Warning [2] Undefined array key "showvideos" - Line: 165 - File: printthread.php PHP 8.1.27 (Linux)
File Line Function
/printthread.php 165 errorHandler->error
Warning [2] Undefined array key "showimages" - Line: 160 - File: printthread.php PHP 8.1.27 (Linux)
File Line Function
/printthread.php 160 errorHandler->error
Warning [2] Undefined array key "showvideos" - Line: 165 - File: printthread.php PHP 8.1.27 (Linux)
File Line Function
/printthread.php 165 errorHandler->error



Form Tools
Stuck Error step 5 > You have an error in your SQL syntax [solved] - Printable Version

+- 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!