Wappler 4 Database error when trying to fetch data

Wappler General Need Help
1

Wappler version 4.0.1 on Windows 10
Docker hosting remote
MySQL database
Node Server model
Hosting on AWS

The remote hosting tests OK. Also, I can access the database in the container with Navicat. In Wappler, I try to fetch the data in one of the tables and I get the following error:

image
image1348Ă—574 34.7 KB

I have refreshed the schema several times, everything seems OK but the error persists.

Please let me know what I may be doing wrong.

Best.

Jay

2

What field type is the buying_price displayed in the error message?

3

It was a Decimal.

I say “was” because the database schema was modified and the new field is “share_price”. You can see what I get from Navicat, which is what I was expecting when pressing the fetch data button in Wappler:

image
image1441Ă—605 58.4 KB

Hope it helps.

Best.

Jay

4

Maybe try reopening your database connection and click save. Also try refreshing the schema to get the new field names.

5

Hi Teodor,

I didn’t realise that there were 3 “Refresh Schema” levels:

  1. db level,
  2. Tables level and,
  3. Single table level

Once I refreshed the 3 levels, I managed to fetch the data. My mistake was that I was just refreshing the schema only at the single table level and I needed to refresh the schema at the 3 levels.

Many thanks!

1 Like