Subtable error: subResults is not defined

Wappler Version : 4.9.1
Operating System : mac
Server Model: node
Database Type: maria
Hosting Type:

Expected behavior

I should be able to add a subtable

Actual behavior

In this particular query, adding this subtable generates an error:

{"status":"500","message":"subResults is not defined","stack":"ReferenceError: subResults is not defined\n    at App.select (/Users/pauka/WapplerProjects/tbd/lib/modules/dbconnector.js:61:69)\n    at processTicksAndRejections (node:internal/process/task_queues:96:5)\n    at async App._exec (/Users/pauka/WapplerProjects/tbd/lib/core/app.js:491:30)\n    at async App._exec (/Users/pauka/WapplerProjects/tbd/lib/core/app.js:458:17)\n    at async App.exec (/Users/pauka/WapplerProjects/tbd/lib/core/app.js:427:9)\n    at async App.exec (/Users/pauka/WapplerProjects/tbd/lib/modules/core.js:228:13)\n    at async App._exec (/Users/pauka/WapplerProjects/tbd/lib/core/app.js:491:30)\n    at async App.exec (/Users/pauka/WapplerProjects/tbd/lib/core/app.js:427:9)\n    at async App.define (/Users/pauka/WapplerProjects/tbd/lib/core/app.js:417:9)"}

How to reproduce

When selecting the media subtable, it is added and displays:

However if I click okay to save the query, and immediately re-open it displays like this:

And if run the api, the error noted above is thrown.

The joins on the table are:

Having this bug now too

Please try this update: dbconnector.zip (2.1 KB) Unzip in lib/modules.

This fix is included now as inline extension update for both Wappler 4 and 5 beta