+- 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: Error when i try to install (/showthread.php?tid=1703)
Error when i try to install - bizkit1 - Oct 18th, 2011
Hello all. When i reach the "Create Database Tables" step, after i press the create database tables button i get this error:
Code:
The following error occurred:
• INSERT INTO ft_field_type_validation_rules VALUES(6, 2, 'required', '{$LANG.word_required}', '{$field_name}', '', '', '{$LANG.validation_default_rule_required}', 1) - Data truncated for column 'custom_function_required' at row 1Can you please help me. Thanks
RE: Error when i try to install - Ben - Oct 18th, 2011
Hi Bizkit1,
Thanks very much for reporting this. I'm just debugging some other stuff right now, but I'll get back to you later today.
- Ben
RE: Error when i try to install - Ben - Oct 18th, 2011
Hi Bizkit,
Do you have access to phpMyAdmin on your database? Mind running this query for me & posting back with what it returns?
Code:
SELECT @@GLOBAL.sql_modeThanks!
- Ben
RE: Error when i try to install - bizkit1 - Oct 18th, 2011
Code:
@@GLOBAL.sql_mode
STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTIONRE: Error when i try to install - Ben - Oct 18th, 2011
Yeah... that's the culprit!
The problem is that you have "strict mode" running for your database, so it's throwing an error when it tries to insert empty strings into NULL fields (or vice versa). I'm working on 2.1.5 right now that includes a fix for this - among other things. But in the meantime, I'm afraid you'll have to ask your host to disable strict mode for the database.
Sorry about that.
- Ben
RE: Error when i try to install - Ben - Oct 18th, 2011
Hmm... actually, if you feel like editing one of the PHP files, I may have a solution for you.
Edit the /install/files/code.php and in the ft_install_create_database function (around line 260), right after these lines:
PHP Code:
// connect to the database
$link = @mysql_connect($hostname, $username, $password);
@mysql_select_db($db_name);
Add the following two lines:
PHP Code:
// suppress strict mode
@mysql_query("SET SQL_MODE=''", $link);
Let me know if that works for you!
- Ben
RE: Error when i try to install - bizkit1 - Oct 19th, 2011
solved it by disabling strict mode, from mysql
thanks!
RE: Error when i try to install - Ben - Oct 19th, 2011
Oh, nice!
Well, just to you know (a) the next version of the Core won't have any problems in Strict mode and (b) will suppress it anyway, like the Core does.
So thanks for reporting this!
- Ben