probably stupid question but...

[Sasquatch]

I'm trying to create simple brows edit form,
all goes well until message :

Code: Select all

 There is now a Button called kk on the Fast Forms tab of the User Home Form

except there is nothing in user home not even fast forms tab!!
all that changed is new table created in database
tried everything including server reboot

is there a decent manual or tutorial video on current version? all YouTube videos are 2-3 years old and nothing looks even remotely similar.

pizza tutorial is impossible to follow when basic things like building simplest form possible doesn't seem to work.
is 4.5 in alpha or am I just exceptionally thick here?

[kev1n]

Hi,

Code: Select all

is there a decent manual or tutorial video on current version? all YouTube videos are 2-3 years old and nothing looks even remotely similar.

I wonder what video you watched? Although some are already a few years old, most of them can also be used for version 4.5. E.g.
"How To Use The Fast Form Builder With nuBuilder Forte:" https://www.youtube.com/watch?v=bgiqHDUI5hs

is 4.5 in alpha or am I just exceptionally thick here?

No, it isn't. Moreover, I haven't seen any other messages in the forum that there are problems with it.

However, in order to be able to help you, we need some further information from you.

- nuBuilder Version (Tab Setup, Button Setup, then Tab Setup)
- PHP, mySQL Version
- Screenshot of the Form Builder, before the "Build Fast Form" button is clicked.
- Check the nuDebug Results for errors
- Check the Developer Console (F12) for errors
- Check your (Apache) Server log

Also check if the button has been created in the database table zzzzsys_object.

[Sasquatch]

thanks for quick reply.

nuBuilder version :

Code: Select all

Files version :V.4.5-2021.03.12.00
DB Version: V.4.5-2021.03.08.01 

PHP 7.4.16
MYSQL 5.7.33
Apache 2.4



I have 18 nuDebug errors, first of them:

Code: Select all

[0] : 
===USER==========

globeadmin

===PDO MESSAGE=== 

SQLSTATE[HY000]: General error: 1786 Statement violates GTID consistency: CREATE TABLE ... SELECT.

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

CREATE TABLE ___nu1604dfc230040f___ SELECT * FROM zzzzsys_object WHERE 1=0

===BACK TRACE====

/usr/local/www/apache24/data/nubuilder/core/nubuilders.php - line 147 (nuRunQuery)

/usr/local/www/apache24/data/nubuilder/core/nucommon.php(1291) : eval()'d code - line 1 (nuBuildFastForm)

/usr/local/www/apache24/data/nubuilder/core/nucommon.php - line 1291 (eval)

/usr/local/www/apache24/data/nubuilder/core/nucommon.php - line 421 (nuEval)

/usr/local/www/apache24/data/nubuilder/core/nuapi.php - line 62 (nuRunPHPHidden)

common in all remaining errors is:

Code: Select all

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nubuilder4.___nu1604ddfc9e7288___' doesn't exist

Same errors appear both when creating new table through builder (table is being created in database) and when selecting manually added table.

F12 does nothing in any of nuBuilder screens in opera and brings up page source in chrome.

No errors in apache server log.

I'm guessing that upon success I would see row with test2 in sob_all_zzzzsys_form_all column of zzzzsys_object table?

btw found a post about same error, no solution though : https://forums.nubuilder.cloud/viewtopic. ... hilit=1051

[Sasquatch]

it seems that

Code: Select all

SQLSTATE[HY000]: General error: 1786 Statement violates GTID consistency: CREATE TABLE ... SELECT.

is caused by non GTID(introduced in mysql 5.6) safe SQL statements in nuBuilder.
setting gtid_mode=OFF and enforce_gtid_consistency=OFF in my.cnf and restarting mysql server solved the issue.

but it seems to me(keep in mind i'm a total total noob) that below is a long term solution:
https://stackoverflow.com/questions/407 ... -violation
second answer to be precise.