Author Topic: Error: Unknown column 'data5' in 'field list' with new qloader.  (Read 3145 times)

Gap

  • Newbie
  • *
  • Posts: 4
  • Karma: 0
    • View Profile
Hi.

 I had to change  my asterisk server for a new one. In the old was running Qloaderd 1.17. I installed qloaderd 1.22 using yum.

 When I started the qloaderd service i got this error.

 |Tue Jan 10 23:55:54 2012|Now connecting to DB queuemetrics on 10.1.12.69 as user queuemetrics with password javadude
E|Tue Jan 10 23:55:54 2012|---ERROR FOUND--
E|Tue Jan 10 23:55:54 2012|Error type: st
E|Tue Jan 10 23:55:54 2012| Statement:  INSERT INTO `queue_log`                 ( `partition` , `time_id` , `call_id` , `queue` , `agent` , `verb` , `data1` , `data2` , `data3` , `data4`, `data5` )                 VALUES                 ( 'P000', '1326254229', 'NONE', 'NONE', 'NONE', 'QUEUESTART', '', '', '', '', '' );
E|Tue Jan 10 23:55:54 2012|     Error: Unknown column 'data5' in 'field list'

 I have no data in the Queuemetrics.

 How can I solve it?
Thanks
 

Gap

  • Newbie
  • *
  • Posts: 4
  • Karma: 0
    • View Profile
Re: Error: Unknown column 'data5' in 'field list' with new qloader.
« Reply #1 on: January 16, 2012, 15:41:31 »
Solved.

 I  Just copy the file /usr/local/qloader/qloader.pl from the old asterisk with qloaderd 1.17 to the new one. And it works.

 :o

QueueMetrics

  • Loway
  • Hero Member
  • *
  • Posts: 2999
  • Karma: 39
    • View Profile
    • QueueMetrics
Re: Error: Unknown column 'data5' in 'field list' with new qloader.
« Reply #2 on: January 18, 2012, 17:41:00 »
Or create a new column "data5", as per QM 1.7+ default schema.