The following warnings occurred:
Warning [2] Undefined array key "avatartype" - Line: 783 - File: global.php PHP 8.1.31 (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.31 (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.31 (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.31 (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.31 (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.31 (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.31 (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.31 (Linux)
File Line Function
/printthread.php 160 errorHandler->error
Warning [2] Undefined array key "showvideos" - Line: 165 - File: printthread.php PHP 8.1.31 (Linux)
File Line Function
/printthread.php 165 errorHandler->error
Warning [2] Undefined array key "showimages" - Line: 160 - File: printthread.php PHP 8.1.31 (Linux)
File Line Function
/printthread.php 160 errorHandler->error
Warning [2] Undefined array key "showvideos" - Line: 165 - File: printthread.php PHP 8.1.31 (Linux)
File Line Function
/printthread.php 165 errorHandler->error
Warning [2] Undefined array key "showimages" - Line: 160 - File: printthread.php PHP 8.1.31 (Linux)
File Line Function
/printthread.php 160 errorHandler->error
Warning [2] Undefined array key "showvideos" - Line: 165 - File: printthread.php PHP 8.1.31 (Linux)
File Line Function
/printthread.php 165 errorHandler->error



Form Tools
17 forms on site, and one errors out - Printable Version

+- Form Tools (https://forums.formtools.org)
+-- Forum: Form Tools (https://forums.formtools.org/forumdisplay.php?fid=1)
+--- Forum: Installation (https://forums.formtools.org/forumdisplay.php?fid=4)
+--- Thread: 17 forms on site, and one errors out (/showthread.php?tid=5203)

17 forms on site, and one errors out - Jim777 - Jun 8th, 2015

I searched but couldn't find an answer. I have many HTML forms on a site and all but one went in without a hitch. When I fill out the form to submit to Form Tools I get:
ERROR
Error Type: System
Error Code: #103 — Learn more about this error.

Debugging:

ft_initialize_form, /home/sgbfaux/public_html/global/code/forms.php, failed query: 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 'd', 1, 'no', '', 'string', '29', 'yes')' at line 3

The only thing that changes is the empty argument between string and no if a text field is filled out.

Is there anything I can do to remedy this?

Thanks!

RE: 17 forms on site, and one errors out - Joe - Jun 9th, 2015

Hi Jim,

The empty argument shouldn't cause any issues. I believe it's 'string' in the following field that is causing the error. String is a MySQL reserved word (http://dev.mysql.com/doc/refman/5.6/en/keywords.html) which will cause the syntax error.

Hope this helps.

Cheers,

Joe

RE: 17 forms on site, and one errors out - Jim777 - Jun 9th, 2015

(Jun 9th, 2015, 12:40 PM)Joe Wrote: Hi Jim,

The empty argument shouldn't cause any issues. I believe it's 'string' in the following field that is causing the error. String is a MySQL reserved word (http://dev.mysql.com/doc/refman/5.6/en/keywords.html) which will cause the syntax error.

Hope this helps.

Cheers,

Joe

Yes, except I have no idea how to fix it. I was running done old script I got off the net for parsing forms, but then the hosting company killed them, I assume for security reasons. They supply Form Tools with many of the bells and whistles they offer, so I'm getting any sites I've done with forms, over to this. I think this is the last site, last form.