Page 1 of 1

No Button on the User Home Form

PostPosted: Mon May 20, 2019 5:01 am
by zazoo
Hi,

I wanted to created a very easy Form with the fast Form Builder.
He tells me:
A Form has been created!
(There is now a Button called pat_child on the Fast Forms tab of the User Home Form)
..when I go there its empty...

I fetched source from github.
I pressed the Update Button.

Debug shows:
===USER==========
globeadmin
===PDO MESSAGE===
SQLSTATE[42S02]: Base table or view not found: 1051 Unknown table 'dbs68644.___nu15ce1ab9d5e66a___'
===SQL===========
DROP TABLE ___nu15ce1ab9d5e66a___
===BACK TRACE====
/homepages/40/d66016757/htdocs/uvco/wordpress/nubuilder4/nubuilders.php - line 363 (nuRunQuery)
/homepages/40/d66016757/htdocs/uvco/wordpress/nubuilder4/nucommon.php(1254) : eval()'d code - line 1 (nuBuildFastForm)
/homepages/40/d66016757/htdocs/uvco/wordpress/nubuilder4/nucommon.php - line 1254 (eval)
/homepages/40/d66016757/htdocs/uvco/wordpress/nubuilder4/nucommon.php - line 381 (nuEval)
/homepages/40/d66016757/htdocs/uvco/wordpress/nubuilder4/nuapi.php - line 48 (nuRunPHPHidden)

The other way over Form creation doesn't work either.

Would be very great if someone could help me :-)
Thanks a lot!

Re: No Button on the User Home Form

PostPosted: Mon May 20, 2019 7:58 am
by admin
zazoo,

Can you make a Form with just 2 fields?


Steven

Re: No Button on the User Home Form

PostPosted: Mon May 20, 2019 3:25 pm
by zazoo
Hi,
I made new nubuilder4.sql import (with changing the two lines to CREATE VIEW instead of CREATE ALGO...)
I set to php version 7.2 (before it was 5.x (sorry for that))
mysql is 5.7
pressed update Button

Gone to Fast Form created two input text fields for a table pat_child -> ch_name and ch_prename
Clicking on Form List ... it is empty
User Home ... empty...

In debug shows same as befor and additional when I click on Form List:

Debug:
===USER==========
globeadmin
===PDO MESSAGE===
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dbs68644.___nu15ce23b18b5027___' doesn't exist
===SQL===========
SELECT zzzzsys_object_id,sob_all_type,sob_input_type,sob_all_id,zzzzsys_form_id,sob_all_label,sfo_description,syt_title
FROM zzzzsys_object JOIN ___nu15ce23b18b5027___ ON zzzzsys_object_id = theid JOIN zzzzsys_tab ON zzzzsys_tab_id = sob_all_zzzzsys_tab_id JOIN zzzzsys_form ON zzzzsys_form_id = syt_zzzzsys_form_id
WHERE 1 AND ( (CONVERT(sob_all_type USING utf8) LIKE "%nufflaunch%" OR CONVERT(sob_input_type USING utf8) LIKE "%nufflaunch%" OR CONVERT(sob_all_id USING utf8) LIKE "%nufflaunch%" OR CONVERT(zzzzsys_form_id USING utf8) LIKE "%nufflaunch%" OR CONVERT(sob_all_label USING utf8) LIKE "%nufflaunch%" OR CONVERT(sfo_description USING utf8) LIKE "%nufflaunch%" OR CONVERT(syt_title USING utf8) LIKE "%nufflaunch%") ) LIMIT 0, 20
===BACK TRACE====
/homepages/40/d66016757/htdocs/uvco/wordpress/nubuilder4/nuform.php - line 898 (nuRunQuery)
/homepages/40/d66016757/htdocs/uvco/wordpress/nubuilder4/nuform.php - line 324 (nuBrowseRows)
/homepages/40/d66016757/htdocs/uvco/wordpress/nubuilder4/nuapi.php - line 42 (nuGetFormObject)


Stefan