by ivschakravarthi » Mon Apr 29, 2013 7:39 am
Hello,
Vicidial 2.2.1 ,asterisk 1.4.15,single server, Centos5.5 ,No telephony card,No cluster
We have an inbound setup and i have observed queue_seconds in vicidial_closer_log table [queue time] as zero seconds even though queued_position is greater than 0 i.e.,call has been entered into the queue.
When i went to the agi logs i have seen the update command of queue seconds as
"update vicidial_closer_log set queue_seconds='87' where lead_id='xxx' and call_date='2013-04-28 10:03:57'
But in the vicidial_closer_log table the particular lead_id is inserted with the call_date 2013-04-28 10:03:58 where there is 1 second difference and due to which the update command from the AGI got executed which zero records effected and queue time is not updated.
I have around 1000 calls out of 10,000 calls which the above scenario.
Is it ok if i change the update command in the AGI such that it will update the queue seconds only on basis of lead id?
update vicidial_closer_log set queue_seconds='87' where lead_id='xxx'
Will it effect any thing else?