Dbbbb - SQL diagnostic addon

Permalink 2 users found helpful
My old ADOdb diagnostic addon doesn't work in 5.5 I'm pretty sure so I had to punch up a new one real quick. It's not too fancy but it gives you a quick look at the heaviest queries flying around when trying to debug stuff.

You can grab it at my github
https://github.com/mkly/c5_addon_dbbbb...

And I attached a quick screen shot to this post to give you the idea

EDIT: Latest version available as a zip attached to the reply below
http://www.concrete5.org/community/forums/customizing_c5/dbbbb-sql-...

1 Attachment

mkly
 
JohntheFish replied on at Permalink Reply
JohntheFish
It looks interesting and useful.

Looking at the github, is it just a package controller that sets up stuff? Or is there more to it that I have missed?
Mainio replied on at Permalink Reply
Mainio
I think the dbbbb is meant to be package folder included in packages.

Thanks @mkly, this might come handy on some occasions!
mkly replied on at Permalink Best Answer Reply
mkly
Ya it's just a package controller. It's just the on_start() method and then uses the on_render_complete event

I just updated it to place everything in the package controller. If you look at the on_start() you'll see how it's basically a quick way to add and run events in a simple package without having to create extra files.
mhawke replied on at Permalink Reply
mhawke
Perhaps a dumb question that I should know the answer to but how do you get this to run? I have copied the controller.php to [root]/packages/dbbbb.

Now what?
mhawke replied on at Permalink Reply
mhawke
Never mind. I was over-thinking it.

For those who travel here in the future looking for wisdom, I put the controller.php file in the '[root]/packages/dbbbb' folder and just added 'define('DBBBB_DEBUG_ENABLED', true);' to my '[root]/config/site.php' file (like the readme says to do) and the magic just happens.

Perhaps one of the reasons C5 is slow sometimes is that it's busy searching for randomly placed controller.php files with on_start() functions to run. Pardon my ignorance on all things C5 but shouldn't a package have to be installed for it to be seen by C5?
mkly replied on at Permalink Reply
mkly
Glad to see you sorted it out.

I actually have these instructions on my github page

http://github.com/mkly/dbbbb

That said, @remo forked this and set it up for only logged in users with a button to show it or something like that.

I haven't tested it, but from looking at the code it looks pretty cool and you might want to check it out.

https://github.com/Remo/c5_addon_dbbbb...

Best Wishes,
Mike
mhawke replied on at Permalink Reply
mhawke
I think I must be using Remo's fork because I have a button in the bottom left that opens the report.

Thanks all. Very handy.
invision replied on at Permalink Reply
invision
I'm baffled-- can't seem to get this running.

I created a directory [root]/packages/dbbbb, copied 'controller.php' into it and added
define('DBBBB_DEBUG_ENABLED', true);


to my config/site.php

Yet I get nothing... Am I missing something here? Is the directory name case sensitive?
mkly replied on at Permalink Reply
mkly
I guess it's not really clear from all of this, but you actually need to install it in the dashboard.

Best Wishes,
mike
JohntheFish replied on at Permalink Reply
JohntheFish
Maybe this should be linked from the proposed projects page
http://www.concrete5.org/developers/pro-accounts/community-leaders-...

I have been using this on and off for a while, but it was only the last couple of posts reviving the thread that led me to Remo's button popup version.

Is there a reason you have not released this as a developer addon in the marketplace?
SunSlade replied on at Permalink Reply
SunSlade
Hi Mkly, just found out your addon and thougth it might help me out.

The only problem is that it doesn't seem to work anymore. when i click the button i get this error message:

Fatal error: Call to a member function SuspiciousSQL() on a non-object in H:\htdocs\packages\dbbbb\controller.php on line 141

Looking at the code it seems that $db = Loader::db() is not enough to create a NewPerfMonitor.

I'm running Conrete5 version 5.6.2.1, installed the package and added the line in config/site.php

Any advice to get this working would be greatly appreciated.
mkly replied on at Permalink Reply 1 Attachment
mkly
Indeed. Looks like with the new adodb updates I have to do a bit more to load it up. I've updated the git repository

https://github.com/mkly/c5_addon_dbbbb...

I've also attached the new version to this reply. Let me know if you run into any issues.

Best Wishes,
Mike
SunSlade replied on at Permalink Reply
SunSlade
Thanks Mike it works great!
mkly replied on at Permalink Reply
mkly
Glad to hear it.

Best Wishes,
Mike