When running report it shows the SQL query

When running report it shows the SQL query

per Nico Potgieter -
Nombre de respostes: 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 

Mitjana de qualificacions: -
En resposta a Nico Potgieter

Re: When running report it shows the SQL query

per Michael E -
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.


Mitjana de qualificacions: -