Cannot read properties of undefined (reading 'toUpperCase')

[beejan01]

Wappler Version : 7.23
Operating System : win11
Server Model: Nodejs
Database Type: mariadb
Hosting Type: wappler local

Expected behavior

db query step add table and fields along with sub table. open sub table for further setup like conditions and sort by double clicking added sub-table line.

Actual behavior

double clicking sub table line to open it results in error;
"cannot read properties of undefined (reading 'toUpperCase')"

i am not using toUpperCase anywhere.

How to reproduce

add a server action and add a database query step. on query builder add a table which has a sub table. add fields of first table along with sub table to query builder column. try to open sub table for editing. fails with above said error.

[ben]

The problem has to do with setting the date fields as type date/datetime.

Setting them to type text may remove the error message, although the main cause is still there.

This is a bug.

Edit: Sorry, my story may not be related to your problem. In my case the error produced this message:

"Cannot read properties of undefined (reading 'toISOString')"

[franse]

@beejan01

db query step add table and fields along with sub table.

This was reported few days ago, assigned already:

Cannot open subtable in Database Query Builder

Wappler Version : 7b23 Operating System : MacOS Server Model: Database Type: Hosting Type: Actual behavior What actually happens? When subtable record is clicked to open the subtable in Databse Query Builder, it shows and error Cannot read properties of undefined (reading 'toUppreCase'). When I click on Ok, it closes the subtane Database Query Builder and returns to the main query builder. So, practically there's no option to access the subtable query builder and perform any further act…

[George]

Problem found, it was caused by a change in the latest beta update

It will be fixed in the next beta

[beejan01]

tried to search before i posted. also did not hit that post when i composed mine.

PS.
can't do without sub table in query. 6 stable is useful to get things done. It is a big disappointment that 6 stable is abandoned with that bothersome UX making already small work area even smaller leaving much space unusable. Things like that do more harm than good.

[Teodor]

Fixed in Wappler 7 beta 25