rewriting vicidial_agent_log las register

[telconetcol]

I am dialing in manuñ mode with preview. Majority of times I dial a lead, afte having dispo i look in the database (table vicidial_agent_log) an the als record is overwritten.

In the database i cann´t see the insert into the table.


INSERT INTO vicidial_agent_log (user,server_ip,event_time,campaign_id,pause_epoch,pause_sec,wait_epoch,user_group,sub_status) values('ag10c1','192.168.0.190','2008-12-12 20:12:39','OUT003','1229130759','0','1229130759','Agentes0','LOGIN');
UPDATE vicidial_agent_log set lead_id='290',comments='MANUAL' where agent_log_id='11637';
UPDATE vicidial_agent_log set wait_sec='62',wait_epoch='1229130821',talk_epoch='1229130821',lead_id='290' where agent_log_id='11637';
UPDATE vicidial_agent_log set talk_sec='6',dispo_epoch='1229130827' where agent_log_id='11637';
UPDATE vicidial_agent_log set dispo_sec='7',status='A' where agent_log_id='11637';
UPDATE vicidial_agent_log set lead_id='291',comments='MANUAL' where agent_log_id='11637';
UPDATE vicidial_agent_log set wait_sec='297',wait_epoch='1229131056',talk_epoch='1229131056',lead_id='291' where agent_log_id='11637';
UPDATE vicidial_agent_log set talk_sec='20',dispo_epoch='1229131070' where agent_log_id='11637';
UPDATE vicidial_agent_log set dispo_sec='11',status='B' where agent_log_id='11637';
UPDATE vicidial_agent_log set pause_sec='863',wait_epoch='1229131622' where agent_log_id='11637';
INSERT INTO vicidial_agent_log (user,server_ip,event_time,campaign_id,pause_epoch,pause_sec,wait_epoch,user_group,sub_status) values('ag10c1','192.168.0.190','2008-12-12 20:27:08','OUT003','1229131628','0','1229131628','Agentes0','LOGIN');
UPDATE vicidial_agent_log set lead_id='292',comments='MANUAL' where agent_log_id='11638';
UPDATE vicidial_agent_log set dispo_sec='1229131683',status='CL' ,dispo_epoch='1229131683' where agent_log_id='11638';
UPDATE vicidial_agent_log set lead_id='293',comments='MANUAL' where agent_log_id='11638';
UPDATE vicidial_agent_log set wait_sec='159',wait_epoch='1229131787',talk_epoch='1229131787',lead_id='293' where agent_log_id='11638';
UPDATE vicidial_agent_log set talk_sec='8',dispo_epoch='1229131795' where agent_log_id='11638';
UPDATE vicidial_agent_log set dispo_sec='65538',status='SALE' where agent_log_id='11638';
root@call1:/usr/local/mysql/var# mysqlbinlog --start-datetime='2008-12-12 20:10:00' call1-bin.081 | grep vicidial_agent_log
INSERT INTO vicidial_agent_log (user,server_ip,event_time,campaign_id,pause_epoch,pause_sec,wait_epoch,user_group,sub_status) values('ag10c1','192.168.0.190','2008-12-12 20:12:39','OUT003','1229130759','0','1229130759','Agentes0','LOGIN');
UPDATE vicidial_agent_log set lead_id='290',comments='MANUAL' where agent_log_id='11637';
UPDATE vicidial_agent_log set wait_sec='62',wait_epoch='1229130821',talk_epoch='1229130821',lead_id='290' where agent_log_id='11637';
UPDATE vicidial_agent_log set talk_sec='6',dispo_epoch='1229130827' where agent_log_id='11637';
UPDATE vicidial_agent_log set dispo_sec='7',status='A' where agent_log_id='11637';
UPDATE vicidial_agent_log set lead_id='291',comments='MANUAL' where agent_log_id='11637';
UPDATE vicidial_agent_log set wait_sec='297',wait_epoch='1229131056',talk_epoch='1229131056',lead_id='291' where agent_log_id='11637';
UPDATE vicidial_agent_log set talk_sec='20',dispo_epoch='1229131070' where agent_log_id='11637';
UPDATE vicidial_agent_log set dispo_sec='11',status='B' where agent_log_id='11637';
UPDATE vicidial_agent_log set pause_sec='863',wait_epoch='1229131622' where agent_log_id='11637';
INSERT INTO vicidial_agent_log (user,server_ip,event_time,campaign_id,pause_epoch,pause_sec,wait_epoch,user_group,sub_status) values('ag10c1','192.168.0.190','2008-12-12 20:27:08','OUT003','1229131628','0','1229131628','Agentes0','LOGIN');
UPDATE vicidial_agent_log set lead_id='292',comments='MANUAL' where agent_log_id='11638';
UPDATE vicidial_agent_log set dispo_sec='1229131683',status='CL' ,dispo_epoch='1229131683' where agent_log_id='11638';
UPDATE vicidial_agent_log set lead_id='293',comments='MANUAL' where agent_log_id='11638';
UPDATE vicidial_agent_log set wait_sec='159',wait_epoch='1229131787',talk_epoch='1229131787',lead_id='293' where agent_log_id='11638';
UPDATE vicidial_agent_log set talk_sec='8',dispo_epoch='1229131795' where agent_log_id='11638';
UPDATE vicidial_agent_log set dispo_sec='65538',status='SALE' where agent_log_id='11638';
UPDATE vicidial_agent_log set lead_id='294',comments='MANUAL' where agent_log_id='11638';
UPDATE vicidial_agent_log set wait_sec='223',wait_epoch='1229131851',talk_epoch='1229131851',lead_id='294' where agent_log_id='11638';
UPDATE vicidial_agent_log set talk_sec='16',dispo_epoch='1229131859' where agent_log_id='11638';
UPDATE vicidial_agent_log set dispo_sec='65539',status='DEC' where agent_log_id='11638';

the result is that i cann´t have got the performance agent reports... and all the reports....that includes this table.

VERSION: 2.0.5-188 BUILD: 81124-2213

[mflorell]

Try upgrading to most recent SVN trunk.