Welcome to the nuBuilder Forums!

Register and log in to access exclusive forums and content available only to registered users.

Error

Questions related to using nuBuilder Forte.
Post Reply
Nico
Posts: 8
Joined: Fri Jan 24, 2020 2:04 pm

Error

Unread post by Nico »

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)
kev1n
nuBuilder Team
Posts: 4307
Joined: Sun Oct 14, 2018 6:43 pm
Has thanked: 71 times
Been thanked: 448 times
Contact:

Re: Error

Unread post by kev1n »

What form were you trying to create? Has the table been created in the db?
Nico
Posts: 8
Joined: Fri Jan 24, 2020 2:04 pm

Re: Error

Unread post by Nico »

Form1.png
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.
You do not have the required permissions to view the files attached to this post.
kev1n
nuBuilder Team
Posts: 4307
Joined: Sun Oct 14, 2018 6:43 pm
Has thanked: 71 times
Been thanked: 448 times
Contact:

Re: Error

Unread post by kev1n »

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.
Nico
Posts: 8
Joined: Fri Jan 24, 2020 2:04 pm

Re: Error

Unread post by Nico »

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?
kev1n
nuBuilder Team
Posts: 4307
Joined: Sun Oct 14, 2018 6:43 pm
Has thanked: 71 times
Been thanked: 448 times
Contact:

Re: Error

Unread post by kev1n »

Klaasebaasje
Posts: 1
Joined: Fri Jan 17, 2020 10:59 am

Re: Error

Unread post by Klaasebaasje »

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

File zipped due to policy restriction forum. :)
You do not have the required permissions to view the files attached to this post.
kev1n
nuBuilder Team
Posts: 4307
Joined: Sun Oct 14, 2018 6:43 pm
Has thanked: 71 times
Been thanked: 448 times
Contact:

Re: Error

Unread post by kev1n »

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)
Fast Form.PNG
As you see, the objects are shown on the Edit Screen:
edit_form.PNG
Can you try again creating a form for your table tbltest with Fast Form?
You do not have the required permissions to view the files attached to this post.
Post Reply