Page 1 of 1

Error during install

Posted: Mon Aug 01, 2016 7:50 pm
by Jester
I am getting the following error while trying to install nubuilder3 / pro

Code: Select all

Done! 
No Schema Changes!
SQL Errors:
Array
(
    [0] => Array
        (
            [0] => 1406
            [1] => Data too long for column 'trl_translation' at row 1
            [2] => INSERT INTO `template_zzzsys_translate`
Please see attached screenshot for further details

Re: Error during install

Posted: Mon Aug 08, 2016 3:41 am
by shane
what version of PHP are you using

Re: Error during install

Posted: Mon Sep 12, 2016 1:07 pm
by mtregael
Hi,

Same problem for me, php version: PHP Version 5.4.34

For me, the problem is line 722 of file nubuilder.sql

The line like them sounds to long with lot of: "Æââââ¬Å¡Ã¬Ã¢ââ¬Å¾Ã¢ÃÆÃâÃâ Ã¢â¬âÃâÃââÃÆââââ¬Å¡Ã¬Ãâ¦Ã¡ÃÆââ¬Å¡ÃâìÃÆ"

regard,
Gael

Re: Error during install

Posted: Thu Feb 16, 2017 2:51 am
by Fike
I had the same problem.

Found the answer here:

http://stackoverflow.com/questions/1889 ... column-why

Just find some line similar to this one in my.ini file:

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

And delete ',STRICT_TRANS_TABLES'

That solved the problem in my case

Kind regrads,

Re: Error during install

Posted: Sun Feb 26, 2017 6:43 am
by leo_al
I had the same issue, looking at the datetime format I I found this:
http://stackoverflow.com/questions/3729 ... 0000-00-00

1. It seems that this MySQL Version 5.7.17 under Mac OS X Sierra doesn't allow this format "0000-00-00", instead of I used CURRENT_TIMESTAMP.

2. Additionally, the error from line 723 is due to the size of the "weird" string (ÃÃ...), I deleted those values.

After that, the installation runs without errors, however when I try to log in the next page is completely blank...

Any help?