Author Topic: Upgrading realtime queue_log from 1.6 to 1.8  (Read 2829 times)

trymes

  • Jr. Member
  • **
  • Posts: 84
  • Karma: 0
    • View Profile
Upgrading realtime queue_log from 1.6 to 1.8
« on: February 27, 2012, 18:02:24 »
Has anyone come up with a good method to upgrade the realtime queue_log table from 1.6 to the 1.8 format?

I believe that QM is ready to go with Realtime Queue Log and Asterisk 1.8, but my table is not!

Many thanks,

Tom

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: Upgrading realtime queue_log from 1.6 to 1.8
« Reply #1 on: March 02, 2012, 09:00:56 »
From http://dev.mysql.com/doc/refman/5.0/en/string-functions.html :

"MySQL does not include a function to split a delimited string. "

So you would need some string black magic to separate the data field in its parts - or export to SQL and edit the SQL script using a macro or something.....