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
MySQL mode setting - 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: MySQL mode setting (/showthread.php?tid=467)

MySQL mode setting - scott.adams - Jan 28th, 2010

I am getting the following error:
Incorrect integer value: '' for column 'email_from_account_id' at row 1
and searching this forum I found that this issue is being caused by MySQL running in strict mode. I was just wondering what mode MySQL should be set to so that this error and possibly others do not occur?

RE: MySQL mode setting - Ben - Jan 30th, 2010

Hi Scott,

I believe MySQL Strict Mode is just an on/off option, so it just needs to be turned off. However, I do realize that some hosting environments won't let you do this, so I consider this a bug. I've already logged it here:
http://bugs.formtools.org/index.php?cmd=view&id=170

I'll actually be releasing 2.0.0 final today, but I'll address this in the next core build.

- Ben

RE: MySQL mode setting - scott.adams - Jan 30th, 2010

(Jan 30th, 2010, 10:26 AM)Ben Wrote: Hi Scott,

I believe MySQL Strict Mode is just an on/off option, so it just needs to be turned off. However, I do realize that some hosting environments won't let you do this, so I consider this a bug. I've already logged it here:
http://bugs.formtools.org/index.php?cmd=view&id=170

I'll actually be releasing 2.0.0 final today, but I'll address this in the next core build.

- Ben

Ben thanks for getting back to me. There are actual options that can be set for the mysql mode setting within the my.ini file. I was able to get things working by just remarking out the mode setting and letting it take the default. I'll try a few of the different settings and see which one works best.