nuBuilder Forum

Following the manual I now struggle over adding the edit screen. No object shown as indicated in the manual. Any Clou?

If I look into the errorlog I see
[0] :
===USER==========

globeadmin

===PDO MESSAGE===

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

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

SELECT SUM(sfo_type) AS total_0,SUM(sfo_code) AS total_1,SUM(sfo_description) AS total_2,SUM(sfo_table) AS total_3
FROM zzzzsys_form INNER JOIN ___nu15e3023b369cbf___ ON zzzzsys_form_id = theid
WHERE 1
ORDER BY sfo_code

===BACK TRACE====

/home/public/sites/rfw.leadinginchange.nl/nubuilder4-master/nuform.php - line 350 (nuRunQuery)

/home/public/sites/rfw.leadinginchange.nl/nubuilder4-master/nuform.php - line 331 (nuBrowseTotals)

/home/public/sites/rfw.leadinginchange.nl/nubuilder4-master/nuapi.php - line 42 (nuGetFormObject)

What form were you trying to create? Has the table been created in the db?

I am just creating an input form following the manual but using my own existing mySQL table.Some happens if I create a new table with phpMyAdmin (NuBuilder). Quering the database works fine.Values are shown okay in the browse form.

I am now at page 35 'Steps to add Objects to an Edit Screen. '

I have included a screenshot.

Did you create the form with Form Builder?
It's important not to add the primary key field while creating the form.
Otherwise nuBuilder won't create the objects for your form (although there's a success message at the end)

The error you see is not related to the creation of the form.
This is just a bug of the nuBrowseTotals() and doesn't have any side effects.

Following the steps in the manuel with provided tables etc 1-to-1 still no succes. Might it be that my host'server has some limitations by ruling although no errors in log during installation?

Can you upload a db dump?

https://forums.nubuilder.cloud/viewtopic. ... 234#p20312

Sorry for the late reply, attached the dump. Hope you can help.

File zipped due to policy restriction forum.

I used Fast Form to create a "Browse and Edit" table for your existing table tbltest.

fldtestkort (Input:Text)
fldtestlang (Select:Textarea)
fldtestchanged (Input:nuDate)
As you see, the objects are shown on the Edit Screen:
Can you try again creating a form for your table tbltest with Fast Form?