Well, here is another strange thing: One of the statements is delete and that works without a transaction/commit but the insert needs transaction/commit to work.
On Sun, Jun 15, 2008 at 3:46 AM, Shekar C Reddy <[EMAIL PROTECTED]> wrote: > No, it uses the same db-adapter that is also used across all the app but > the app modules use the adapter wrapped with begin-transaction/commit > statements whereas the logger does not use transaction. I just tried > wrapping the log() method with begin-transaction/commit combo and now it > works! Don't know why and what got changed. I stabilized my logging logic > long time ago and never visited or modified it until now and it was working > fine. However, while applying the ZF updates I did not test the logging > code. Was wondering if it has anything to do with the ZF v1.5.1. > > > On Sun, Jun 15, 2008 at 2:03 AM, Carlton Gibson < > [EMAIL PROTECTED]> wrote: > >> >> On 15 Jun 2008, at 06:49, Shekar C Reddy wrote: >> >> I'm logging messages into an InnoDb table and I can see the return code >>> of 1 from the insert method and a valid lastInsertId of the autoincrement PK >>> column, too. But the data for some reason is missing in the table - even if >>> I abort the script right after the insert and go query the table, its empty! >>> I can insert data into the table manually using a GUI tool. What could be >>> the reason for the data inserted through Zend_Log but missing in the MySQL >>> table? Has anyone had similar problems before? Using ZF v1.5.1. >>> >> >> You're not automatically starting a transaction and then failing to commit >> it are you? >> > >