Schema/fields have dissappeared from queries since 3.7.7 update when using data picker - SC

mgaussie · February 19, 2021, 12:51am

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

Wappler Version : 3.7.7
Operating System : Mac
Server Model: NodeJS
Database Type: MySql8
Hosting Type: AWS DOCKER

Expected behavior

What do you think should happen?

I created a simple single DB query. In the next action I want to select data from the query.

Actual behavior

What actually happens?

I can only select the query itself - no fields from the query are available to be selected.

How to reproduce

Create a new query in a Server Action.
Create a second action (in my case a DB Insert) - try to select a field from the previous db query.

brad · February 19, 2021, 1:00am

I was just coming on to report that same issue. Glad it not just me. I am on PHP though. Should also mention that when I load the page I get a 200 status on the server connect action. It’s just in the UI it doesn’t read.

mgaussie · February 19, 2021, 1:02am

Happening on SC side and AC side for me on NodeJS unfortunately.

Pretty big issue, really.

brad · February 19, 2021, 1:03am

Yep, I’m stuck now too. Can’t go any further on my project.

mgaussie · February 19, 2021, 1:16am

You can manually write the expressions - and it appears to be working, if that’s any help?

transcoderm · February 19, 2021, 4:22am

Same here. Unable to see them under repeat in SC. Can we have this fixed ASAP @George I can’t wat for the next Thursday. This bug really slows my workflow and reduce productivity by a lot. 2021-02-19 (2)

George · February 19, 2021, 5:26am

Do you have a working database connection in the database manager and does it displays all the tables in your database?

mgaussie · February 19, 2021, 5:28am

Yep.

George · February 19, 2021, 7:02am

We have identified the bug. It is an UI bug in the Data Pickers, that prevents you to pick from the column of a db query.

We will release an update later today to fix it.

mgaussie · February 19, 2021, 7:22am

Awesome George, thank you!!

swf · February 19, 2021, 10:00am

Also getting an endless loop when refreshing the database within update ui.

George · February 19, 2021, 12:57pm

that will also be fixed as well

Teodor · February 19, 2021, 4:31pm

Fixed in Wappler 3.7.8

swf · February 19, 2021, 4:57pm

Not fixed for me. Problem stays the same …

George · February 19, 2021, 5:08pm

What exactly is not fixed and what doesn’t work?

Please post a new topic with details.

Also make sure you have a working Database Manager connection.