BUG: refresh database table in query builder does not show all fields

Wappler General Bugs
#1

======== TEMPLATE BUG FORM ========

Wappler Version : 5.3.1
Operating System : Windows 10
Server Model: PHP
Database Type: MySQL
Hosting Type: Local Laragon

Expected behavior

What do you think should happen?

List all fields in Query Builder

Actual behavior

What actually happens?

I was editing a Database Updater API using the query builder and I went to add new fields and now only some fields from the Mysql table appear. I have a bunch of fields (100+) but now Wappler is unable to list them in the Query Builder and I can’t set them up for the update action. This API has several upload conditions before updating Mysql. In the Database Manager all fields appear normally and I also refreshed the schema as shown here in the community.

query-builder-1
query-builder-11896×1000 77.9 KB
query-builder-2
query-builder-21550×937 59.1 KB
query-builder-3
query-builder-31548×936 143 KB
query-builder-4
query-builder-41942×1024 171 KB

How to reproduce

  1. Open Query Builder and see if Wappler loads all fields (I have more than 100 fields).

wappler_query_builder

Wappler 5.3.2 Released
#2
#3

Has this bug been resolved yet? I’m stuck without being able to move forward with my project

#4

There hasn’t been an update for the last couple of weeks, as our team is having a Christmas break. We will be back tomorrow and @patrick will check this.

#5

Thanks Teodor!

#6

We had a similar bug once for select query builder, we fixed it there but it seems that it was not applied for the insert/update query builder. The upcoming update will have that fix for insert/update queries also. Let us know if the problem still exists after the update.

#7

Hello @patrick.
I wonder if this bug will be fixed in the next Thursday update. It’s because I’m stuck with this project without being able to change the fields.

#8

yes it will be fixed

#9

Okay, @George.
Thank you very much.

#10
#11

Fixed in Wappler 5.3.2

1 Like
#12
#13