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



Form Tools
mysql Install problem - 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: mysql Install problem (/showthread.php?tid=84)

mysql Install problem - tizzo - Mar 25th, 2009

Hi there
I'm excited to try the new beta form tools
however, I'm running into install probs

See here:

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 'DEFAULT CHARSET=utf8' at line 6

Please double-check your database settings and click the Continue button again.

I'm using 1and1.com and the server MySQL Database provided by 1&1 is 4.0.25

Any tips ?

RE: mysql Install problem - Ben - Mar 26th, 2009

Hey tizzo,

I think the problem may be the SQL syntax. I just compared FT1 with FT2 and there's a minor difference for the form creation syntax. The new one uses the term "ENGINE" to define the database type, whereas the old one uses "TYPE".

I've attached a new file to this email. Upload it to your server and overwrite the old /install/files/sql.php file. Then try a fresh installation.

My hunch is that this will fix it, but let me know either way!

- Ben

RE: mysql Install problem - Bluff - Jul 7th, 2009

I get the same error even after using the new sql.php file.

"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 'DEFAULT CHARSET=utf8' at line 6"




(Mar 26th, 2009, 9:18 PM)Ben Wrote: Hey tizzo,

I think the problem may be the SQL syntax. I just compared FT1 with FT2 and there's a minor difference for the form creation syntax. The new one uses the term "ENGINE" to define the database type, whereas the old one uses "TYPE".

I've attached a new file to this email. Upload it to your server and overwrite the old /install/files/sql.php file. Then try a fresh installation.

My hunch is that this will fix it, but let me know either way!

- Ben


RE: mysql Install problem - zildjian - Jul 9th, 2009

I get the same error after using the new sql.php file too

RE: mysql Install problem - Xpider - Jul 14th, 2009

All I did was change privileges on the connecting database user to strictly localhost and Voila! no further issues.
I'm guessing the install script doesn't like database users with Global or All privileges.

RE: mysql Install problem - bill09 - Aug 24th, 2009

I have the same issue: "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 'DEFAULT CHARSET=utf8' at line 6"

I created a new DB user with only R/W - still no go. I don't have an option in my hosts CP for localhost only.

And I tried the new sql.php file also.

Any ideas?

Thanks. Bill

RE: mysql Install problem - RodrigoDC - Apr 27th, 2010

I see that this was given no resolution to some. I had the same problem and I resolved it as follows:

Open the file /install/files/sql.php

Replace every instance of DEFAULT CHARSET=utf8 and DEFAULT CHARSET=latin1 for a blank space. In other words, delete every instance above.

Upload the file to your server, and try to install again.

For your convenience, I've uploaded the file I used.

As I said, this worked for me.

Good luck,
Rodrigo

RE: mysql Install problem - Ben - May 1st, 2010

Hi Rodrigo,

Thanks for this. I'm going to log it as a bug. Most databases allow for UTF-8, but the installation script should at least provide the option of a different charset if it's not installed.

Thanks for the post + fix.

- Ben

[EDIT: bug logged here - http://bugs.formtools.org/index.php?cmd=view&id=224]