Legacy Pass ?explain=1 to nonseo file

[Bossland]

When running in debug mode it is possible to see what queries are running and what the page load time is etc. To get the detailed information about what queries are being run you must pass ?explain=1 to the page. It seems like currently dbseo does not pass this along.

I usually run with

if ($_SERVER["REMOTE_ADDR"] == "x.x.x.x" ) 
{
// enable debug mode for only my IP address
$config['Misc']['debug'] = true;
}

so that I can investigate how my changes are affecting the forums.

 

[janslu]

Are you using master & slave servers for mysql? I have to switch to a single server config for explain to work.

 

[Fillip H.]

When running in debug mode it is possible to see what queries are running and what the page load time is etc. To get the detailed information about what queries are being run you must pass ?explain=1 to the page. It seems like currently dbseo does not pass this along.

I usually run with

if ($_SERVER["REMOTE_ADDR"] == "x.x.x.x" ) 
{
// enable debug mode for only my IP address
$config['Misc']['debug'] = true;
}

so that I can investigate how my changes are affecting the forums.

If I'm reading your post correctly, you want the debug mode and/or the ?explain flag to give you debug information regarding DBSEO's PHP and MySQL usage?

If so, then this is not possible. About 50% of DBSEO's code runs before vBulletin is even instantiated, and it uses its own MySQL wrapper that is completely independent from vBulletin (although uses the same connection parameters). This wrapper does not support debug output.

 

[Bossland]

No, id like to pass the explain on to showthread or the forumlist or whatever page i am currently viewing.


Ie
https://www.thebuddyforum.com/rebor...-rebornbuddy-version-1-0-141-a.html?explain=1
Should show the explain page for the post in question.

 

[Fillip H.]

That does already happen. DBSEO does not strip that parameter, unless the URL you're attempting to explain is a redirect URL, e.g. "go to new post"

 

[Bossland]

What would the proper url format be? As the one I provided does not work and the original page is loaded instead.

 

[Fillip H.]

The page you linked is the correct format. We use a similar trick for debug mode here, and as you can see DBSEO does not strip the explain parameter: https://www.dropbox.com/s/r7r9x66k5iiev14/Screenshot 2014-06-18 13.33.00.png