BS4 Table Generator - Hello World

I am reviewing a number of no-code platforms and I am concerned with the rapid releases of Wappler there is no solid revision control, as what I have seen in the Forum does not match the current Wappler and even the Intro To Wappler, and I have seen numerous issues with dynamic data and the bootstrap table generator, and I am only working with the “Hello World Dynamic” section of the training videos and it does not work, When you create the server action and generate the BS4 Dynamic table all I get is the header row. If I go to the Database tool and fetch the data, I can see 20 rows of data (cars). So not sure what the difference is. Other than there are a number of actions in the earlier demos that as of the Nov release are no longer needed or available.

So not sure why the table generator is only returning the header row. I have tried deleting the server connect and creating a new server connect a couple of times, with the same result. However, this last time I actually got an error " Failed to load resource: the server responded with a status of 404". That is not expected, given that everything in the training video is setup with a single container on docker, so self contained. What is wors is it does not tell you what resource failed to load.

Not encouraging when a basic hello world training video does not actually work.

Can someone direct me to a current December 2020 how to. OR the bug fix.

Thanks much,
Erik

The other problem I see with the default cars data. Instead of pointing at cars I created another query and this time pointed at the images table, except I found that the “Data Binding” does not show any data for the table:

And when I view the data I have to fetch to see the data, before it shows any data.

I believe I got the cars table to show a triangle beside Data by adding a couple of rows. But even that did not enable the BS4 Table Generator to show anything other than the header row.

I know there has been some discussions about what is stored locally and what is stored on a server, but everything I am working on should be local. And I don’t know how to check or fix.

Erik

Hi Erik, welcome to Wappler.

What are you running for a local server? Seems to me your MySQL server isn’t running? Does your database connection test OK?

Welcome to the Wappler Community @erik!

The BS Table Generator works just fine. Let’s see what we might discover might be causing the issue you are having.

First, please provide the following:

  • Wappler Version

  • Server Type (php, asp, nodejs, etc)

  • Database Type (mysql, sql, etc)

  • Hosting Type (docker, remote, mamp, xamp, etc)

Secondly, could you you click the server action that has the query used to generate the BS Table and then click on the “Open in browser” button at the top of the server actions and see what the output is.

Screen Shot 2020-12-04 at 2.49.10 PM

If there are results shown when you click on “Open in browser”, please let us know.

Repeat the same steps for the images that you are trying to retrieve.

After that, please take a screenshot of your server action and post it here so we can see how you have it set up.

1 Like

I am not impressed with how flakey Wappler appears to be.

I am using Wappler 3.5.7, Docker hosting, NodeJS v14.15.0 and whatever mysql gets installed into the Docker container. There was no indicaton that there was a need to separately download a database. I would prefer to use Firestore… but I know Wappler doesnot have that ability.

When I run the system check it says everything is running fine, although as I scroll back I do not see any reference to checking MySQL. But it does show that it creates the database, and in the database tool it does show 4 tables, and when you run the fetch it does show data, but not until you run the fetch,.

And as you can see I have tried to rebuild this tutorial project, now for a 3rd time and I get the same errors each time. And all I really wanted to test was ability to connect to API end points on a variety of cloud services and ultimately my client’s business transformation platform.

So I am running out of enthusiasm for using Wappler as a dev tool, unless there is a clear explanation of what is going on.

Thanks,
Erik

Also I see you are on an older version. I don’t have Globals option. And in the version I just rebuilt here is what I get for the SC and the BS4 Table Generator.

and as you see you can’t open the data… so I can’t even get it to generate a table.

And on the older version, when I go to browser it just shows the header row.

Erik

I am likewise not impressed with your statement.

You might have missed it, but its a HUGE section on mysql when you set up the target. Click on the gear icon next to Development and then click on targets. Also, you see it in checking the mysql Output right there in your screen shot when it says node_world_3_development_db_1 .... done. "db" in this case means database and "done" means initialized.

The database manager only fetches the data when you click on it, otherwise you would be constantly pulling data when you don't need to be.

Please don't make statements you don't understand. I am on Wappler 3.5.7 which means I am on the current version and I also have experimental mode on which means I have things active that you do not, which is why I have globals and you don't.

Your most recent screenshot tells me all I need to know. There is an error in your server action because it is not showing the data that it needs to. For example, on a paged query, you should see something like this.

This is what it looks like with a regular query in the server action.

Please take a screen shot of your server action so we can see what the issue seems to be.

1 Like

Hi Erik,

The course you are referencing was made with the Experimental Features option of Wappler turned on, in order to get the new features included. It is certainly possible that things will operate differently without those experimental features turned on.

Sorry for the confusion...

Actually, @erik, I just relook at your screenshot and I see the error now.

Please add a database connection prior to your query. Since you do not have experimental mode on, you do not have access to the global database connection and you need to add a database connection prior to each query.

To add a database connection, right click on the step and go to database actions, then click on database connection.

Additional documentation that will be helpful to you can be found at https://docs.wappler.io

1 Like

Scott,
Please do not take exception with your customer, you create further doubt and insecurity, which is not helpful.

The last image I uploaded shows you that I do not have any data under the Server Connect - there is no triangle by the Data tag. So I cannot expand it. The way I got it to expand last time, was to go back to the Database control on the left side and add rows to the table. But even that did not enable the BS4 Table Generator to show anymore than the header row.

This time, I even selected the toggle button to load test data, yet I still do not see any data.

Erik

Hi Scott,
I have added the Database Connection, but still do not see Data in the connection

You can see the database connection on the left and hte fact that there is no triangle on the Data element in the Server Connect view - so then it throws an error because there are no rows available.

Erik

While I am honored to have been mistaken for a part of the staff of Wappler. I am not. I am a community volunteer that tries to help people, however, I also ask a lot of questions myself.

I don't take exception with you, I take exception with how you presented your problem. You made entirely inaccurate statements and assumptions in an aggressive manner.

In the future, a better way of going about things would be to say "I have a problem, this is not working. This is what I have done so far." That will get you a more pleasant response than they way you did it.

3 Likes

Could you take a screen shot of it? I can not see the details of it. The issue is with your connection.

Thanks Scott,
I would if I could - but I don’t know where to look anymore.
Erik

Ok, click out of the server conncect and the table generator.

Click on the database connection in your server action and see what it says.

It looks like the connection is named “db”, when you click on the database query, does it say connection db as well?

I have this from the Database Connections…

I think this is what you want and it shows connection as DB.

Ok, on that page, click on the 6th icon at the top left. the one that has an arrow coming out of a folder.

That is the open in browser button. This button will open up the query in your default browser.

What we are looking for is if it returns results or not.

If it works, it will look something like this (but not exactly)

There is nothing but the header row.

I think you clicked on the wrong arrow button. Not the one on the page, but over in the server action panel.

Screen Shot 2020-12-04 at 2.49.10 PM

Hey thats new…

{“status”:“500”,“message”:“A server error occured, to see the error enable the DEBUG flag.”}