Errors with Query Builder?

[rozojc]

Hi everyone. I would like to have options for our office admin to be able to export student lists with all the information that is on the database on each student (address, email, parents, phone numbers, etc. etc).

I saw there did not seem to be an option to do this, and read it should be possible through the Query Builder module.

However, after installing, when I create on “Add query”, I see several PHP warnings/errors, and I am not sure things are displaying how they should.

And if I click the “Help’“ button I get a pop up with the following:

Warning: Undefined array key “Tables_in_Gibbon” in C:\laragon2\www\gibbon\modules\Query Builder\queries_help_full.php on line 63

Warning: Undefined array key “Tables_in_Gibbon” in C:\laragon2\www\gibbon\modules\Query Builder\queries_help_full.php on line 65

Warning: Undefined array key “Tables_in_Gibbon” in C:\laragon2\www\gibbon\modules\Query Builder\queries_help_full.php on line 68

Warning: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘’ at line 1

1. Line 200 in C:\laragon2\www\gibbon\src\Database\Connection.php

2. Line 184 in C:\laragon2\www\gibbon\src\Database\Connection.php

3. Line 119 in C:\laragon2\www\gibbon\src\Database\Connection.php

4. Line 68 in C:\laragon2\www\gibbon\modules\Query Builder\queries_help_full.php

Uncaught Exception: Error - PDO object is uninitialized

1. Line 70 in C:\laragon2\www\gibbon\modules\Query Builder\queries_help_full.php

2. Line 70 in C:\laragon2\www\gibbon\modules\Query Builder\queries_help_full.php

3. Line 87 in C:\laragon2\www\gibbon\src\View\View.php

4. Line 478 in C:\laragon2\www\gibbon\src\View\Page.php

5. Line 73 in C:\laragon2\www\gibbon\fullscreen.php

Any ideas?

Also, is there any documentation on how to use this module?

[Ali]

Hi @rozojc

For your goal: yes, Query Builder is the right tool to export full student data (addresses, contacts, parent links, etc.), and you can export query results to Excel.Thanks for the detailed comment.

From that stack trace, this does not look like an error in your custom SQL query. The failure is happening in the Help popup itself, before your query runs.

It looks like Query Builder is trying to read the SHOW TABLES result using a specific key name, and on your setup that key is different, which then triggers the follow-on SQL error.

Please try these first:

Update to the latest Gibbon version and latest Query Builder module version.
Re-test Add Query and Help after update.
Share your Gibbon version, PHP version, MySQL/MariaDB version, and the exact database name in config.php. You can also share your Query but please hide any personal or critical information.

Documentation is currently light in-module, but the built-in Help in Query Builder is intended to show available tables/columns for query writing. Thank you.