I need helping! recording_log is duplication!

Any and all non-support discussions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

I need helping! recording_log is duplication!

Postby mdys » Wed Nov 13, 2013 9:31 pm

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!
GoAutoDial CE 2.0 | Vicidial 2.2.1-237 Build 100510-2015 | Asterisk 1.4.27.1-1 | Web/DB Server & PBX running GoAutoDial | Sangoma UT50 | Installed: wanpipe-voicetime drivers 1.0.11
mdys
 
Posts: 25
Joined: Mon Nov 04, 2013 6:36 am

Re: I need helping! recording_log is duplication!

Postby williamconley » Wed Nov 13, 2013 9:39 pm

Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: I need helping! recording_log is duplication!

Postby mdys » Wed Nov 13, 2013 9:48 pm

williamconley wrote: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!
GoAutoDial CE 2.0 | Vicidial 2.2.1-237 Build 100510-2015 | Asterisk 1.4.27.1-1 | Web/DB Server & PBX running GoAutoDial | Sangoma UT50 | Installed: wanpipe-voicetime drivers 1.0.11
mdys
 
Posts: 25
Joined: Mon Nov 04, 2013 6:36 am

Re: I need helping! recording_log is duplication!

Postby williamconley » Wed Nov 13, 2013 10:16 pm

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.
Vicidial Installation and Repair, plus Hosting and Colocation
Newest Product: Vicidial Agent Only Beep - Beta
http://www.PoundTeam.com # 352-269-0000 # +44(203) 769-2294
williamconley
 
Posts: 20018
Joined: Wed Oct 31, 2007 4:17 pm
Location: Davenport, FL (By Disney!)

Re: I need helping! recording_log is duplication!

Postby mdys » Thu Nov 14, 2013 3:11 am

williamconley wrote: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!
GoAutoDial CE 2.0 | Vicidial 2.2.1-237 Build 100510-2015 | Asterisk 1.4.27.1-1 | Web/DB Server & PBX running GoAutoDial | Sangoma UT50 | Installed: wanpipe-voicetime drivers 1.0.11
mdys
 
Posts: 25
Joined: Mon Nov 04, 2013 6:36 am


Return to General Discussion

Who is online

Users browsing this forum: No registered users and 59 guests