SQL Explain, how to disabled? PhpBB 3.1.14

[KenTSA]

Hi. For a long time i have in footer of forum this text

Time: 0.275s | Peak Memory Usage: 14.32 MiB | GZIP: Off | Queries: 251 | SQL Explain

I want to remove it because anyone can acces SQL Explain and there is informations from databases... please help me..

[Sniper_E]

In the root directory, in the bottom of your config.php you will see these lines.

Code: Select all

@define('PHPBB_INSTALLED', true);
@define('PHPBB_ENVIRONMENT', 'production');
@define('DEBUG_CONTAINER', true);

You can comment out that last line like this. // @define('DEBUG_CONTAINER', true);

That file is read only so you will have to change the permission on it to edit it with Notepad++
After editing it then make it read only again.

[KenTSA]

In the root directory, in the bottom of your config.php you will see these lines.

Code: Select all

@define('PHPBB_INSTALLED', true);
@define('PHPBB_ENVIRONMENT', 'production');
@define('DEBUG_CONTAINER', true);

You can comment out that last line like this. // @define('DEBUG_CONTAINER', true);

That file is read only so you will have to change the permission on it to edit it with Editor++
After editing it then make it read only again.

Thanks for the information, I checked this for the first time, and my debug line is commented out.

Code: Select all

@define('PHPBB_INSTALLED', true);
@define('PHPBB_ENVIRONMENT', 'production');
// @define('DEBUG_CONTAINER', true);

**Edit*

I deleted the line of code with debug_output from the theme's overal_footer.html and it no longer appears for users and visitors, I only find it in the ACP, the problem is that if someone knows how to access SQL Explain from the forum link, they can see the database name and that confuses me a lot and gives me a headache.

[SpIdErPiGgY]

Not everyone can see the Sql Explain. Only the load time.
Sql explain is only visible to founders OR admins that can see sql info in ACP