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-...
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-...
I think the dbbbb is meant to be package folder included in packages.
Thanks @mkly, this might come handy on some occasions!
Thanks @mkly, this might come handy on some occasions!
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.
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.
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?
Now what?
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?
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?
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
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
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.
Thanks all. Very handy.
I'm baffled-- can't seem to get this running.
I created a directory [root]/packages/dbbbb, copied 'controller.php' into it and added
to my config/site.php
Yet I get nothing... Am I missing something here? Is the directory name case sensitive?
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?
I guess it's not really clear from all of this, but you actually need to install it in the dashboard.
Best Wishes,
mike
Best Wishes,
mike
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?
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?
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.
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.
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
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
Thanks Mike it works great!
Glad to hear it.
Best Wishes,
Mike
Best Wishes,
Mike
Looking at the github, is it just a package controller that sets up stuff? Or is there more to it that I have missed?