Adding subtable columns to query causes an error

[TwitchBlade]

Wappler Version : 5.4.1
Operating System : 12.6.1
Server Model: PHP
Database Type: MySQL
Hosting Type: Docker

What do you think should happen?

Adding a subtable’s columns to a query should not cause an error.

What actually happens?

Adding the subtable columns causes the following message:
“Undefined property: stdClass::$sub”

How to reproduce

In my case, I have a “users” table in which I have created a “roles” table. When adding the users table to a query with INNER or LEFT JOIN and adding the roles table to the columns, I get the above error. I noticed that other user table columns get added with the proper alias name like “participants_table.id” etc. but the roles table gets added as “users.roles” (see screenshot) so I removed the alias so they would all be added as users.column_name and users.role, but that didn’t help. Perhaps this is not supported, but I could have sworn that I’ve done it this way before.

[patrick]

Does it also give some stack information like the filename and linenumber where the error was generated?

[kfawcett]

I have a similar bug report.

Cannot read properties of undefined (reading 'sub') thrown in Database Paged Query

Wappler Version: 5.4.0 Operating System: Windows 11 Server Model: node.js Database Type: Postgres Hosting Type: local docker Expected behavior Records with subtable data should be returned by Server Connect Actual behavior Server 500 error with “Cannot read properties of undefined (reading ‘sub’)” How to reproduce Set up a Database Paged Query with a suitable and try to list records on a page. NOTE: Using a Single Record or Multiple Records query type works fine.

[TwitchBlade]

Thanks for the quick reply @Patrick and @kfawcett. I didn’t see the other bug report, my apologies.

Is this what you’re looking for Patrick?

{“code”:0,“file”:"/var/www/html/dmxConnectLib/modules/dbconnector.php",“line”:259,“message”:“Undefined property: stdClass::$sub”,“trace”:"#0 /var/www/html/dmxConnectLib/modules/dbconnector.php(259): exception_error_handler(8, ‘Undefined prope…’, ‘/var/www/html/d…’, 259, Array)\n#1 /var/www/html/dmxConnectLib/lib/App.php(197): modules\dbconnector->paged(Object(stdClass), ‘qCompetitors’, Array)\n#2 /var/www/html/dmxConnectLib/lib/App.php(137): lib\App->execSteps(Object(stdClass))\n#3 /var/www/html/dmxConnectLib/lib/App.php(126): lib\App->exec(Object(stdClass), false)\n#4 /var/www/html/dmxConnectLib/lib/App.php(104): lib\App->exec(Object(stdClass))\n#5 /var/www/html/dmxConnect/api/teams/getCompetitors.php(8): lib\App->define(Object(stdClass))\n#6 {main}"}

[patrick]

Do you have a JOIN in the query and is the sub table on the joined table?

[TwitchBlade]

Yes it is in the joined table.

[patrick]

Thx, that helped me finding the issue.

Here an update: dbconnector.zip (2.5 KB) unzip to dmxConnectLib/modules.

[TwitchBlade]

Looks like that fixed it. Thank you!

[TwitchBlade]

@kfawcett, see if that works for you as well.

[kfawcett]

It fixed my issue as well.

[Teodor]

Fixed in Wappler 5.4.2