The application got installed and the database/schema got created. But when I try to login to the application I get a 500 error and see the following error in the http log file.
[Wed Feb 26 11:29:27 2014] [error] [client <IP>] PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1364 Field 'zzzsys_debug_setup' doesn't have a default value' in /u01/DocRoot/nub/nucommon.php:63\nStack trace:\n#0 /u01/DocRoot/nub/nucommon.php(63): PDOStatement->execute(Array)\n#1 /u01/DocRoot/nub/nudatabase.php(87): nuDebug('?===USER=======...')\n#2 /u01/DocRoot/nub/nuapi.php(964): nuRunQuery('INSERT INTO zzz...')\n#3 /u01/DocRoot/nub/nuapi.php(24): nuLogin('globeadmin', 'nubuilder')\n#4 {main}\n thrown in /u01/DocRoot/nub/nucommon.php on line 63, referer: http://<HOSTNAME>/nub/
If I alter the table and move forward, I keep getting similar error for almost all tables for all not null columns with out a default value.
I am getting an almost identical error. I used the distro from the nubuilder.net site and then reading admin's reply even went and got the newest files from github.
[01-Mar-2014 03:23:14] PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1364 Field 'zzzsys_debug_setup' doesn't have a default value' in E:\inetpub\wwwroot\nubuilder\nucommon.php:63
Stack trace:
#0 E:\inetpub\wwwroot\nubuilder\nucommon.php(63): PDOStatement->execute(Array)
#1 E:\inetpub\wwwroot\nubuilder\nudatabase.php(87): nuDebug('?===USER=======...')
#2 E:\inetpub\wwwroot\nubuilder\nuapi.php(964): nuRunQuery('INSERT INTO zzz...')
#3 E:\inetpub\wwwroot\nubuilder\nuapi.php(24): nuLogin('globeadmin', 'nuPassword')
#4 {main}
thrown in E:\inetpub\wwwroot\nubuilder\nucommon.php on line 63
I'm using PHP 5.3.5 and MySQL 5.6.16
EDIT: Also tried upgrading to PHP 5.5.9, same result. And I just confirmed my nuBuilder 2.0 app works fine on this platform.
In C:\ProgramData\MySQL\MySQL Server 5.6\my.ini I changed
character-set-server = utf8
to
character-set-server = latin1
and removed the value after
sql-mode =
and nuBuilder 3.0 is now functioning properly. I don't remember seeing this in the documentation. Of course, I didn't actually read any of the documentation either.
I also created the new database with collation latin1_swedish_ci although I'm not sure if that was necessary.