Zend Framework -> Zend_Log via application.ini => insert() on a non-object error

Question

I am trying to get logging via the application.ini file going and I am getting stuck with an error.

resources.log.db.writerName = "Db"
resources.log.db.writerParams.db.adapter = "PDO_SQLITE"
resources.log.db.writerParams.db.dbname = ROOT "/data/tmp.db3"
resources.log.db.writerParams.db.table = "logs"
resources.log.db.writerParams.db.columnMap.priority = "priority"
resources.log.db.writerParams.db.columnMap.message  = "message"

Fatal error: Call to a member function insert() on a non-object in /var/www/libs/zend/library/Zend/Log/Writer/Db.php on line 137

Answer 1

You cannot instantiate a Database Logger from an Ini configuration yet.

Either setup the Logger in your Bootstrap within an _initLog method or extend the regular Zend_Log class to use the default DB adapter or better, to instantiate, the DB adapter given in the application.ini.

See here:

• http://stackoverflow.com/questions/1968253/zend-log-in-application-ini

---

And in case you are interested why it doesn't work from application.ini:

The Log Resource Plugin will call the Zend_Log::factory Method, which in turn will check the Writer you defined and then call this Writer's factory method to create a new Writer instance. But Zend_Log_Writer_Db expects the first argument to it's constructor to be a Zend_Db_Adapter instance, but it will not enforce it.

You cannot supply an instance from the ini file. The writer will check if the _db property is set when you try to write and throw an exception when it's null. But you supplied a string for the property, so _db is not null and it won't throw. Instead, when trying to write your writer will $this->_db->insert(), causing the error, because _db should be the missing Zend_Db_Adapter, but is a string, e.g. a non-object.

See the factory() and _write() method for details:

• http://framework.zend.com/svn/framework/standard/trunk/library/Zend/Log/Writer/Db.php

Answer 2

I submitted a fix here: http://framework.zend.com/issues/browse/ZF-9497