I am trying to run a custom. query from a view. When I run the Query I get the following error.
I am only using a custom query because a normal paged query does not bring up any results.
I am trying to run a custom. query from a view. When I run the Query I get the following error.
I am only using a custom query because a normal paged query does not bring up any results.
Hello Brad,
That's a common issue with MySQL versions prior 5.7 and db views - that's actually a bug in PHP.
Open your database connection step and you can adjust this setting there.
I thought you already know how to debug such issues: Debugging Server Connect Errors
Which is most probably the same issues as with the custom query...
Yes, I was getting a 500 error on the normal paged query. But it didn’t give me any details as to what the issue was. So I tried a custom query just to see what was happening.
Thanks to your great support I was able to fix the regular paged query. I set ‘Prepare Statement’ to True and it works like a charm.
Thanks again for the quick support! You guys rock!