I didn’t know it but one of my pages quit working despite no changes. As near as I can tell a custom query is causing the issue with this error.
Are you seeing this error when opening the SA? Or when opening the custom query builder?
In the server action when I click the execute query to test it
I discovered it when pages using the SA started coming up blank
if I remove the parameter :P! and replace it with a static year (which is what the parameter selection is) from the query it connects and test fine
It should be :P1 or :P2 if you have an exclamation, that might be what's causing the issue? (unless you just mistyped in the post above)
If the SA & query builders load fine, its the response from DB that might be causing this issue. Wappler is unable to convert the rows returned by DB into JSON format it seems.
What version of PHP are you using? If you are not sure, just create a php file named info.php and place it in the root of your site.
Add the following content inside it
<?php
phpinfo();
?>
and open the file in your browser. You will see the PHP version there.
PHP Version 5.4.45
oops typo - it was a working file before
Your PHP version is really old (v5.4 was released 9 years ago).
Please make sure you are running at least 5.5.0 or newer.
1 Like
That was it. My hosting provided defaults to 5.4 (ugh) but up to 7.4 is available. Thanks
1 Like