I get an error when i tried to run a query in the query builde UI

Wappler General How To
#1

Hi guys, i get an error when i tried to run a query in the query builde UI.
wappler 5.2.0
windows 10
php

image

Wappler 5.2.1 Released
#2
#3

Please make sure you have defined a direct database connect in Wappler’s Database Manager for this database connection as this is required to be able to run the queries directly.

Will make sure that a better error message is displayed next time.

#4

Now it works, thks.

#5

Hmmm, I have the same error on a project. Direct connection is enabled and set up. Seems to me that if the query requires a parameter you get this error. So some queries actually work and some don’t.

Screen Shot 2022-10-14 at 9.59.40 AM
Screen Shot 2022-10-14 at 9.59.40 AM938×482 19 KB

Here is the actual query:

SELECT *
FROM employers
WHERE Employer_CallBack < :P1 /* {{NOW.dateAdd("hours", -8).formatDate("yyyy-MM-dd")}} */ AND Employer_CallBack > '2019-01-01'
ORDER BY Employer_CallBack ASC
#6
#7

Fixed in Wappler 5.2.1

#8
#9

This topic was automatically closed after 45 hours. New replies are no longer allowed.