Fixed code block.

Hi Andrew, I will look into your problem with exceptions. I must write a unit test.

{quote} tried to resolve this by extending Zend_Log_Writer_Db to override the _write method, but all of the properties are marked private instead of protected for some reason.{quote} This problem was fixed with ZF-12514. (Look at the diff)

Thanks for your help! :)

{quote} bq. tried to resolve this by extending Zend_Log_Writer_Db to override the _write method, but all of the properties are marked private instead of protected for some reason.

This problem was fixed with ZF-12514.{quote}

Thank you!

I was ultimately able to extend {{Zend_Log_Writer_Db}} in a way that works with the current version. I'm still not sure if this is the best way of handling things, but this is the class I came up with:

/**
 * @category   My
 * @package    My_Log
 * @subpackage Writer
 */
class My_Log_Writer_Db extends Zend_Log_Writer_Db
{

    /**
     * Relates database columns names to log data field keys.
     * 
     * THIS HAD TO BE COPIED TO THE SUBCLASS BECAUSE IT WAS DECLARED PRIVATE IN
     * THE PARENT CLASS AND I NEED IT IN THE OVERRIDDEN _write METHOD BELOW. 
     * 
     * @var null|array
     */
    private $_columnMap;
    
    /**
     * Class constructor
     * 
     * THIS HAD TO BE INCLUDED BECAUSE $db, $table AND $columnMap ALL  MAP TO 
     * PRIVATE PROPERTIES IN THE PARENT CLASS AND COULD NOT BE SET HERE.
     *
     * @param Zend_Db_Adapter $db   Database adapter instance
     * @param string $table         Log table in database
     * @param array $columnMap
     * @return void
     */
    public function __construct($db, $table, $columnMap = null)
    {
        
        // I NEED $columnMap IN THE OVERRIDDEN VERSION OF _write BELOW.
        $this->_columnMap = $columnMap;
        
        // PASS ALL THE PARAMETERS TO THE PARENT CLASS SO THEY CAN BE SET 
        // CORRECTLY WHERE _write IN THE PARENT CLASS CAN ACCESS THEM.
        parent::__construct($db, $table, $columnMap);
    }
    

    /**
     * Write a message to the log.
     * OVERWRITTEN: Safely converts any values in the $event to strings 
     *
     * @param  array  $event  event data
     * @return void
     * @throws Zend_Log_Exception
     */
    protected function _write($event)
    {

        foreach ($this->_columnMap as $columnName => $fieldKey) {
            
            $var = $event[$fieldKey];
                
            switch (true) {
                
                case ('message' == $fieldKey && ($var instanceof Exception)):
                    // Special handling if an exception was passed to the
                    // message.
                    
                    // Store only the exception message in 'message'.
                    
                    // If no 'info' key exists in the event, move the exception
                    // object (cast as a string) to that key.
                    
                    if (!array_key_exists('info', $event)) {
                        $event['info'] = (string) $var; 
                    }
                    $var = $var->getMessage();
                    break; 
                
                case (is_object($var) && method_exists($var, '__toString()')):
                    // The object can be typecast to a string.
                    // Fall through.
                case is_bool($var):
                case is_numeric($var):
                    $var = (string) $var;
                    break;
                    
                    
                case ($var instanceof DateTime):
                    // DateTime instances cannot be cast to a string.
                    // Format the date as an ISO 8601 string.
                    $var = $var->format('c');
                    break;

                case is_resource($var):
                case is_array($var):
                case is_object($var):
                    // The variable cannot be typecast to a string.
                    $var = Zend_Debug::dump($var, null, true);
                    break;

                case is_string($var):
                    // No action needed; included for completeness.
                    break;
                    
                default:
                    // Not sure what other types might need to be handled.

            }
                    
            $event[$fieldKey] = $var;
        }

        parent::_write($event);
    }
}

Hopefully this is useful to someone else.

This issue has been closed on Jira and moved to GitHub for issue tracking. To continue following the resolution of this issues, please visit: https://github.com/zendframework/zf1/issues/23