I need helping! recording_log is duplication!

[mdys]

I query recording_log table query recording, but found vicidial_id and lead_id is duplicate data records,
the campaign_recording is ALLFORCE

for example:

Code: Select all

mysql> select a.uniqueid,a.lead_id,a.user,b.user,b.vicidial_id,b.lead_id,a.phone_number,b.filename,a.call_date,b.start_time from vicidial_log a inner join recording_log b on a.uniqueid=b.vicidial_id and a.lead_id=b.lead_id where a.call_date BETWEEN '2013-11-08 00:00:01' and '2013-11-08 23:00:01' and a.uniqueid='1383870423.489';
+----------------+---------+------+------+----------------+---------+--------------+-----------------------------+---------------------+---------------------+
| uniqueid       | lead_id | user | user | vicidial_id    | lead_id | phone_number | filename                    | call_date           | start_time          |
+----------------+---------+------+------+----------------+---------+--------------+-----------------------------+---------------------+---------------------+
| 1383870423.489 | 4626372 | 8083 | 8083 | 1383870423.489 | 4626372 | 13721554090  | 20131108-082731_18208603400 | 2013-11-08 08:27:39 | 2013-11-08 08:27:32 |
| 1383870423.489 | 4626372 | 8083 | 8083 | 1383870423.489 | 4626372 | 13721554090  | 20131108-082740_13721554090 | 2013-11-08 08:27:39 | 2013-11-08 08:27:41 |
+----------------+---------+------+------+----------------+---------+--------------+-----------------------------+---------------------+---------------------+
2 rows in set (0.01 sec)



filename=20131108-082740_13721554090 is right!
filename=20131108-082731_18208603400 is wrong!
recording_log table has two data vicidial_id = 1383870423.489

vicidial_log and recording_log data records should be a unique value!~
That can help me solve? Thanks!

[williamconley]

Please do not double-post.

viewtopic.php?f=7&t=31704&p=107359#p107359

[mdys]

Please do not double-post.

viewtopic.php?f=7&t=31704&p=107359#p107359

I'm very sorry, because the posts no one to help me solve this problem! I am very anxious! Can you help me？thanks!

[williamconley]

I have only so many hours my employer will let me spend on this site doing cool free stuff. I work the unhelped and in-progress to the best of my ability, but I can't always get to all posts. Adding another post doesn't put you above the others, sorry. Just makes me take time out to say "don't double post" which reduces the amount of time I have to "help!" others. If I get to you in the stack, I'll help. If not, hopefully someone else will. But I'll have to go back to my "day-job" momentarily.

[mdys]

I have only so many hours my employer will let me spend on this site doing cool free stuff. I work the unhelped and in-progress to the best of my ability, but I can't always get to all posts. Adding another post doesn't put you above the others, sorry. Just makes me take time out to say "don't double post" which reduces the amount of time I have to "help!" others. If I get to you in the stack, I'll help. If not, hopefully someone else will. But I'll have to go back to my "day-job" momentarily.

Oh! I'm very sorry for the delay time! You can first deal with your work! Do not have to worry about! I have tried to solve this problem! Thank you very much!