A lunch break and some much needed italian coffee and I was ready for some really boring debugging...
Short answer is that utf8 characters are tricky inside serialized strings. The string was utf8_decoded for SOAP but that caused the problems when trying to save that string to the log-table. Re-encoding it before saving the log fixed the problem. I am not sure why so if anyone know this stuff by heart, please share. :) /Martin On Apr 22, 11:41 am, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > Hi, > I have a bit of a strange one. It has been bugging me for hours now > and I am at the end of my rope. > > I have a model that is used to log soap calls. Fields consist of an > id, a few strings and two serialized arrays stored in "text" fields. > One of the serialized fields reach the database as it should while the > other remains "NULL" in MySQL. > > Things that did not work: > I thought it was too long and changed it to "longtext". > I thought I had made a mistake in beforeSave (where I serialize) but > no (debug tells me the data array looks correct). > I tried renaming the field from data to info. > > Things that are strange: > Looking at the SQL debug reveals a missing sql statement. The one > where I would expect an insert. > I.E. I get: > 16 SELECT something... > 17 > 18 SELECT LAST_INSERT_ID() AS insertID > > The record pops up and everything is there except this one serialized > field. The other serialized field is inserted OK. > > My Model array is included below... modified to remove sensitive data. > Is anything here unsupported by by something that does not spit out > any errors? The only difference I can find between the two serialized > arrays is that the malfunctioning one contains #NULL# as values in > some fields. > > Any hints would really save my day. > regards > Martin > > Array > ( > [Outgoing] => Array > ( > [responseCode] => 0 > [dataId] => 1234-5678 > [response] => Array > ( > [sessionid] => 1234:20080422113202 > [dataId] => 1234-5678 > [responseCode] => 0 > [responseMessage] => Success > ) > > [data] => Array > ( > [sessionid] => 1234:20080422113202 > [parameter1] => 12345 > [parameter2] => 0 > [dataHeader] => #NULL# > [DCS] => -1 > [PID] => -1 > [parameter3] => -1 > [parameter4] => #NULL# > [parameter5] => 0 > [parameter6] => #NULL# > ... and a few more ... > ) > > [module_id] => 5 > [modified] => 2008-04-22 11:32:02 > [created] => 2008-04-22 11:32:02 > ) > > ) --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to cake-php@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
