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:
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:
Thanks in advance!
Welcome to the nuBuilder Forums!
Register and log in to access exclusive forums and content available only to registered users.
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
-
- 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
You do not have the required permissions to view the files attached to this post.
-
- 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
Hi,
Can you run this command in the developer console?
and show the result here (just the relevant part where the table itemust appears)?
Can you run this command in the developer console?
Code: Select all
parent.nuFORM.tableSchema
-
- 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
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:
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:
You do not have the required permissions to view the files attached to this post.
-
- 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
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 2. Calling parent.nuFORM.tableSchema inside F12
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 2. Calling parent.nuFORM.tableSchema inside F12
You do not have the required permissions to view the files attached to this post.
-
- 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
Did you log in afterwards?Celson wrote: Note that the table "tarefas" does not appear when I call parent.nuFORM.tableSchema
-
- 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
Yes! After I logged in it worked great!kev1n wrote:Did you log in afterwards?Celson wrote: Note that the table "tarefas" does not appear when I call parent.nuFORM.tableSchema