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
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
installation problem while connecting to database - 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: installation problem while connecting to database (/showthread.php?tid=1013)

installation problem while connecting to database - krishnmx - Jan 3rd, 2011

I am getting this error while installation

3) Create Database Tables

The following error occurred:


• 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 6


RE: installation problem while connecting to database - Ben - Jan 4th, 2011

Hi Krishnmx,

Interesting... judging from the error, there's a couple of things it might be: the UTF8 charset isn't installed or you don't have the MyISAM engine type (this is just the way the database information is actually stored behind the scenes). Both of those are available in all out-the-box installations of MySQL.

Do you have phpMyAdmin access? If so, you could connect to your DB and run some queries on your database to find out what's available. Try running these queries one by one:

Code:
SHOW ENGINE InnoDB STATUS
SHOW ENGINE MyISAM STATUS
SHOW CHARACTER SET

This would at least help identify the problem. But I should note: Form Tools *requires* the UTF-8 charset and the MyISAM engine.

- Ben



RE: installation problem while connecting to database - avtomatron - Feb 14th, 2011

(Jan 4th, 2011, 6:04 PM)Ben Wrote: This would at least help identify the problem. But I should note: Form Tools *requires* the UTF-8 charset and the MyISAM engine.

Solved (via google):

you must replace
TYPE=MyISAM
in all formtools files with
ENGINE=MyISAM



RE: installation problem while connecting to database - dbennett - May 7th, 2011

Same problem.

Fedora Core 14
MySQL 5.5.11
PHP 5.3.6

Here are some quick fixes from the Unix command line:

From formtools top directory

1) Determine if you have the problem:

find . -type f -exec grep -Hi type=myisam {} \;

(no results == no problem)

2) Fix the problem:

find . -type f -name '*.php' -exec perl -pi.bak -e 's/TYPE=MyISAM/ENGINE=MyISAM/gi;' {} \;


3) Delete the backup files after fixing:

find . -type f -name '*.bak' -exec /bin/rm {} \;


(then run 1 again)

--Dave





RE: installation problem while connecting to database - Ben - May 7th, 2011

Hey Dave,

Thanks for posting this. Huh! Originally, I had it set as ENGINE=MyISAM but that threw errors on some system, so I changed it to TYPE=MyISAM. Reading up on it now, however, I gather that ENGINE is newer and TYPE is deprecated. I'll keep looking around, but I would imagine there's a way I can detect to see which one's supported on each system. If so, I'll get this fix into 2.1.0.

Thanks!

- Ben