Erasing manually from vicidial_auto_calls table

[eijal]

Hi,
Everyday I always have to erase some records from the vicidial_auto_calls table, the kind of records to erase are:

Code: Select all

+--------------+-------------+--------------+--------+---------+--------------------+----------------------+-------------------------------------------------------------------------+------------+--------------+---------------------+-----------+----------+---------------------+----------+
| auto_call_id | server_ip   | campaign_id  | status | lead_id | uniqueid           | callerid             | channel                                                                 | phone_code | phone_number | call_time           | call_type | stage    | last_update_time    | alt_dial |
+--------------+-------------+--------------+--------+---------+--------------------+----------------------+-------------------------------------------------------------------------+------------+--------------+---------------------+-----------+----------+---------------------+----------+
|        43374 | 192.168.2.5 | CL_AGENTES_L | CLOSER |  304699 | 1184258650.4719801 | J0712124335000304699 | Local/90009*CL_AGENTES_L*CXFER*304699**6202750455*51302*@default-d4b9,2 | 1          | 6202750455   | 2007-07-12 12:43:35 | IN        | CLOSER-0 | 2007-07-12 12:44:11 | NONE     |
|        43941 | 192.168.2.5 | CL_AGENTES_L | CLOSER |  279921 | 1184259411.5020199 | J0712125629000279921 | Local/90009*CL_AGENTES_L*CXFER*279921**8474371004*51326*@default-791a,2 | 1          | 8474371004   | 2007-07-12 12:56:29 | IN        | CLOSER-0 | 2007-07-12 12:56:52 | NONE     |
|        44033 | 192.168.2.5 | CL_AGENTES_L | CLOSER |  305077 | 1184259713.5117099 | J0712125841000305077 | Local/90009*CL_AGENTES_L*CXFER*305077**6202772146*51349*@default-8830,2 | 1          | 6202772146   | 2007-07-12 12:58:41 | IN        | CLOSER-0 | 2007-07-12 13:01:54 | NONE     |
+--------------+-------------+--------------+--------+---------+--------------------+----------------------+-------------------------------------------------------------------------+------------+--------------+---------------------+-----------+----------+---------------------+----------+
3 rows in set (0.00 sec)



I have using vicidial 2.0.3 in one machine together with asterisk, and in another server is the DataBase and Web Server.
As you can see, the records to erase are from de CLOSER campaign. Maybe I am missing some parameter.

THANKs

[mflorell]

That is very interesting. I have not seen that before, could you post this to the issue tracker along with how you are doing CLOSER transfers and any relevent extensions.conf entries?