Query Builder errors

Installing latest version of Query Builder into v21, v22. Getting:

OH NO!
Something has gone wrong: the Gibbons have escaped!

An error has occurred. This could mean a number of different things, but generally indicates that you have a misspelt address, or are trying to access a page that you are not permitted to access. If you cannot solve this problem by retyping the address, or through other means, please contact your system administrator.

Also, what is the meaning of this query result:

Your request failed with the following error: SQLSTATE[HY093]: Invalid parameter number: no parameters were bound

On v20, QB v1.9.01 with some queries.

APACHE ERROR LOGS
[Thu Mar 11 18:14:37.757740 2021] [proxy_fcgi:error] [pid 20061:tid 140609062991616] [client …] AH01071: Got error ‘PHP message: Warning: SQLSTATE[HY093]: Invalid parameter number: no parameters were bound in /home/…/public_html/home/src/Database/Connection.php on line 203’, referer: http://…/index.php?q=%2Fmodules%2FQuery+Builder%2Fqueries_run.php&queryBuilderQueryID=0000000001&search=&sidebar=false

[Thu Mar 11 18:14:28.212490 2021] [proxy_fcgi:error] [pid 20061:tid 140608832202496] [client …] AH01071: Got error ‘PHP message: PHP Warning: include(/home/…/public_html/home/modules//moduleFunctions.php): failed to open stream: No such file or directory in /home/…/public_html/home/modules/Query Builder/queries_gibboneducom_remove_ajax.php on line 24PHP message: PHP Warning: include(/home/…/public_html/home/modules//moduleFunctions.php): failed to open stream: No such file or directory in /home/…/public_html/home/modules/Query Builder/queries_gibboneducom_remove_ajax.php on line 24PHP message: PHP Warning: include(): Failed opening ‘/home/…/public_html/home/modules//moduleFunctions.php’ for inclusion (include_path=’.:/usr/share/php’) in /home/…/public_html/home/modules/Query Builder/queries_gibboneducom_remove_ajax.php on line 24’, referer: http://…/index.php?q=/modules/Query%20Builder/queries.php

Hi Tieku,

It looks like you may need to update your Query Builder to the latest version to be compatible with Gibbon v21+. The current version is v1.13.05. Query Builder added support for variables in one of the latest versions, and the queries you’re syncing from the server likely contain variables because you’re using a newer version of Gibbon (looks like the sync checks the Gibbon version to decide on the list of queries to sync).

One you update the module in your file system, be sure to update it in System Admin > Manage Modules, then go to Query Builder and re-sync your queries. You should then see the queries working, and some of them now have variables added to them.

Hi Sandra,

There are 2 separate issues. I’ll start with the first.

I did install v1.13.05 on both v21.0.01 and v22.0.00 and when I go to Admin, Query Builder I get the message: OH NO! Something has gone wrong: the Gibbons have escaped!

Is there always an attempt to sync queries with the server, even when I’m using my own queries?


The second issue is with an older installation v20.0.00, QB v1.9.01
Query Builder comes up. With some queries, I’m getting: Your request failed with the following error: SQLSTATE[HY093]: Invalid parameter number: no parameters were bound

Thanks

Hi Tieku, thanks for clarifying:

  1. After installing v1.13.05, did you go to the Manage Modules page to run the update for that module? That may be one cause of the error you’re seeing. Otherwise, can you check your PHP error logs. If you’re using a production install and you see the “Oh No” message, that usually means a fatal PHP error.

  2. Is the second error with queries you’ve created yourself, or queries synced from the server? The error you’re seeing relates to variables added to the query that are not used in the SQL syntax of the query, or vice versa, variables used in the SQL that are not setup for that query.