nuBuilder Forum

deniol wrote:Hey Gui, I can't find the creation script for these tables either, this means everyone installing it must face this problem?! I hope nuBuilder aren't withholding these sections of the scripts to make people pay for support or push them towards the paid service?!

I installed nuBuilder a week ago on a Debian Linux system. It runs fine. I do *not* have the 'adhoc' tabels in the database. A few days ago a friend did the same on XAMP (I think win8) and gets the blank page too. As he downloaded nuBuilder around the same time, I guess we have identical versions.

I hope this helps you to pinpoint the problem.

Guys, reading last error messages in Apache log file can give you more information about the issue.

Try to set display_errors = Off in php.ini.

Max

Hi all,

As far as i can see this error is in the debug mysql.

===USER==========

globeadmin

===PDO MESSAGE===

SQLSTATE[HY000]: General error: 1364 Field 'zzzsys_session_log_added_at' doesn't have a default value

===SQL===========

INSERT INTO zzzsys_session (zzzsys_session_id, sss_zzzsys_user_id, sss_timeout) VALUES ('5464c6d9c29c43e','globeadmin', 1415890649)

===BACK TRACE====

D:\WPN-XM_server\www\nuBuilderPro-master\nuapi.php - line 1052 (nuRunQuery)

D:\WPN-XM_server\www\nuBuilderPro-master\nuapi.php - line 23 (nuLogin)

After some research i see a lot of these errors: all changed/viewed_at or_by in session en user_logging tables

Mine is running now but i had to change the default values for:

`zzzsys_access_level_php`
`zzzsys_access_level_log_added_at` datetime NOT NULL,
`zzzsys_access_level_log_added_by` varchar(25) NOT NULL,
`zzzsys_access_level_log_changed_at` datetime NOT NULL,
`zzzsys_access_level_log_changed_by` varchar(25) NOT NULL,
`zzzsys_access_level_log_viewed_at` datetime NOT NULL,
`zzzsys_access_level_log_viewed_by` varchar(25) NOT NULL,

`zzzsys_access_level_form`
`zzzsys_access_level_form_log_added_at` datetime NOT NULL,
`zzzsys_access_level_form_log_added_by` varchar(25) NOT NULL,
`zzzsys_access_level_form_log_changed_at` datetime NOT NULL,
`zzzsys_access_level_form_log_changed_by` varchar(25) NOT NULL,
`zzzsys_access_level_form_log_viewed_at` datetime NOT NULL,
`zzzsys_access_level_form_log_viewed_by` varchar(25) NOT NULL,

to something like CURRENT_TIMESTAMP and "system". but i don't know if i'm breaking something with this.

grtz

Have a look at the MODE for MySQL - I had a similar issue but when researched, I was using MySQL in STRICT mode (default installation on my Windows machine). Once I had reset this all installation issues disappeared.

This is one link to give more information - http://nickbartlett.com/how-to-turn-off ... rict-mode/ but there are many others.

Ian

Had the same issue... This finally solved my problem:

miljko wrote:Solved this problem by adding NULL as default value to number of fields in tables zzzsys_user and few other tables.
Go through records in zzzsys_debug and you will find what SQL queries caused the problem.
Then add NULL as default value for fields not addresed in queries...

BR
Nikola

Good luck.

.