Quick Database Logger Package
Permalink
I made a quick dashboard package which uses adodb's built in logging to help locate problematic db queries. I don't know if this will be able to get through the Marketplace(it would be free anyway) so I figure I'll put it here for right now.
I've only tested it a little bit so be warned you could break everything.
Also, I'm pretty sure I've created the best icon in the world on this one.
And remember to turn off the logging when you aren't using it or the logs will get out of control.
Feedback and patches greatly appreciated.
THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
I've only tested it a little bit so be warned you could break everything.
Also, I'm pretty sure I've created the best icon in the world on this one.
And remember to turn off the logging when you aren't using it or the logs will get out of control.
Feedback and patches greatly appreciated.
THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Oops forgot the file.
I take it this is not 5.5 compatible?
Gave me an internal server error (500).
Note to others, to restore site function comment out the lines added in /config/site_process.php or rename/remove the file.
Gave me an internal server error (500).
Note to others, to restore site function comment out the lines added in /config/site_process.php or rename/remove the file.
Hmm... possible it's not. It is probably pretty ugly if anything else. I never tested it for 5.5. I'll check it out and see. It's basically uses adodb's logging feature.
It will also create a new table in the database table named "adodb_logsql" so you will want to delete that too.
Also, it's now hosted on github here
https://github.com/mkly/c5_addon_quick_database_check...
It will also create a new table in the database table named "adodb_logsql" so you will want to delete that too.
Also, it's now hosted on github here
https://github.com/mkly/c5_addon_quick_database_check...
