QueueMetrics > QueueMetrics installation

Error: Unknown column 'data5' in 'field list' with new qloader.

(1/1)

Gap:
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:
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:
Or create a new column "data5", as per QM 1.7+ default schema.

Navigation

[0] Message Index