When running report it shows the SQL query

When running report it shows the SQL query

by Nico Potgieter -
Number of replies: 2

When the report is executed it shows the SQL query on the top of the page. I have searched all over but can find where to switch this off. I am using version 2011040110 

Average of ratings: -
In reply to Nico Potgieter

Re: When running report it shows the SQL query

by Michael E -
Picture of Core developers Picture of Testers
Yes. I have the same problem and reported it in the tracker: https://tracker.moodle.org/browse/CONTRIB-5305

Here is the solution (which I posted in the tracker):

I just noticed that "debugdisplay" defaults to "Yes" in Moodle 2.6.4, but not in 2.6.

Thus, line 678 in report.class.php might not be a good idea:

if ($debug OR $CFG->debugdisplay OR $this->config->debug) {

We should take "debugdisplay" out:

if ($debug OR $this->config->debug) {

Otherwise the plain SQL displays when viewing the report in Moodle 2.6.4 (and probably higher).


So if you change the line in the report.class.php file, you will be fine. Alternatively, turn off "debugdisplay" in the Moodle Debug settings.


Average of ratings: -
In reply to Michael E

Re: When running report it shows the SQL query

by Nico Potgieter -

Thank you for that response it solved my problem.

Actually it is worthwhile remembering this for the future.

You are a star.

Average of ratings: -