'Setup' tab doesn't appear

[oldhamuk]

Morning,

I'm having the same issue. I'm also running the same OS if that makes any difference.

I've tried the 'nuSystemUpdate();' option and the 'UPDATE `zzzzsys_setup` SET `set_denied` = '0';' recommendation but neither have made any difference.

Also I am getting errors in the Console, I'm not a programmer so struggling to underatand where to look next.

For example when I click 'Fast Form' I see the below in my console:

nuform.js?ts=20180308114424:1189 Uncaught TypeError: Cannot read property 'id' of undefined
at nuSUBFORM (nuform.js?ts=20180308114424:1189)
at nuBuildEditObjects (nuform.js?ts=20180308114424:381)
at nuBuildForm (nuform.js?ts=20180308114424:98)
at successCallback (nuajax.js?ts=20180308114424:108)
at Object.success (nuajax.js?ts=20180308114424:15)
at fire (jquery.js?ts=20180308114424:3305)
at Object.fireWith [as resolveWith] (jquery.js?ts=20180308114424:3435)
at done (jquery.js?ts=20180308114424:9242)
at XMLHttpRequest.<anonymous> (jquery.js?ts=20180308114424:9484)


​Then clicking home returns a blank page and I end up having to log back into again.

I'm not really sure where to look, could it be I'm missing a package on the server?

Regards

Mark.

[admin]

Mark and kiwironnie,

Its most likely you are missing records in the table called zzzsys_tab - but I'm still guessing.

Here is a list of all the tables and records in a fresh copy of nuBuilder Forte.

tables.PNG

Steven

[mikevb]

I'm having the exact same problem. Tried all the suggestions but no success.

I'm using:
- Macos 10.13.3
- Apache 2.0
- PHP 7.1.7
- MySQL 5.7.21
- nubuilder4

Did someone find a fix for that?
Thank you!
Mike

[mikevb]

That took me a while, but the solution is simple:
MySQL 5.7.21 does not ship with a my.cnf or default-my.cnf or similar.
If the file on your installation exists then add or change the following line under "mysqld".

Code: Select all

sql-mode=NO_ENGINE_SUBSTITUTION

If it doesn't exist, create a file /etc/my.cnf with the following content (where /etc/ is the standard directory. Maybe your installation uses another one):

Code: Select all

[client]
port=3306
socket=/tmp/mysql.sock

[mysqld]
port=3306
socket=/tmp/mysql.sock
key_buffer_size=16M
max_allowed_packet=8M
sql-mode=NO_ENGINE_SUBSTITUTION

[mysqldump]
quick

restart MySql Server
check if the sql-mode is set with the following SQL-query:

Code: Select all

SHOW VARIABLES
WHERE Variable_name = 'sql_mode'

The result should only show sql_mode NO_ENGINE_SUBSTITUTION.

delete all tables from the nubuilder4 - database
import the nubuilder4 - database from the nubuilder4 download-file

You should be able to login and see the tabs now.

[admin]

Mike,

Thanks for sorting that problem out.

Steven

[marcvander]

After upgrading MySQL from 5.5 to 5.7, I had the same issue. The solution of mikevb solved it!

[admin]

.