[fw-general] logging offending queries

2008-12-03 Thread Ralikwen
Hi, is there a generic way to log all database calls from ZF? Or log all db errors? I know that I can use the profiler - I use it with Firebug and it works nicely with successful queries - but gives me no help when a db error occurs. When a db error occurs I would like to see the offending

Re: [fw-general] logging offending queries

2008-12-03 Thread Daniel Latter
Hi, Just an idea but you could have a base class (maybe extend Zend_Db_Table) and put some custom code in here that does the logging, that way you would only have to add the logging code in one place. just my 2p Thank You Daniel Latter 2008/12/2 Ralikwen [EMAIL PROTECTED]: Hi, is there a

Re: [fw-general] logging offending queries

2008-12-03 Thread Tim Nagel
Have you looked at the Zend_Db profiler? We use it to log queries to FirePHP. T On Thu, Dec 4, 2008 at 02:25, Daniel Latter [EMAIL PROTECTED] wrote: Hi, Just an idea but you could have a base class (maybe extend Zend_Db_Table) and put some custom code in here that does the logging, that

Re: [fw-general] logging offending queries

2008-12-03 Thread Ralikwen
You mean : Zend_Db_Profiler_Firebug('All DB Queries') ? Yes, I did try that and I thought wow, fantastic, but it seems to me that it only logs successful queries so e.g. queries with a syntax error would not get logged - which would be logical for a profiler that needs start and end time. Tim

Re: [fw-general] logging offending queries

2008-12-03 Thread till
On Wed, Dec 3, 2008 at 11:58 PM, Ralikwen [EMAIL PROTECTED] wrote: You mean : Zend_Db_Profiler_Firebug('All DB Queries') ? Yes, I did try that and I thought wow, fantastic, but it seems to me that it only logs successful queries so e.g. queries with a syntax error would not get logged - which