Page 1 of 1

New install - cannot save updated setup. No save button.

Posted: Sun Nov 03, 2019 7:10 pm
by dgoadby
I have just installed a new copy of V4. I logged in ok and, so far, it all looked ok.

I go into Setup to change the default time zone. The search worked ok (London) and I selected Europe/London but there is no button to commit/save/cancel the change. In fact all I can do from this page is leave whereupon I get the "Confirm/Stay on Page" message.

I then went to the User page to add a user and, again, there are no Save/Cancel buttons.

I'm sure that the forms must have a save/cancel etc options so why are they not appearing? I am using the latest Firefox browser but have also tried chrome and it's always the same.
I am using MySQL and Apache2.

I attach an image of the page I am seeing.

[attachment=0]nubuilder-01.png[/attachment

Re: New install - cannot save updated setup. No save button.

Posted: Sun Nov 03, 2019 7:51 pm
by Janusz
Typically it happens when you choose logout and later in the pop-up press cancell logout in the browser.
Then some buttons disappears - and then you need to logout from nuBuilder and login again to have these buttons back.

Re: New install - cannot save updated setup. No save button.

Posted: Mon Nov 04, 2019 10:02 am
by kev1n
You could also check the server logs and open the developer console (F12) to see if there are any error messages.

Re: New install - cannot save updated setup. FIXED

Posted: Wed Nov 06, 2019 3:32 am
by dgoadby
If I try to logout I am still asked if I want to leave the page which seems odd since all I have done is log in.

Activating F12 I can see that the location and class of the Save/Cancel etc buttons is NuActionHolder. The "bar" is empty of any buttons. I can see the CSS for .NUActionHolder too.

Ah, checking the debug table I have the following entry:

Code: Select all

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

globeadmin

===PDO MESSAGE=== 

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

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

INSERT INTO zzzzsys_session SET sss_access = ?, zzzzsys_session_id = ?

===BACK TRACE====

/srv/www/htdocs/nubuilder4/nuprocesslogins.php - line 107 (nuRunQuery)

/srv/www/htdocs/nubuilder4/nusession.php - line 22 (nuLoginSetupGlobeadmin)

/srv/www/htdocs/nubuilder4/nuapi.php - line 6 (require_once)

It's been a while for me with PHP but I think the message is telling me that there is a problem with 'sss_time' column.

This looks like a basic error/problem to me. Any ideas what the fix is?

Once I understood the debug messages I went into the PHP. It seems the zzzzsys_session table structure has changed and defaults to "NULL". The table used to be "Not NULL" and, as the SQL did not pass in a value for "sss_time" that's where it all went wrong. I rebuilt the database from the latest NuBuilder SQL build file and the system is now working.


Thanks to all respondents.