Creating Server Action unstable when using "Count"

[turn3636]

4.1.1 on a Mac with MS SQL

Built a query. I had to make some changes so I go back to the server action and click “Query Builder”. Button turns blue but nothing happens. Just to add, ctrl-S for save does not work me for the Server Actions. Have to go to the menu and click Save.

Not the same issue, but I have noticed that Wappler has crashed several times for me this morning after updating to 4.1.1. Until now, it has crashed for me maybe 3 times since the first beta release.

[turn3636]

I think I found the issue. If I create a regular query, everything works. It’s only when I add an aggregate of “Count” does the server action freeze up and Wappler becomes unstable. It won’t let me open query builder again.

[George]

Try this fix:

Workflows - Globals - add database query, cant open query editor

Ok found the problem, it happens if you use aliases in your queries. Unpack the following dbConnector_rules.js dbConnector_rules.zip (4.5 KB) on Windows in: C:\Users\username\AppData\Roaming\Wappler\Configuration\Shared\DMXzone\dmxServerConnect\rules on Mac in: ~/Library/Application Support/Wappler/Configuration/Shared/DMXzone/dmxServerConnect/rules Make sure you place just the js file there not the whole zip! Let me know if it works It will be included with the next update

[turn3636]

Yes, I’m using an alias.

[George]

This was fixed in Wappler 4.1.2