vicidial.org

VICIDIAL astGUIclient discussion forum
http://forum.eflo.net/VICIDIALforum/

list mixing...

http://forum.eflo.net/VICIDIALforum/viewtopic.php?f=2&t=11214

Page 1 of 1

list mixing...

PostPosted: Mon Apr 26, 2010 3:23 pm
by ruben23
Hi, anyone used list mixing.., tried using it but the problem is when i add up my list ID and make priorities and also the method, as i apply it to a particular campaign and activate it, i was not able to view any leads in the hopper.. even i force reset it.

My setup is this.

VERSION: 2.2.0-234
BUILD: 100116-0718
Asterisk 1.4.21-vici

PostPosted: Mon Apr 26, 2010 4:51 pm
by mflorell
Post results of the AST_VDhopper.pl --debugX

PostPosted: Mon Apr 26, 2010 7:19 pm
by ruben23
@ Matt

This is the output:

Code: Select all
root@Gatewayx:~# /usr/share/astguiclient/AST_VDhopper.pl --debugX

----- DEBUG -----


----- SUPER DEBUG -----

TIME DEBUG: -5|-5|0|   GMT: 13:18
SELECT list_id FROM vicidial_lists where active='N';Inactive Lists:  111
Inactive List Leads Deleted:  0E0 |DELETE from vicidial_hopper where list_id IN('999','998','1000','1002','1003','1004','1005','2000','2001','2002','1014','104','105','106','107','108','109','110','111','112','1007','113','200','201','202','203','204','205','206','207','208','209','300','210','301','302','303','304','305','306','307','308','1008','2004','2005','1009','1010','1011','1012','1013','1015','1016','1017','1018','1019','1020','2003','2006','2007','2008','2009','2010','2011','2012','2013','2014','2015','2016','2017','2018','2019','1021','2020','1022','2021','1023','2022','1024','2024','2025','2026','2027','2029','1025','1026','1027','1028','1029','1030','1031','1032','1034','1035','1036','1037','1038','1039','1040','1041','1042','2030','1043','2031','10000','10002','1045','1046','1047','2032','1048','2033');|
CALLBACK HOLD: 170|SELECT count(*) FROM vicidial_callbacks where callback_time <= '2010-04-27 08:18:11' and status='ACTIVE';|
     hopper DNC count:   0
     |SELECT count(*) from vicidial_hopper where status='DNC';|
CAMPAIGNS TO PROCESSES HOPPER FOR:  8|7

   |GMT-DAY-HOUR|   |13.00-3-218||12.75-3-203||12.50-3-148||12.25-3-133||12.00-3-118||11.75-3-103||11.50-3-48||11.25-3-33||11.00-3-18||10.75-3-3||10.50-2-2348||10.25-2-2333||10.00-2-2318||9.75-2-2303||9.50-2-2248||9.25-2-2233||9.00-2-2218||8.75-2-2203||8.50-2-2148||8.25-2-2133||8.00-2-2118||7.75-2-2103||7.50-2-2048||7.25-2-2033||7.00-2-2018||6.75-2-2003||6.50-2-1948||6.25-2-1933||6.00-2-1918||5.75-2-1903||5.50-2-1848||5.25-2-1833||5.00-2-1818||4.75-2-1803||4.50-2-1748||4.25-2-1733||4.00-2-1718||3.75-2-1703||3.50-2-1648||3.25-2-1633||3.00-2-1618||2.75-2-1603||2.50-2-1548||2.25-2-1533||2.00-2-1518||1.75-2-1503||1.50-2-1448||1.25-2-1433||1.00-2-1418||0.75-2-1403||0.50-2-1348||0.25-2-1333||0.00-2-1318||-0.25-2-1303||-0.50-2-1248||-0.75-2-1233||-1.00-2-1218||-1.25-2-1203||-1.50-2-1148||-1.75-2-1133||-2.00-2-1118||-2.25-2-1103||-2.50-2-1048||-2.75-2-1033||-3.00-2-1018||-3.25-2-1003||-3.50-2-948||-3.75-2-933||-4.00-2-918||-4.25-2-903||-4.50-2-848||-4.75-2-833||-5.00-2-818||-5.25-2-803||-5.50-2-748||-5.75-2-733||-6.00-2-718||-6.25-2-703||-6.50-2-648||-6.75-2-633||-7.00-2-618||-7.25-2-603||-7.50-2-548||-7.75-2-533||-8.00-2-518||-8.25-2-503||-8.50-2-448||-8.75-2-433||-9.00-2-418||-9.25-2-403||-9.50-2-348||-9.75-2-333||-10.00-2-318||-10.25-2-303||-10.50-2-248||-10.75-2-233||-11.00-2-218||-11.25-2-203||-11.50-2-148||-11.75-2-133||-12.00-2-118||-12.25-2-103||-12.50-2-48||-12.75-2-33|
   |SELECT call_time_id,call_time_name,call_time_comments,ct_default_start,ct_default_stop,ct_sunday_start,ct_sunday_stop,ct_monday_start,ct_monday_stop,ct_tuesday_start,ct_tuesday_stop,ct_wednesday_start,ct_wednesday_stop,ct_thursday_start,ct_thursday_stop,ct_friday_start,ct_friday_stop,ct_saturday_start,ct_saturday_stop,ct_state_call_times FROM vicidial_call_times where call_time_id='24hours';|
LocalCallTime No-Call Gap: |0|2400(24 00)|0000(00 00)|2|1|
Starting hopper run for TITAN campaign- GMT: 24hours   HOPPER: 200   ORDER: DOWN
     hopper DONE cleared:  0E0
     |DELETE from vicidial_hopper where campaign_id='TITAN' and status IN('DONE');|
     hopper GMT BAD cleared:  0E0
     |DELETE from vicidial_hopper where campaign_id='TITAN' and ((gmt_offset_now IN('99') ) );|
     hopper READY count:   266
     |SELECT count(*) from vicidial_hopper where campaign_id='TITAN' and status='READY';|

   |GMT-DAY-HOUR|   |13.00-3-218||12.75-3-203||12.50-3-148||12.25-3-133||12.00-3-118||11.75-3-103||11.50-3-48||11.25-3-33||11.00-3-18||10.75-3-3||10.50-2-2348||10.25-2-2333||10.00-2-2318||9.75-2-2303||9.50-2-2248||9.25-2-2233||9.00-2-2218||8.75-2-2203||8.50-2-2148||8.25-2-2133||8.00-2-2118||7.75-2-2103||7.50-2-2048||7.25-2-2033||7.00-2-2018||6.75-2-2003||6.50-2-1948||6.25-2-1933||6.00-2-1918||5.75-2-1903||5.50-2-1848||5.25-2-1833||5.00-2-1818||4.75-2-1803||4.50-2-1748||4.25-2-1733||4.00-2-1718||3.75-2-1703||3.50-2-1648||3.25-2-1633||3.00-2-1618||2.75-2-1603||2.50-2-1548||2.25-2-1533||2.00-2-1518||1.75-2-1503||1.50-2-1448||1.25-2-1433||1.00-2-1418||0.75-2-1403||0.50-2-1348||0.25-2-1333||0.00-2-1318||-0.25-2-1303||-0.50-2-1248||-0.75-2-1233||-1.00-2-1218||-1.25-2-1203||-1.50-2-1148||-1.75-2-1133||-2.00-2-1118||-2.25-2-1103||-2.50-2-1048||-2.75-2-1033||-3.00-2-1018||-3.25-2-1003||-3.50-2-948||-3.75-2-933||-4.00-2-918||-4.25-2-903||-4.50-2-848||-4.75-2-833||-5.00-2-818||-5.25-2-803||-5.50-2-748||-5.75-2-733||-6.00-2-718||-6.25-2-703||-6.50-2-648||-6.75-2-633||-7.00-2-618||-7.25-2-603||-7.50-2-548||-7.75-2-533||-8.00-2-518||-8.25-2-503||-8.50-2-448||-8.75-2-433||-9.00-2-418||-9.25-2-403||-9.50-2-348||-9.75-2-333||-10.00-2-318||-10.25-2-303||-10.50-2-248||-10.75-2-233||-11.00-2-218||-11.25-2-203||-11.50-2-148||-11.75-2-133||-12.00-2-118||-12.25-2-103||-12.50-2-48||-12.75-2-33|
   |SELECT call_time_id,call_time_name,call_time_comments,ct_default_start,ct_default_stop,ct_sunday_start,ct_sunday_stop,ct_monday_start,ct_monday_stop,ct_tuesday_start,ct_tuesday_stop,ct_wednesday_start,ct_wednesday_stop,ct_thursday_start,ct_thursday_stop,ct_friday_start,ct_friday_stop,ct_saturday_start,ct_saturday_stop,ct_state_call_times FROM vicidial_call_times where call_time_id='24hours';|
LocalCallTime No-Call Gap: |0|2400(24 00)|0000(00 00)|2|1|
Starting hopper run for GREEN-L campaign- GMT: 24hours   HOPPER: 200   ORDER: DOWN
     hopper DONE cleared:  0E0
     |DELETE from vicidial_hopper where campaign_id='GREEN-L' and status IN('DONE');|
     hopper GMT BAD cleared:  0E0
     |DELETE from vicidial_hopper where campaign_id='GREEN-L' and ((gmt_offset_now IN('99') ) );|
     hopper READY count:   751
     |SELECT count(*) from vicidial_hopper where campaign_id='GREEN-L' and status='READY';|
Campaign TEST set to no-hopper-dialing: Y
NO HOPPER COUNT: 0|SELECT count(*) FROM vicidial_hopper where campaign_id='TEST' and status NOT IN('QUEUE','HOLD');|
Campaign TRYBPO set to no-hopper-dialing: Y
NO HOPPER COUNT: 0|SELECT count(*) FROM vicidial_hopper where campaign_id='TRYBPO' and status NOT IN('QUEUE','HOLD');|

   |GMT-DAY-HOUR|   |13.00-3-218||12.75-3-203||12.50-3-148||12.25-3-133||12.00-3-118||11.75-3-103||11.50-3-48||11.25-3-33||11.00-3-18||10.75-3-3||10.50-2-2348||10.25-2-2333||10.00-2-2318||9.75-2-2303||9.50-2-2248||9.25-2-2233||9.00-2-2218||8.75-2-2203||8.50-2-2148||8.25-2-2133||8.00-2-2118||7.75-2-2103||7.50-2-2048||7.25-2-2033||7.00-2-2018||6.75-2-2003||6.50-2-1948||6.25-2-1933||6.00-2-1918||5.75-2-1903||5.50-2-1848||5.25-2-1833||5.00-2-1818||4.75-2-1803||4.50-2-1748||4.25-2-1733||4.00-2-1718||3.75-2-1703||3.50-2-1648||3.25-2-1633||3.00-2-1618||2.75-2-1603||2.50-2-1548||2.25-2-1533||2.00-2-1518||1.75-2-1503||1.50-2-1448||1.25-2-1433||1.00-2-1418||0.75-2-1403||0.50-2-1348||0.25-2-1333||0.00-2-1318||-0.25-2-1303||-0.50-2-1248||-0.75-2-1233||-1.00-2-1218||-1.25-2-1203||-1.50-2-1148||-1.75-2-1133||-2.00-2-1118||-2.25-2-1103||-2.50-2-1048||-2.75-2-1033||-3.00-2-1018||-3.25-2-1003||-3.50-2-948||-3.75-2-933||-4.00-2-918||-4.25-2-903||-4.50-2-848||-4.75-2-833||-5.00-2-818||-5.25-2-803||-5.50-2-748||-5.75-2-733||-6.00-2-718||-6.25-2-703||-6.50-2-648||-6.75-2-633||-7.00-2-618||-7.25-2-603||-7.50-2-548||-7.75-2-533||-8.00-2-518||-8.25-2-503||-8.50-2-448||-8.75-2-433||-9.00-2-418||-9.25-2-403||-9.50-2-348||-9.75-2-333||-10.00-2-318||-10.25-2-303||-10.50-2-248||-10.75-2-233||-11.00-2-218||-11.25-2-203||-11.50-2-148||-11.75-2-133||-12.00-2-118||-12.25-2-103||-12.50-2-48||-12.75-2-33|
   |SELECT call_time_id,call_time_name,call_time_comments,ct_default_start,ct_default_stop,ct_sunday_start,ct_sunday_stop,ct_monday_start,ct_monday_stop,ct_tuesday_start,ct_tuesday_stop,ct_wednesday_start,ct_wednesday_stop,ct_thursday_start,ct_thursday_stop,ct_friday_start,ct_friday_stop,ct_saturday_start,ct_saturday_stop,ct_state_call_times FROM vicidial_call_times where call_time_id='24hours';|
LocalCallTime No-Call Gap: |0|2400(24 00)|0000(00 00)|2|1|
Starting hopper run for TRYBPO3 campaign- GMT: 24hours   HOPPER: 1000   ORDER: DOWN
     hopper DONE cleared:  0E0
     |DELETE from vicidial_hopper where campaign_id='TRYBPO3' and status IN('DONE');|
     hopper GMT BAD cleared:  0E0
     |DELETE from vicidial_hopper where campaign_id='TRYBPO3' and ((gmt_offset_now IN('99') ) );|
     hopper READY count:   1953
     |SELECT count(*) from vicidial_hopper where campaign_id='TRYBPO3' and status='READY';|

   |GMT-DAY-HOUR|   |13.00-3-218||12.75-3-203||12.50-3-148||12.25-3-133||12.00-3-118||11.75-3-103||11.50-3-48||11.25-3-33||11.00-3-18||10.75-3-3||10.50-2-2348||10.25-2-2333||10.00-2-2318||9.75-2-2303||9.50-2-2248||9.25-2-2233||9.00-2-2218||8.75-2-2203||8.50-2-2148||8.25-2-2133||8.00-2-2118||7.75-2-2103||7.50-2-2048||7.25-2-2033||7.00-2-2018||6.75-2-2003||6.50-2-1948||6.25-2-1933||6.00-2-1918||5.75-2-1903||5.50-2-1848||5.25-2-1833||5.00-2-1818||4.75-2-1803||4.50-2-1748||4.25-2-1733||4.00-2-1718||3.75-2-1703||3.50-2-1648||3.25-2-1633||3.00-2-1618||2.75-2-1603||2.50-2-1548||2.25-2-1533||2.00-2-1518||1.75-2-1503||1.50-2-1448||1.25-2-1433||1.00-2-1418||0.75-2-1403||0.50-2-1348||0.25-2-1333||0.00-2-1318||-0.25-2-1303||-0.50-2-1248||-0.75-2-1233||-1.00-2-1218||-1.25-2-1203||-1.50-2-1148||-1.75-2-1133||-2.00-2-1118||-2.25-2-1103||-2.50-2-1048||-2.75-2-1033||-3.00-2-1018||-3.25-2-1003||-3.50-2-948||-3.75-2-933||-4.00-2-918||-4.25-2-903||-4.50-2-848||-4.75-2-833||-5.00-2-818||-5.25-2-803||-5.50-2-748||-5.75-2-733||-6.00-2-718||-6.25-2-703||-6.50-2-648||-6.75-2-633||-7.00-2-618||-7.25-2-603||-7.50-2-548||-7.75-2-533||-8.00-2-518||-8.25-2-503||-8.50-2-448||-8.75-2-433||-9.00-2-418||-9.25-2-403||-9.50-2-348||-9.75-2-333||-10.00-2-318||-10.25-2-303||-10.50-2-248||-10.75-2-233||-11.00-2-218||-11.25-2-203||-11.50-2-148||-11.75-2-133||-12.00-2-118||-12.25-2-103||-12.50-2-48||-12.75-2-33|
   |SELECT call_time_id,call_time_name,call_time_comments,ct_default_start,ct_default_stop,ct_sunday_start,ct_sunday_stop,ct_monday_start,ct_monday_stop,ct_tuesday_start,ct_tuesday_stop,ct_wednesday_start,ct_wednesday_stop,ct_thursday_start,ct_thursday_stop,ct_friday_start,ct_friday_stop,ct_saturday_start,ct_saturday_stop,ct_state_call_times FROM vicidial_call_times where call_time_id='24hours';|
LocalCallTime No-Call Gap: |0|2400(24 00)|0000(00 00)|2|1|
Starting hopper run for INBOUND campaign- GMT: 24hours   HOPPER: 200   ORDER: DOWN
     hopper DONE cleared:  0E0
     |DELETE from vicidial_hopper where campaign_id='INBOUND' and status IN('DONE');|
     hopper GMT BAD cleared:  0E0
     |DELETE from vicidial_hopper where campaign_id='INBOUND' and ((gmt_offset_now IN('99') ) );|
     hopper READY count:   0
     |SELECT count(*) from vicidial_hopper where campaign_id='INBOUND' and status='READY';|
     hopper too low (0|200) starting hopper dump
     campaign lists count: 0 | '999876543210'
     |SELECT list_id FROM vicidial_lists where campaign_id='INBOUND' and active='Y';|
     no lead filter defined for campaign: INBOUND
     |NONE|
     |SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('NEW') and list_id IN('999876543210') and ((gmt_offset_now IN('13.00','12.75','12.50','12.25','12.00','11.75','11.50','11.25','11.00','10.75','10.50','10.25','10.00','9.75','9.50','9.25','9.00','8.75','8.50','8.25','8.00','7.75','7.50','7.25','7.00','6.75','6.50','6.25','6.00','5.75','5.50','5.25','5.00','4.75','4.50','4.25','4.00','3.75','3.50','3.25','3.00','2.75','2.50','2.25','2.00','1.75','1.50','1.25','1.00','0.75','0.50','0.25','0.00','-0.25','-0.50','-0.75','-1.00','-1.25','-1.50','-1.75','-2.00','-2.25','-2.50','-2.75','-3.00','-3.25','-3.50','-3.75','-4.00','-4.25','-4.50','-4.75','-5.00','-5.25','-5.50','-5.75','-6.00','-6.25','-6.50','-6.75','-7.00','-7.25','-7.50','-7.75','-8.00','-8.25','-8.50','-8.75','-9.00','-9.25','-9.50','-9.75','-10.00','-10.25','-10.50','-10.75','-11.00','-11.25','-11.50','-11.75','-12.00','-12.25','-12.50','-12.75','99') ) )  ;|
     leads to call count:  0
     |SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('NEW') and list_id IN('999876543210') and ((gmt_offset_now IN('13.00','12.75','12.50','12.25','12.00','11.75','11.50','11.25','11.00','10.75','10.50','10.25','10.00','9.75','9.50','9.25','9.00','8.75','8.50','8.25','8.00','7.75','7.50','7.25','7.00','6.75','6.50','6.25','6.00','5.75','5.50','5.25','5.00','4.75','4.50','4.25','4.00','3.75','3.50','3.25','3.00','2.75','2.50','2.25','2.00','1.75','1.50','1.25','1.00','0.75','0.50','0.25','0.00','-0.25','-0.50','-0.75','-1.00','-1.25','-1.50','-1.75','-2.00','-2.25','-2.50','-2.75','-3.00','-3.25','-3.50','-3.75','-4.00','-4.25','-4.50','-4.75','-5.00','-5.25','-5.50','-5.75','-6.00','-6.25','-6.50','-6.75','-7.00','-7.25','-7.50','-7.75','-8.00','-8.25','-8.50','-8.75','-9.00','-9.25','-9.50','-9.75','-10.00','-10.25','-10.50','-10.75','-11.00','-11.25','-11.50','-11.75','-12.00','-12.25','-12.50','-12.75','99') ) )  ;|
     NO SHUFFLE-NEW-LEADS INTO HOPPER DEFINED FOR LEAD ORDER
     ERROR CANNOT ADD ANY LEADS TO HOPPER

   |GMT-DAY-HOUR|   |13.00-3-218||12.75-3-203||12.50-3-148||12.25-3-133||12.00-3-118||11.75-3-103||11.50-3-48||11.25-3-33||11.00-3-18||10.75-3-3||10.50-2-2348||10.25-2-2333||10.00-2-2318||9.75-2-2303||9.50-2-2248||9.25-2-2233||9.00-2-2218||8.75-2-2203||8.50-2-2148||8.25-2-2133||8.00-2-2118||7.75-2-2103||7.50-2-2048||7.25-2-2033||7.00-2-2018||6.75-2-2003||6.50-2-1948||6.25-2-1933||6.00-2-1918||5.75-2-1903||5.50-2-1848||5.25-2-1833||5.00-2-1818||4.75-2-1803||4.50-2-1748||4.25-2-1733||4.00-2-1718||3.75-2-1703||3.50-2-1648||3.25-2-1633||3.00-2-1618||2.75-2-1603||2.50-2-1548||2.25-2-1533||2.00-2-1518||1.75-2-1503||1.50-2-1448||1.25-2-1433||1.00-2-1418||0.75-2-1403||0.50-2-1348||0.25-2-1333||0.00-2-1318||-0.25-2-1303||-0.50-2-1248||-0.75-2-1233||-1.00-2-1218||-1.25-2-1203||-1.50-2-1148||-1.75-2-1133||-2.00-2-1118||-2.25-2-1103||-2.50-2-1048||-2.75-2-1033||-3.00-2-1018||-3.25-2-1003||-3.50-2-948||-3.75-2-933||-4.00-2-918||-4.25-2-903||-4.50-2-848||-4.75-2-833||-5.00-2-818||-5.25-2-803||-5.50-2-748||-5.75-2-733||-6.00-2-718||-6.25-2-703||-6.50-2-648||-6.75-2-633||-7.00-2-618||-7.25-2-603||-7.50-2-548||-7.75-2-533||-8.00-2-518||-8.25-2-503||-8.50-2-448||-8.75-2-433||-9.00-2-418||-9.25-2-403||-9.50-2-348||-9.75-2-333||-10.00-2-318||-10.25-2-303||-10.50-2-248||-10.75-2-233||-11.00-2-218||-11.25-2-203||-11.50-2-148||-11.75-2-133||-12.00-2-118||-12.25-2-103||-12.50-2-48||-12.75-2-33|
   |SELECT call_time_id,call_time_name,call_time_comments,ct_default_start,ct_default_stop,ct_sunday_start,ct_sunday_stop,ct_monday_start,ct_monday_stop,ct_tuesday_start,ct_tuesday_stop,ct_wednesday_start,ct_wednesday_stop,ct_thursday_start,ct_thursday_stop,ct_friday_start,ct_friday_stop,ct_saturday_start,ct_saturday_stop,ct_state_call_times FROM vicidial_call_times where call_time_id='24hours';|
LocalCallTime No-Call Gap: |0|2400(24 00)|0000(00 00)|2|1|
Starting hopper run for TRYBPO4 campaign- GMT: 24hours   HOPPER: 1000   ORDER: DOWN
     hopper DONE cleared:  0E0
     |DELETE from vicidial_hopper where campaign_id='TRYBPO4' and status IN('DONE');|
     hopper GMT BAD cleared:  0E0
     |DELETE from vicidial_hopper where campaign_id='TRYBPO4' and ((gmt_offset_now IN('99') ) );|
     hopper READY count:   1060
     |SELECT count(*) from vicidial_hopper where campaign_id='TRYBPO4' and status='READY';|

   |GMT-DAY-HOUR|   |13.00-3-218||12.75-3-203||12.50-3-148||12.25-3-133||12.00-3-118||11.75-3-103||11.50-3-48||11.25-3-33||11.00-3-18||10.75-3-3||10.50-2-2348||10.25-2-2333||10.00-2-2318||9.75-2-2303||9.50-2-2248||9.25-2-2233||9.00-2-2218||8.75-2-2203||8.50-2-2148||8.25-2-2133||8.00-2-2118||7.75-2-2103||7.50-2-2048||7.25-2-2033||7.00-2-2018||6.75-2-2003||6.50-2-1948||6.25-2-1933||6.00-2-1918||5.75-2-1903||5.50-2-1848||5.25-2-1833||5.00-2-1818||4.75-2-1803||4.50-2-1748||4.25-2-1733||4.00-2-1718||3.75-2-1703||3.50-2-1648||3.25-2-1633||3.00-2-1618||2.75-2-1603||2.50-2-1548||2.25-2-1533||2.00-2-1518||1.75-2-1503||1.50-2-1448||1.25-2-1433||1.00-2-1418||0.75-2-1403||0.50-2-1348||0.25-2-1333||0.00-2-1318||-0.25-2-1303||-0.50-2-1248||-0.75-2-1233||-1.00-2-1218||-1.25-2-1203||-1.50-2-1148||-1.75-2-1133||-2.00-2-1118||-2.25-2-1103||-2.50-2-1048||-2.75-2-1033||-3.00-2-1018||-3.25-2-1003||-3.50-2-948||-3.75-2-933||-4.00-2-918||-4.25-2-903||-4.50-2-848||-4.75-2-833||-5.00-2-818||-5.25-2-803||-5.50-2-748||-5.75-2-733||-6.00-2-718||-6.25-2-703||-6.50-2-648||-6.75-2-633||-7.00-2-618||-7.25-2-603||-7.50-2-548||-7.75-2-533||-8.00-2-518||-8.25-2-503||-8.50-2-448||-8.75-2-433||-9.00-2-418||-9.25-2-403||-9.50-2-348||-9.75-2-333||-10.00-2-318||-10.25-2-303||-10.50-2-248||-10.75-2-233||-11.00-2-218||-11.25-2-203||-11.50-2-148||-11.75-2-133||-12.00-2-118||-12.25-2-103||-12.50-2-48||-12.75-2-33|
   |SELECT call_time_id,call_time_name,call_time_comments,ct_default_start,ct_default_stop,ct_sunday_start,ct_sunday_stop,ct_monday_start,ct_monday_stop,ct_tuesday_start,ct_tuesday_stop,ct_wednesday_start,ct_wednesday_stop,ct_thursday_start,ct_thursday_stop,ct_friday_start,ct_friday_stop,ct_saturday_start,ct_saturday_stop,ct_state_call_times FROM vicidial_call_times where call_time_id='24hours';|
LocalCallTime No-Call Gap: |0|2400(24 00)|0000(00 00)|2|1|
Starting hopper run for AMDcamp campaign- GMT: 24hours   HOPPER: 700   ORDER: DOWN
     hopper DONE cleared:  0E0
     |DELETE from vicidial_hopper where campaign_id='AMDcamp' and status IN('DONE');|
     hopper GMT BAD cleared:  0E0
     |DELETE from vicidial_hopper where campaign_id='AMDcamp' and ((gmt_offset_now IN('99') ) );|
     hopper READY count:   0
     |SELECT count(*) from vicidial_hopper where campaign_id='AMDcamp' and status='READY';|
     hopper too low (0|700) starting hopper dump
     campaign lists count: 3 | '100','101','103'
     |SELECT list_id FROM vicidial_lists where campaign_id='AMDcamp' and active='Y';|
     LM 0 ++100|1|100| A -|++ |100|100|'A'|
     LM 1 ++103|10|0| -|++ |103|0|'-'|
     LM 2 ++101|10|0| -|++ |101|0|'-'|
     campaign mix: ACTIVE |2011mix - TRYBPOmix|100|1|100| A -|:103|10|0| -|:101|10|0| -||3|EVEN_MIX|
     no lead filter defined for campaign: AMDcamp
     |NONE|
     |SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and ((list_id='100' and status IN('A')) or (list_id='103' and status IN('-')) or (list_id='101' and status IN('-'))) and ((gmt_offset_now IN('13.00','12.75','12.50','12.25','12.00','11.75','11.50','11.25','11.00','10.75','10.50','10.25','10.00','9.75','9.50','9.25','9.00','8.75','8.50','8.25','8.00','7.75','7.50','7.25','7.00','6.75','6.50','6.25','6.00','5.75','5.50','5.25','5.00','4.75','4.50','4.25','4.00','3.75','3.50','3.25','3.00','2.75','2.50','2.25','2.00','1.75','1.50','1.25','1.00','0.75','0.50','0.25','0.00','-0.25','-0.50','-0.75','-1.00','-1.25','-1.50','-1.75','-2.00','-2.25','-2.50','-2.75','-3.00','-3.25','-3.50','-3.75','-4.00','-4.25','-4.50','-4.75','-5.00','-5.25','-5.50','-5.75','-6.00','-6.25','-6.50','-6.75','-7.00','-7.25','-7.50','-7.75','-8.00','-8.25','-8.50','-8.75','-9.00','-9.25','-9.50','-9.75','-10.00','-10.25','-10.50','-10.75','-11.00','-11.25','-11.50','-11.75','-12.00','-12.25','-12.50','-12.75','99') ) )  ;|
     leads to call count:  12
     |SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and ((list_id='100' and status IN('A')) or (list_id='103' and status IN('-')) or (list_id='101' and status IN('-'))) and ((gmt_offset_now IN('13.00','12.75','12.50','12.25','12.00','11.75','11.50','11.25','11.00','10.75','10.50','10.25','10.00','9.75','9.50','9.25','9.00','8.75','8.50','8.25','8.00','7.75','7.50','7.25','7.00','6.75','6.50','6.25','6.00','5.75','5.50','5.25','5.00','4.75','4.50','4.25','4.00','3.75','3.50','3.25','3.00','2.75','2.50','2.25','2.00','1.75','1.50','1.25','1.00','0.75','0.50','0.25','0.00','-0.25','-0.50','-0.75','-1.00','-1.25','-1.50','-1.75','-2.00','-2.25','-2.50','-2.75','-3.00','-3.25','-3.50','-3.75','-4.00','-4.25','-4.50','-4.75','-5.00','-5.25','-5.50','-5.75','-6.00','-6.25','-6.50','-6.75','-7.00','-7.25','-7.50','-7.75','-8.00','-8.25','-8.50','-8.75','-9.00','-9.25','-9.50','-9.75','-10.00','-10.25','-10.50','-10.75','-11.00','-11.25','-11.50','-11.75','-12.00','-12.25','-12.50','-12.75','99') ) )  ;|
     NO SHUFFLE-NEW-LEADS INTO HOPPER DEFINED FOR LEAD ORDER
     Getting Leads to add to hopper
     |SELECT lead_id FROM vicidial_hopper where campaign_id='AMDcamp';|
     NO RECYCLE-LEADS INTO HOPPER DEFINED
     lead call order:      order by lead_id asc
  LM 0 |100|100|700|'A'|
     |SELECT lead_id,list_id,gmt_offset_now,phone_number,state,status,modify_date,user FROM vicidial_list where called_since_last_reset='N' and (list_id='100' and status IN('A')) and lead_id NOT IN('0') and ((gmt_offset_now IN('13.00','12.75','12.50','12.25','12.00','11.75','11.50','11.25','11.00','10.75','10.50','10.25','10.00','9.75','9.50','9.25','9.00','8.75','8.50','8.25','8.00','7.75','7.50','7.25','7.00','6.75','6.50','6.25','6.00','5.75','5.50','5.25','5.00','4.75','4.50','4.25','4.00','3.75','3.50','3.25','3.00','2.75','2.50','2.25','2.00','1.75','1.50','1.25','1.00','0.75','0.50','0.25','0.00','-0.25','-0.50','-0.75','-1.00','-1.25','-1.50','-1.75','-2.00','-2.25','-2.50','-2.75','-3.00','-3.25','-3.50','-3.75','-4.00','-4.25','-4.50','-4.75','-5.00','-5.25','-5.50','-5.75','-6.00','-6.25','-6.50','-6.75','-7.00','-7.25','-7.50','-7.75','-8.00','-8.25','-8.50','-8.75','-9.00','-9.25','-9.50','-9.75','-10.00','-10.25','-10.50','-10.75','-11.00','-11.25','-11.50','-11.75','-12.00','-12.25','-12.50','-12.75','99') ) )   order by lead_id asc limit 700;|
Illegal division by zero at /usr/share/astguiclient/AST_VDhopper.pl line 1908.

PostPosted: Tue Apr 27, 2010 3:16 am
by mflorell
Looks like the script is dying during the process, but the reason it's dying is that you have no statuses selected for two of your list mix entries.

PostPosted: Tue Apr 27, 2010 9:38 am
by ruben23
@Matt

Thanks for reply;
whats the purposed of statuses set for the list ID that i will list mix..? this mean i can recycle them again when i reset..based on the status specified..?
All times are UTC - 5 hours
Page 1 of 1
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/