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



Form Tools
host upgraded to MySQL 5.5, requires a few script edits? - 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: host upgraded to MySQL 5.5, requires a few script edits? (/showthread.php?tid=1991)

host upgraded to MySQL 5.5, requires a few script edits? - Kfrix - Apr 16th, 2012

I tried to add a form this morning to my 2.04 Form Tools install. The form stalled at the last step with an error msg that boiled down to: 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 16"

The line of code the error referred to in /global/code/forms.php -
TYPE=MyISAM DEFAULT CHARSET=utf8";

A touble ticket to my host server confirmed, they had upgraded to MySQL 5.5 and said I would need to Search for TYPE=MyISAM Replace with ENGINE=MyISAM

I searched and found that in most places where TYPE=MyISAM appears, the next line is ENGINE=MyISAM. But not in the forms.php file.

So in that file, I changed TYPE=MyISAM to ENGINE=MyISAM and all was well, I completed setting up the new form.

My question is, should I search the entire install and change every instance of TYPE=MyISAM and replace it with ENGINE=MyISAM if that line is not already there? Is there any script I should not edit?

This might be a no-brainer for most of you, but I hate to tinker around in the code of a system that is supporting 45 live forms that really need to stay working.

Thanks,

Kathryn