No data is inserted in the table vicidial_log

[hvite]

Friends
When the officers placed the status of the call, some calls are not inserted into the table vicidial_log only be inserted into the table and table vicidial_list recording_log the call history.
What can occasion to happen?

The version of VICIDIAL is:
VERSION: 2.0.5-173
BUILD: 90320-0424

The version de mysql is 5.1.46

[williamconley]

give an example of a call that was in recording_log and vicidial_list but not in vicidial_log (copy and paste a few examples, describe the call path and circumstances, use XXXXXXXXX to represent the phone number, of course).
_______

when you post, please post your entire configuration including (but not limited to) your installation method and vicidial version with build.


this IS a requirement for posting along with reading the stickies (at the top of each forum) and the manager's manual (available on EFLO.net, both free and paid versions)

You should also post: Asterisk version, telephony hardware (model number is helpful here), cluster information if you have one, and whether any other software is installed in the box. If your installation method is "from scratch" you must post your operating system and should also post the .iso version from which you installed your original operating system.

Similar to This:
Vicibox X.X from .iso | Vicidial X.X.X Build XXXX | Asterisk X.X.X | Single Server | No Digium/Sangoma Hardware | No Extra Software After Installation

[hvite]

Ok William

This is a example:

mysql> SELECT * FROM vicidial_list WHERE lead_id=793909;
+---------+---------------------+---------------------+--------+------+------------------+-----------+---------+----------------+-------------------------+------------+--------------+-------+------------+----------------+-----------+----------+----------+----------+------+-------+----------+-------------+--------------+--------+---------------+-----------+------------+-----------------+----------+--------------+----------------------+
| lead_id | entry_date | modify_date | status | user | vendor_lead_code | source_id | list_id | gmt_offset_now | called_since_last_reset | phone_code | phone_number | title | first_name | middle_initial | last_name | address1 | address2 | address3 | city | state | province | postal_code | country_code | gender | date_of_birth | alt_phone | email | security_phrase | comments | called_count | last_local_call_time |
+---------+---------------------+---------------------+--------+------+------------------+-----------+---------+----------------+-------------------------+------------+--------------+-------+------------+----------------+-----------+----------+----------+----------+------+-------+----------+-------------+--------------+--------+---------------+-----------+------------+-----------------+----------+--------------+----------------------+
| 793909 | 2010-11-22 00:00:00 | 2010-11-24 07:07:13 | N | 2787 | | NULL | 791 | -5.00 | Y | NULL | 66666666 | | | | | | | | | | | 5966 | | U | 0000-00-00 | |XXXXXXXXXXX | 66666666 | | 1 | 2010-11-24 07:06:57 |
+---------+---------------------+---------------------+--------+------+------------------+-----------+---------+----------------+-------------------------+------------+--------------+-------+------------+----------------+-----------+----------+----------+----------+------+-------+----------+-------------+--------------+--------+---------------+-----------+------------+-----------------+----------+--------------+----------------------+
1 row in set (0.00 sec)

mysql> SELECT * FROM vicidial_log WHERE lead_id=793909;
Empty set (0.00 sec)

mysql> SELECT * FROM recording_log WHERE lead_id=793909;
+--------------+------------------------+-------------+-----------+---------------------+-------------+---------------------+------------+---------------+---------------+---------------------------------------+----------+---------+------+-------------------+
| recording_id | channel | server_ip | extension | start_time | start_epoch | end_time | end_epoch | length_in_sec | length_in_min | filename | location | lead_id | user | vicidial_id |
+--------------+------------------------+-------------+-----------+---------------------+-------------+---------------------+------------+---------------+---------------+---------------------------------------+----------+---------+------+-------------------+
| 947880 | Local/58600051@default | 192.168.0.9 | 8310 | 2010-11-24 07:06:59 | 1290600419 | 2010-11-24 07:18:48 | 1290601128 | 709 | 11.82 | ABCDEFGH_20101124-070658_5555555_2787 | NULL | 793909 | 2787 | 1290600434.390165 |
+--------------+------------------------+-------------+-----------+---------------------+-------------+---------------------+------------+---------------+---------------+---------------------------------------+----------+---------+------+-------------------+
1 row in set (0.00 sec)

mysql>

Vicibox X.X from .iso | Vicidial X.X.X Build XXXX | Asterisk X.X.X | Single Server | No Digium/Sangoma Hardware | No Extra Software After Installation

Data:
Vicidial 2.0.5-173 BUILD: 90320-0424 | asterisk 1.2.24 | Many Sever | Sip Trunk | No extra Software after Instalacion

[williamconley]

your installation method

?

was this call inbound or outbound?

Is there a reason you aren't using a more recent version? (You are at 2.0.5, the present release is 2.2.1 and 2.4 is approaching release ...)