Welcome to the nuBuilder Forums!

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

Error: itemust is not a valid table name for a Subform

Questions related to using nuBuilder Forte.
Post Reply
Celson
Posts: 36
Joined: Wed Jan 27, 2016 12:35 pm
Location: Salvador, Bahia - Brazil

Error: itemust is not a valid table name for a Subform

Unread post by Celson »

Hello,

I am facing this error when trying to add a record to a new form I build with fast forms. Could somebody help me to discover what is wrong?

This is the snapshot with the error:
{D006D60A-19E9-4474-A597-EECB5D1A317D}.png
Some more information:

When I try to add the table in a SQL Builder it does not add it. If I press F12 I see an error. See snapshot:
{075AB277-0AB0-4253-B35E-FCDA0743B101}.png
Thanks in advance!
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: itemust is not a valid table name for a Subform

Unread post by kev1n »

Hi,

Can you run this command in the developer console?

Code: Select all

parent.nuFORM.tableSchema
and show the result here (just the relevant part where the table itemust appears)?
Celson
Posts: 36
Joined: Wed Jan 27, 2016 12:35 pm
Location: Salvador, Bahia - Brazil

Re: Error: itemust is not a valid table name for a Subform

Unread post by Celson »

Hi,

I don't know what happened but when I logged in as globeadmin now and tried to add a record, it worked now!
Also, when I try to choose the table on SQL Builder it can be chosen now and appears on diagram!

Nothing was made by me for this!

Look... I now see I made mistake on a field... The field "ius_gus_codigo" is not correct to be a foreign key on grupoust table... I must call it "ius_grupoust_id". I know the name of field will not make it work or not, but I like to name all correctly."

Here is the snapshot:
{D64F64EE-2636-4E20-BB96-9D70EE0F23BA}.png
You do not have the required permissions to view the files attached to this post.
Celson
Posts: 36
Joined: Wed Jan 27, 2016 12:35 pm
Location: Salvador, Bahia - Brazil

Re: Error: itemust is not a valid table name for a Subform

Unread post by Celson »

Well, it just happened again, now with another new Fast Form built for the new database table "tarefas".

Note that the table "tarefas" does not appear when I call parent.nuFORM.tableSchema

The only thing I did that can be different (in both cases) is: I opened the database (phpMyAdmin) in another tab while I was filling the Fast Form.

1. Error after click on Save button
{31AC231D-4E84-4D29-8FD3-C86FD0DA8682}.png
2. Calling parent.nuFORM.tableSchema inside F12
{1F352F1B-8A0F-4CD6-A19B-B1C273959E9E}.png
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: itemust is not a valid table name for a Subform

Unread post by kev1n »

Celson wrote: Note that the table "tarefas" does not appear when I call parent.nuFORM.tableSchema
Did you log in afterwards?
Celson
Posts: 36
Joined: Wed Jan 27, 2016 12:35 pm
Location: Salvador, Bahia - Brazil

Re: Error: itemust is not a valid table name for a Subform

Unread post by Celson »

kev1n wrote:
Celson wrote: Note that the table "tarefas" does not appear when I call parent.nuFORM.tableSchema
Did you log in afterwards?
Yes! After I logged in it worked great!
Post Reply