marcelog / AsterTrace

Capture everything happening in your asterisk server and log it to mysql. Calls, DTMF's, generic events, etc
http://marcelog.github.com
Apache License 2.0
43 stars 13 forks source link

event's column in event's table not complete serialized #4

Open ALYREZA opened 9 years ago

ALYREZA commented 9 years ago

Hi, when I retrieve event's data form event's table and then unserialize it. it's not completed and I can not get the value of for example keys Array. how can I fix it ? :)

event's column var_dump() is something like this :

object(__PHP_Incomplete_Class)[3]
  public '__PHP_Incomplete_Class_Name' => string 'PAMI\Message\Event\NewextenEvent' (length=32)
  protected 'lines' => 
    array (size=0)
      empty
  protected 'variables' => 
    array (size=0)
      empty
  protected 'keys' => 
    array (size=9)
      'event' => string 'Newexten' (length=8)
      'privilege' => string 'dialplan,all' (length=12)
      'channel' => string 'DAHDI/9-1' (length=9)
      'context' => string 'macro-dial-one' (length=14)
      'extension' => string 's' (length=1)
      'priority' => string '10' (length=2)
      'application' => string 'Set' (length=3)
      'appdata' => string 'EXTHASCW=ENABLED' (length=16)
      'uniqueid' => string '1442388421.3211' (length=15)
  protected 'createdDate' => int 1442388866
  protected 'rawContent' => string 'Event: Newexten
Privilege: dialplan,all
Channel: DAHDI/9-1
Context: macro-dial-one
Extension: s
Priority: 10
Application: Set
AppData: EXTHASCW=ENABLED
Uniqueid: 1442388421.3211' (length=185)
marcelog commented 9 years ago

Hello,

Try to increase the column size, perhaps to MEDIUMTEXT or LONGTEXT: http://boolean.co.nz/blog/max-length-for-mysql-text-field-types/135/