Custom query not displaying results

[JamesJenkins]

hi, not sure if I am being a dullard, but I have a page setup that worked just fine with a query built using “simple query” builder. But I needed to use some views so used custom builder.

my query works perfectly when run in the query builder, I get the correct data set.

i attach screen shot showing the query and its result set (1 row). A screenshot showing my server connect front end and using the server connect and the repeat region with the data points in the page.

loading the page just says “server error”

thanks

[JamesJenkins]

i also just rebuilt the query using the query builder, again i get the same results set when viewing data set in query builder, but get a 500 error on the front end, i have looked at the debugger its basically a 500 error, i have a filter on it, but that has worked in past before i changed to a view, but i also removed the filter to see if it fixed the 500 error and it didnt

[Teodor]

Debugging Server Connect Errors

You can easily debug issues related to server-side processing such as - form not sending email, record not inserting or updating, query not showing data etc. The first thing you need to do is to open the server connect settings. They are located in the Workflows Panel > Server Actions: [Screenshot 2021-09-27 at 10.02.35] And enable the Debug Mode: [Screenshot 2021-09-27 at 10.03.08] Click Save: [Screenshot 2021-09-27 at 10.03.26] In your browser, open the Developer tools. If you don’t k…

[famousmag]

Hey @JamesJenkins

1. Do you have the debugger on?
   
   

@JamesJenkins

500 error on the front end

Please screenshot the error in console

[JamesJenkins]

i do have it on, screenshot here

[famousmag]

You have a $_GET variable filter?

[JamesJenkins]

yeah, I have a small drop down on the top to filter clients that are active/inactive (sends 1 or 0).

[JamesJenkins]

[famousmag]

1. can you shcreenshot the parameters on your builder?
   

   

2. the dropdown has a default value? In order to send a value to the api on page load?

[JamesJenkins]

[JamesJenkins]

the drop down/filter worked all good before changing query to using views, its a select list that sends 0 or 1, but it all has worked fine until changing the query to use the views

[Teodor]

@JamesJenkins

do have it on, screenshot here

As explained on the link i posted, click Preview to see the exact error.

[famousmag]

This condition protects the serveraction from failing if a Get variable is not set…

[JamesJenkins]

[Teodor]

In your database connection settings is the Prepare Statements option set to true or false?

[JamesJenkins]

set to auto

[Teodor]

Just set this option to true and save the database connection.

[JamesJenkins]

that got it, working now. is that something special to using a view? as never had that before

[JamesJenkins]

and thanks , would never ever ever have found that