Data not showing from database

dundaslife · February 18, 2022, 4:05pm

Hi, I am trying to pull some data from my database to show it on the page. I followed the instruction from this video

When I follow the instruction on 8:46, mine only shows the headings of the data and not showing the actual data.

also when I open up the API on the browser, the JSON file shows

Any help would be thankful.

sid · February 18, 2022, 6:51pm

Hi,
The error simply means that Node modules are not installed correctly.
Try using the update/install options.

dundaslife · February 21, 2022, 12:05am

Sorry, where is the update/install option? Do you mean updating Wappler or a certain project?

Thanks,

guptast · February 21, 2022, 1:47am

In the bottom status bar, the node packages can be installed / updated.

dundaslife · February 21, 2022, 2:30am

I did installed/updated but it shows the same error; still shows me this when I try to build a table with my database.

guptast · February 21, 2022, 2:34am

Looks like you are selecting the field id as the datasource. Select the serverconnect1.data.testing as the datasource to populate the data fields.

dundaslife · February 21, 2022, 4:18am

I selected serverconnect1.data.testing, but it still doesn’t show data on the table. Are there any afterward steps I should do?

guptast · February 21, 2022, 5:42am

Do you see any errors in the browser dev console? Check whether bootstrap4table generator scripts have been added correctly on the page (scripts on the layout page and wappler include reference on the content page, if it’s a SPA ).

Also from the screenshot I can see that serverconnect1 in the AppConnect panel is inside the Container block. It’s a good practice to keep the server connect code outside/before any UI elements.

dundaslife · February 22, 2022, 4:44am

Hello, I am seeing the same error, ‘status: 500’ for the API that’s calling on the website as you can see in this screenshot.

which leads to

also, I think there is a problem with bootstrap 4 which I can see on this screen shot,

but I do have bootstrap 4 installed on my Wappler.

What would help solve this problem?

sid · February 22, 2022, 11:19am

The error is still pretty clear that you don’t have the correct module.
Try running the install command in a terminal.
In the bottom menu bar, you should see an option to start a terminal.
Open that and run the command npm install mysql --save.

dundaslife · February 22, 2022, 3:05pm

I've tried

npm install mysql --save

bunch of times, it did not work... Sorry, I forgot to mention it beforehand.

sid · February 22, 2022, 4:10pm

Looks like the project folder itself has some wrong configuration.
As per your previous screenshot, BS files are missing as well.

Looks like you might have to re-build in a new project.