Welcome to the nuBuilder Forums!

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

Error on SQL Builder when trying to add table

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

Error on SQL Builder when trying to add table

Unread post by Celson »

When I try to add a table on SQL Builder (I choose the table on dropdown) I see the following error:

Code: Select all

TypeError: s[t] is undefined
See screenshot in attachment.
You do not have the required permissions to view the files attached to this post.
toms
Posts: 785
Joined: Sun Oct 14, 2018 11:25 am

Re: Error on SQL Builder when trying to add table

Unread post by toms »

Hi,

Does it happen with any table or just the 'employee' table?
Celson
Posts: 36
Joined: Wed Jan 27, 2016 12:35 pm
Location: Salvador, Bahia - Brazil

Re: Error on SQL Builder when trying to add table

Unread post by Celson »

It happens with some tables. When I try to use one of the zzzz tables it works. For the tables built by me, in my tests it works in one of them and does not work in two tables created by me.

I was following that YouTube video that teaches to build a financial application in nuBuilder. I was using the SQL builder on product table to join with customer in order to show the customer name on customer column (instead of his id). In this moment, when I tried to show the tables (choose on dropdown field) it happened. With both customer and product tables.
toms
Posts: 785
Joined: Sun Oct 14, 2018 11:25 am

Re: Error on SQL Builder when trying to add table

Unread post by toms »

Quoting Steve:
nuBuilder Forte loads the database schema at login (otherwise the system would slow down).
If you change something in phpmyadmin you'll need to login again.


Could this be the reason?
Celson
Posts: 36
Joined: Wed Jan 27, 2016 12:35 pm
Location: Salvador, Bahia - Brazil

Re: Error on SQL Builder when trying to add table

Unread post by Celson »

Nothing was changed in phpMyAdmin after I started to follow the tutorial. I did it BEFORE to follow it. I've deleted a table from there.

Try to follow the tutorial "How To Build An Invoicing Application With nuBuilder". The error occurs at 2:14 of the video.
Celson
Posts: 36
Joined: Wed Jan 27, 2016 12:35 pm
Location: Salvador, Bahia - Brazil

Re: Error on SQL Builder when trying to add table

Unread post by Celson »

Hmmm... I think you found the problem! I just logged out then logged in... then I tried again and it works!!
admin
Site Admin
Posts: 2814
Joined: Mon Jun 15, 2009 2:23 am
Been thanked: 25 times

Re: Error on SQL Builder when trying to add table

Unread post by admin »

.
Locked