Missing Elemtens on Page - not completely created

[sonyandi]

Hello,

I have the latest version of nuBuilder Forte installed on Ubuntu 18.04.
If I sign up as a globeadmin and want to create a fast form, the page will not be completely created.

I have the same version installed on Windows / xampp and get no problems.

Does anyone know why?

When I click on available objects on the left, they are not added to the right side.
In the attached screenshot you can see that the right side is empty.

[kev1n]

I think you need to enter a table name first.

[sonyandi]

Even if i select the table First is the same behaviour

[kev1n]

That's odd. It works just fine for me. Please check the server logs and open the developer console (F12) to see if there are any error messages.

build fast form.PNG

[sonyandi]

it must be a server/php config problem because the same installation works on windows/xampp, but i don't know what

In the server error.log i can't find anything.

This is the output on the developer console, hope that helps

[calida]

hi try to edit this file

Code: Select all

/etc/alternatives/my.cnf

and attack this at the bottom

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

[sonyandi]

hello calida,

Thanks for your tip.
When I added these lines to /etc/alternatives/my.cnf, Nubuilder worked fine, but my other web app was flawed.

So I just added

Code: Select all

 sql-mode = NO_ENGINE_SUBSTITUTION

in /etc/mysql/mysql.conf.d/mysqld.cnf in the mysqld section and restarted mysql.

Everything works now.
But can you explain the reason for this or what causes sql-mode = NO_ENGINE_SUBSTITUTION?

[calida]

I don't know the reason, I knew how to help you because I had your same problem three days ago.
I found the solution on github.
Unfortunately the documentation is very little

[kev1n]

I don't know the reason, I knew how to help you because I had your same problem three days ago.
I found the solution on github.
Unfortunately the documentation is very little

This would definitely be something to be included in the wiki.

[ernesttan1976]

Same thing happened to me. Wish I had searched this page earlier.
I was moving Nubuilder from one server to another. Destination server is Windows AMPPS with Mysql 8.0.
It was giving me sql_mode errors.