Leads not getting into the hopper since move of system

[ejansen]

Moved server to a different physical location. Imported Leads into Vicidial, but since moving the server the leads are not being placed into the hopper. Tried running the cron job manually, but the leads still don't make it into the hopper. What could be the problem?

[gardo]

Try running this on the commandline and post the results:

/usr/share/astguiclient/AST_VDhopper.pl --debugX

I'm assuming you have a single server setup.

[ejansen]

NO SHUFFLE-NEW-LEADS INTO HOPPER DEFINED FOR LEAD ORDER ERROR CANNOT ADD ANY LEADS TO HOPPER

[ejansen]

----- DEBUG -----


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

TIME DEBUG: ||0| GMT: 15:01
SELECT * FROM vicidial_lists where active='N';Inactive Lists: 0
CALLBACK HOLD: 0|SELECT count(*) FROM vicidial_callbacks where callback_time <= '2008-01-18 15:01:15' and status='ACTIVE';|
CAMPAIGNS TO PROCESSES HOPPER FOR: 7|6

|GMT-DAY-HOUR| |13.00-6-401||12.75-6-346||12.50-6-331||12.25-6-316||12.00-6-301||11.75-6-246||11.50-6-231||11.25-6-216||11.00-6-201||10.75-6-146||10.50-6-131||10.25-6-116||10.00-6-101||9.75-6-46||9.50-6-31||9.25-6-16||9.00-6-1||8.75-5-2346||8.50-5-2331||8.25-5-2316||8.00-5-2301||7.75-5-2246||7.50-5-2231||7.25-5-2216||7.00-5-2201||6.75-5-2146||6.50-5-2131||6.25-5-2116||6.00-5-2101||5.75-5-2046||5.50-5-2031||5.25-5-2016||5.00-5-2001||4.75-5-1946||4.50-5-1931||4.25-5-1916||4.00-5-1901||3.75-5-1846||3.50-5-1831||3.25-5-1816||3.00-5-1801||2.75-5-1746||2.50-5-1731||2.25-5-1716||2.00-5-1701||1.75-5-1646||1.50-5-1631||1.25-5-1616||1.00-5-1601||0.75-5-1546||0.50-5-1531||0.25-5-1516||0.00-5-1501||-0.25-5-1446||-0.50-5-1431||-0.75-5-1416||-1.00-5-1401||-1.25-5-1346||-1.50-5-1331||-1.75-5-1316||-2.00-5-1301||-2.25-5-1246||-2.50-5-1231||-2.75-5-1216||-3.00-5-1201||-3.25-5-1146||-3.50-5-1131||-3.75-5-1116||-4.00-5-1101||-4.25-5-1046||-4.50-5-1031||-4.75-5-1016||-5.00-5-1001||-5.25-5-946||-5.50-5-931||-5.75-5-916||-6.00-5-901||-6.25-5-846||-6.50-5-831||-6.75-5-816||-7.00-5-801||-7.25-5-746||-7.50-5-731||-7.75-5-716||-8.00-5-701||-8.25-5-646||-8.50-5-631||-8.75-5-616||-9.00-5-601||-9.25-5-546||-9.50-5-531||-9.75-5-516||-10.00-5-501||-10.25-5-446||-10.50-5-431||-10.75-5-416||-11.00-5-401||-11.25-5-346||-11.50-5-331||-11.75-5-316||-12.00-5-301||-12.25-5-246||-12.50-5-231||-12.75-5-216|
|SELECT * FROM vicidial_call_times where call_time_id='24hours';|
|SELECT * from vicidial_state_call_times where state_call_time_id='louisiana';|
|SELECT * from vicidial_state_call_times where state_call_time_id='mississipp';|
Starting hopper run for 5002 campaign- GMT: 24hours HOPPER: 10
hopper DONE cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='5002' and status IN('DONE');|
hopper GMT BAD cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='5002' 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','-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') and state NOT IN('LA','MS')) or (state='LA' 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','-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')) or (state='MS' 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','-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')) );|
hopper READY count: 0
|SELECT count(*) from vicidial_hopper where campaign_id='5002' and status='READY';|
hopper too low (0|10) starting hopper dump
campaign lists count: 1 | '5002'
|SELECT list_id FROM vicidial_lists where campaign_id='5002' and active='Y';|
no lead filter defined for campaign: 5002
|NONE|
|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('A','DNC','DC','CALLBK','NEW') and list_id IN('5002') and ((gmt_offset_now IN('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','99') and state NOT IN('LA','MS')) or (state='LA' and gmt_offset_now IN('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','99')) or (state='MS' and gmt_offset_now IN('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','99')) ) ;|
leads to call count: 0
|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('A','DNC','DC','CALLBK','NEW') and list_id IN('5002') and ((gmt_offset_now IN('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','99') and state NOT IN('LA','MS')) or (state='LA' and gmt_offset_now IN('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','99')) or (state='MS' and gmt_offset_now IN('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','99')) ) ;|
NO SHUFFLE-NEW-LEADS INTO HOPPER DEFINED FOR LEAD ORDER
ERROR CANNOT ADD ANY LEADS TO HOPPER

|GMT-DAY-HOUR| |13.00-6-401||12.75-6-346||12.50-6-331||12.25-6-316||12.00-6-301||11.75-6-246||11.50-6-231||11.25-6-216||11.00-6-201||10.75-6-146||10.50-6-131||10.25-6-116||10.00-6-101||9.75-6-46||9.50-6-31||9.25-6-16||9.00-6-1||8.75-5-2346||8.50-5-2331||8.25-5-2316||8.00-5-2301||7.75-5-2246||7.50-5-2231||7.25-5-2216||7.00-5-2201||6.75-5-2146||6.50-5-2131||6.25-5-2116||6.00-5-2101||5.75-5-2046||5.50-5-2031||5.25-5-2016||5.00-5-2001||4.75-5-1946||4.50-5-1931||4.25-5-1916||4.00-5-1901||3.75-5-1846||3.50-5-1831||3.25-5-1816||3.00-5-1801||2.75-5-1746||2.50-5-1731||2.25-5-1716||2.00-5-1701||1.75-5-1646||1.50-5-1631||1.25-5-1616||1.00-5-1601||0.75-5-1546||0.50-5-1531||0.25-5-1516||0.00-5-1501||-0.25-5-1446||-0.50-5-1431||-0.75-5-1416||-1.00-5-1401||-1.25-5-1346||-1.50-5-1331||-1.75-5-1316||-2.00-5-1301||-2.25-5-1246||-2.50-5-1231||-2.75-5-1216||-3.00-5-1201||-3.25-5-1146||-3.50-5-1131||-3.75-5-1116||-4.00-5-1101||-4.25-5-1046||-4.50-5-1031||-4.75-5-1016||-5.00-5-1001||-5.25-5-946||-5.50-5-931||-5.75-5-916||-6.00-5-901||-6.25-5-846||-6.50-5-831||-6.75-5-816||-7.00-5-801||-7.25-5-746||-7.50-5-731||-7.75-5-716||-8.00-5-701||-8.25-5-646||-8.50-5-631||-8.75-5-616||-9.00-5-601||-9.25-5-546||-9.50-5-531||-9.75-5-516||-10.00-5-501||-10.25-5-446||-10.50-5-431||-10.75-5-416||-11.00-5-401||-11.25-5-346||-11.50-5-331||-11.75-5-316||-12.00-5-301||-12.25-5-246||-12.50-5-231||-12.75-5-216|
|SELECT * FROM vicidial_call_times where call_time_id='24hours';|
|SELECT * from vicidial_state_call_times where state_call_time_id='louisiana';|
|SELECT * from vicidial_state_call_times where state_call_time_id='mississipp';|
Starting hopper run for 5003 campaign- GMT: 24hours HOPPER: 10
hopper DONE cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='5003' and status IN('DONE');|
hopper GMT BAD cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='5003' 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','-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') and state NOT IN('LA','MS')) or (state='LA' 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','-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')) or (state='MS' 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','-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')) );|
hopper READY count: 0
|SELECT count(*) from vicidial_hopper where campaign_id='5003' and status='READY';|
hopper too low (0|10) starting hopper dump
campaign lists count: 1 | '5003'
|SELECT list_id FROM vicidial_lists where campaign_id='5003' and active='Y';|
no lead filter defined for campaign: 5003
|NONE|
|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('DC','DNC','CALLBK','A','NEW') and list_id IN('5003') and ((gmt_offset_now IN('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','99') and state NOT IN('LA','MS')) or (state='LA' and gmt_offset_now IN('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','99')) or (state='MS' and gmt_offset_now IN('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','99')) ) ;|
leads to call count: 0
|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('DC','DNC','CALLBK','A','NEW') and list_id IN('5003') and ((gmt_offset_now IN('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','99') and state NOT IN('LA','MS')) or (state='LA' and gmt_offset_now IN('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','99')) or (state='MS' and gmt_offset_now IN('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','99')) ) ;|
NO SHUFFLE-NEW-LEADS INTO HOPPER DEFINED FOR LEAD ORDER
ERROR CANNOT ADD ANY LEADS TO HOPPER

|GMT-DAY-HOUR| |13.00-6-401||12.75-6-346||12.50-6-331||12.25-6-316||12.00-6-301||11.75-6-246||11.50-6-231||11.25-6-216||11.00-6-201||10.75-6-146||10.50-6-131||10.25-6-116||10.00-6-101||9.75-6-46||9.50-6-31||9.25-6-16||9.00-6-1||8.75-5-2346||8.50-5-2331||8.25-5-2316||8.00-5-2301||7.75-5-2246||7.50-5-2231||7.25-5-2216||7.00-5-2201||6.75-5-2146||6.50-5-2131||6.25-5-2116||6.00-5-2101||5.75-5-2046||5.50-5-2031||5.25-5-2016||5.00-5-2001||4.75-5-1946||4.50-5-1931||4.25-5-1916||4.00-5-1901||3.75-5-1846||3.50-5-1831||3.25-5-1816||3.00-5-1801||2.75-5-1746||2.50-5-1731||2.25-5-1716||2.00-5-1701||1.75-5-1646||1.50-5-1631||1.25-5-1616||1.00-5-1601||0.75-5-1546||0.50-5-1531||0.25-5-1516||0.00-5-1501||-0.25-5-1446||-0.50-5-1431||-0.75-5-1416||-1.00-5-1401||-1.25-5-1346||-1.50-5-1331||-1.75-5-1316||-2.00-5-1301||-2.25-5-1246||-2.50-5-1231||-2.75-5-1216||-3.00-5-1201||-3.25-5-1146||-3.50-5-1131||-3.75-5-1116||-4.00-5-1101||-4.25-5-1046||-4.50-5-1031||-4.75-5-1016||-5.00-5-1001||-5.25-5-946||-5.50-5-931||-5.75-5-916||-6.00-5-901||-6.25-5-846||-6.50-5-831||-6.75-5-816||-7.00-5-801||-7.25-5-746||-7.50-5-731||-7.75-5-716||-8.00-5-701||-8.25-5-646||-8.50-5-631||-8.75-5-616||-9.00-5-601||-9.25-5-546||-9.50-5-531||-9.75-5-516||-10.00-5-501||-10.25-5-446||-10.50-5-431||-10.75-5-416||-11.00-5-401||-11.25-5-346||-11.50-5-331||-11.75-5-316||-12.00-5-301||-12.25-5-246||-12.50-5-231||-12.75-5-216|
|SELECT * FROM vicidial_call_times where call_time_id='24hours';|
|SELECT * from vicidial_state_call_times where state_call_time_id='louisiana';|
|SELECT * from vicidial_state_call_times where state_call_time_id='mississipp';|
Starting hopper run for 5004 campaign- GMT: 24hours HOPPER: 10
hopper DONE cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='5004' and status IN('DONE');|
hopper GMT BAD cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='5004' 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','-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') and state NOT IN('LA','MS')) or (state='LA' 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','-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')) or (state='MS' 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','-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')) );|
hopper READY count: 0
|SELECT count(*) from vicidial_hopper where campaign_id='5004' and status='READY';|
hopper too low (0|10) starting hopper dump
campaign lists count: 1 | '5004'
|SELECT list_id FROM vicidial_lists where campaign_id='5004' and active='Y';|
no lead filter defined for campaign: 5004
|NONE|
|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('DC','DNC','CALLBK','A','NEW') and list_id IN('5004') and ((gmt_offset_now IN('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','99') and state NOT IN('LA','MS')) or (state='LA' and gmt_offset_now IN('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','99')) or (state='MS' and gmt_offset_now IN('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','99')) ) ;|
leads to call count: 0
|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('DC','DNC','CALLBK','A','NEW') and list_id IN('5004') and ((gmt_offset_now IN('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','99') and state NOT IN('LA','MS')) or (state='LA' and gmt_offset_now IN('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','99')) or (state='MS' and gmt_offset_now IN('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','99')) ) ;|
NO SHUFFLE-NEW-LEADS INTO HOPPER DEFINED FOR LEAD ORDER
ERROR CANNOT ADD ANY LEADS TO HOPPER

|GMT-DAY-HOUR| |13.00-6-401||12.75-6-346||12.50-6-331||12.25-6-316||12.00-6-301||11.75-6-246||11.50-6-231||11.25-6-216||11.00-6-201||10.75-6-146||10.50-6-131||10.25-6-116||10.00-6-101||9.75-6-46||9.50-6-31||9.25-6-16||9.00-6-1||8.75-5-2346||8.50-5-2331||8.25-5-2316||8.00-5-2301||7.75-5-2246||7.50-5-2231||7.25-5-2216||7.00-5-2201||6.75-5-2146||6.50-5-2131||6.25-5-2116||6.00-5-2101||5.75-5-2046||5.50-5-2031||5.25-5-2016||5.00-5-2001||4.75-5-1946||4.50-5-1931||4.25-5-1916||4.00-5-1901||3.75-5-1846||3.50-5-1831||3.25-5-1816||3.00-5-1801||2.75-5-1746||2.50-5-1731||2.25-5-1716||2.00-5-1701||1.75-5-1646||1.50-5-1631||1.25-5-1616||1.00-5-1601||0.75-5-1546||0.50-5-1531||0.25-5-1516||0.00-5-1501||-0.25-5-1446||-0.50-5-1431||-0.75-5-1416||-1.00-5-1401||-1.25-5-1346||-1.50-5-1331||-1.75-5-1316||-2.00-5-1301||-2.25-5-1246||-2.50-5-1231||-2.75-5-1216||-3.00-5-1201||-3.25-5-1146||-3.50-5-1131||-3.75-5-1116||-4.00-5-1101||-4.25-5-1046||-4.50-5-1031||-4.75-5-1016||-5.00-5-1001||-5.25-5-946||-5.50-5-931||-5.75-5-916||-6.00-5-901||-6.25-5-846||-6.50-5-831||-6.75-5-816||-7.00-5-801||-7.25-5-746||-7.50-5-731||-7.75-5-716||-8.00-5-701||-8.25-5-646||-8.50-5-631||-8.75-5-616||-9.00-5-601||-9.25-5-546||-9.50-5-531||-9.75-5-516||-10.00-5-501||-10.25-5-446||-10.50-5-431||-10.75-5-416||-11.00-5-401||-11.25-5-346||-11.50-5-331||-11.75-5-316||-12.00-5-301||-12.25-5-246||-12.50-5-231||-12.75-5-216|
|SELECT * FROM vicidial_call_times where call_time_id='24hours';|
|SELECT * from vicidial_state_call_times where state_call_time_id='louisiana';|
|SELECT * from vicidial_state_call_times where state_call_time_id='mississipp';|
Starting hopper run for 5555 campaign- GMT: 24hours HOPPER: 10
hopper DONE cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='5555' and status IN('DONE');|
hopper GMT BAD cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='5555' 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','-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') and state NOT IN('LA','MS')) or (state='LA' 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','-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')) or (state='MS' 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','-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')) );|
hopper READY count: 0
|SELECT count(*) from vicidial_hopper where campaign_id='5555' and status='READY';|
hopper too low (0|10) starting hopper dump
campaign lists count: 2 | '5555','6666'
|SELECT list_id FROM vicidial_lists where campaign_id='5555' and active='Y';|
no lead filter defined for campaign: 5555
|NONE|
|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('DC','CALLBK','B','A','NEW') and list_id IN('5555','6666') and ((gmt_offset_now IN('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','99') and state NOT IN('LA','MS')) or (state='LA' and gmt_offset_now IN('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','99')) or (state='MS' and gmt_offset_now IN('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','99')) ) ;|
leads to call count: 0
|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('DC','CALLBK','B','A','NEW') and list_id IN('5555','6666') and ((gmt_offset_now IN('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','99') and state NOT IN('LA','MS')) or (state='LA' and gmt_offset_now IN('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','99')) or (state='MS' and gmt_offset_now IN('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','99')) ) ;|
NO SHUFFLE-NEW-LEADS INTO HOPPER DEFINED FOR LEAD ORDER
ERROR CANNOT ADD ANY LEADS TO HOPPER

|GMT-DAY-HOUR| |13.00-6-401||12.75-6-346||12.50-6-331||12.25-6-316||12.00-6-301||11.75-6-246||11.50-6-231||11.25-6-216||11.00-6-201||10.75-6-146||10.50-6-131||10.25-6-116||10.00-6-101||9.75-6-46||9.50-6-31||9.25-6-16||9.00-6-1||8.75-5-2346||8.50-5-2331||8.25-5-2316||8.00-5-2301||7.75-5-2246||7.50-5-2231||7.25-5-2216||7.00-5-2201||6.75-5-2146||6.50-5-2131||6.25-5-2116||6.00-5-2101||5.75-5-2046||5.50-5-2031||5.25-5-2016||5.00-5-2001||4.75-5-1946||4.50-5-1931||4.25-5-1916||4.00-5-1901||3.75-5-1846||3.50-5-1831||3.25-5-1816||3.00-5-1801||2.75-5-1746||2.50-5-1731||2.25-5-1716||2.00-5-1701||1.75-5-1646||1.50-5-1631||1.25-5-1616||1.00-5-1601||0.75-5-1546||0.50-5-1531||0.25-5-1516||0.00-5-1501||-0.25-5-1446||-0.50-5-1431||-0.75-5-1416||-1.00-5-1401||-1.25-5-1346||-1.50-5-1331||-1.75-5-1316||-2.00-5-1301||-2.25-5-1246||-2.50-5-1231||-2.75-5-1216||-3.00-5-1201||-3.25-5-1146||-3.50-5-1131||-3.75-5-1116||-4.00-5-1101||-4.25-5-1046||-4.50-5-1031||-4.75-5-1016||-5.00-5-1001||-5.25-5-946||-5.50-5-931||-5.75-5-916||-6.00-5-901||-6.25-5-846||-6.50-5-831||-6.75-5-816||-7.00-5-801||-7.25-5-746||-7.50-5-731||-7.75-5-716||-8.00-5-701||-8.25-5-646||-8.50-5-631||-8.75-5-616||-9.00-5-601||-9.25-5-546||-9.50-5-531||-9.75-5-516||-10.00-5-501||-10.25-5-446||-10.50-5-431||-10.75-5-416||-11.00-5-401||-11.25-5-346||-11.50-5-331||-11.75-5-316||-12.00-5-301||-12.25-5-246||-12.50-5-231||-12.75-5-216|
|SELECT * FROM vicidial_call_times where call_time_id='24hours';|
|SELECT * from vicidial_state_call_times where state_call_time_id='louisiana';|
|SELECT * from vicidial_state_call_times where state_call_time_id='mississipp';|
Starting hopper run for 5016 campaign- GMT: 24hours HOPPER: 10
hopper DONE cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='5016' and status IN('DONE');|
hopper GMT BAD cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='5016' 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','-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') and state NOT IN('LA','MS')) or (state='LA' 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','-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')) or (state='MS' 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','-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')) );|
hopper READY count: 0
|SELECT count(*) from vicidial_hopper where campaign_id='5016' and status='READY';|
hopper too low (0|10) starting hopper dump
campaign lists count: 1 | '5016'
|SELECT list_id FROM vicidial_lists where campaign_id='5016' and active='Y';|
no lead filter defined for campaign: 5016
|NONE|
|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('N','DC','A','B','NEW') and list_id IN('5016') and ((gmt_offset_now IN('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','99') and state NOT IN('LA','MS')) or (state='LA' and gmt_offset_now IN('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','99')) or (state='MS' and gmt_offset_now IN('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','99')) ) ;|
leads to call count: 0
|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('N','DC','A','B','NEW') and list_id IN('5016') and ((gmt_offset_now IN('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','99') and state NOT IN('LA','MS')) or (state='LA' and gmt_offset_now IN('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','99')) or (state='MS' and gmt_offset_now IN('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','99')) ) ;|
NO SHUFFLE-NEW-LEADS INTO HOPPER DEFINED FOR LEAD ORDER
ERROR CANNOT ADD ANY LEADS TO HOPPER

|GMT-DAY-HOUR| |13.00-6-401||12.75-6-346||12.50-6-331||12.25-6-316||12.00-6-301||11.75-6-246||11.50-6-231||11.25-6-216||11.00-6-201||10.75-6-146||10.50-6-131||10.25-6-116||10.00-6-101||9.75-6-46||9.50-6-31||9.25-6-16||9.00-6-1||8.75-5-2346||8.50-5-2331||8.25-5-2316||8.00-5-2301||7.75-5-2246||7.50-5-2231||7.25-5-2216||7.00-5-2201||6.75-5-2146||6.50-5-2131||6.25-5-2116||6.00-5-2101||5.75-5-2046||5.50-5-2031||5.25-5-2016||5.00-5-2001||4.75-5-1946||4.50-5-1931||4.25-5-1916||4.00-5-1901||3.75-5-1846||3.50-5-1831||3.25-5-1816||3.00-5-1801||2.75-5-1746||2.50-5-1731||2.25-5-1716||2.00-5-1701||1.75-5-1646||1.50-5-1631||1.25-5-1616||1.00-5-1601||0.75-5-1546||0.50-5-1531||0.25-5-1516||0.00-5-1501||-0.25-5-1446||-0.50-5-1431||-0.75-5-1416||-1.00-5-1401||-1.25-5-1346||-1.50-5-1331||-1.75-5-1316||-2.00-5-1301||-2.25-5-1246||-2.50-5-1231||-2.75-5-1216||-3.00-5-1201||-3.25-5-1146||-3.50-5-1131||-3.75-5-1116||-4.00-5-1101||-4.25-5-1046||-4.50-5-1031||-4.75-5-1016||-5.00-5-1001||-5.25-5-946||-5.50-5-931||-5.75-5-916||-6.00-5-901||-6.25-5-846||-6.50-5-831||-6.75-5-816||-7.00-5-801||-7.25-5-746||-7.50-5-731||-7.75-5-716||-8.00-5-701||-8.25-5-646||-8.50-5-631||-8.75-5-616||-9.00-5-601||-9.25-5-546||-9.50-5-531||-9.75-5-516||-10.00-5-501||-10.25-5-446||-10.50-5-431||-10.75-5-416||-11.00-5-401||-11.25-5-346||-11.50-5-331||-11.75-5-316||-12.00-5-301||-12.25-5-246||-12.50-5-231||-12.75-5-216|
|SELECT * FROM vicidial_call_times where call_time_id='24hours';|
|SELECT * from vicidial_state_call_times where state_call_time_id='louisiana';|
|SELECT * from vicidial_state_call_times where state_call_time_id='mississipp';|
Starting hopper run for 5018 campaign- GMT: 24hours HOPPER: 10
hopper DONE cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='5018' and status IN('DONE');|
hopper GMT BAD cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='5018' 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','-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') and state NOT IN('LA','MS')) or (state='LA' 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','-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')) or (state='MS' 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','-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')) );|
hopper READY count: 0
|SELECT count(*) from vicidial_hopper where campaign_id='5018' and status='READY';|
hopper too low (0|10) starting hopper dump
campaign lists count: 1 | '5018'
|SELECT list_id FROM vicidial_lists where campaign_id='5018' and active='Y';|
no lead filter defined for campaign: 5018
|NONE|
|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('DC','A','B','N','NEW') and list_id IN('5018') and ((gmt_offset_now IN('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','99') and state NOT IN('LA','MS')) or (state='LA' and gmt_offset_now IN('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','99')) or (state='MS' and gmt_offset_now IN('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','99')) ) ;|
leads to call count: 0
|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('DC','A','B','N','NEW') and list_id IN('5018') and ((gmt_offset_now IN('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','99') and state NOT IN('LA','MS')) or (state='LA' and gmt_offset_now IN('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','99')) or (state='MS' and gmt_offset_now IN('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','99')) ) ;|
NO SHUFFLE-NEW-LEADS INTO HOPPER DEFINED FOR LEAD ORDER
ERROR CANNOT ADD ANY LEADS TO HOPPER

|GMT-DAY-HOUR| |13.00-6-401||12.75-6-346||12.50-6-331||12.25-6-316||12.00-6-301||11.75-6-246||11.50-6-231||11.25-6-216||11.00-6-201||10.75-6-146||10.50-6-131||10.25-6-116||10.00-6-101||9.75-6-46||9.50-6-31||9.25-6-16||9.00-6-1||8.75-5-2346||8.50-5-2331||8.25-5-2316||8.00-5-2301||7.75-5-2246||7.50-5-2231||7.25-5-2216||7.00-5-2201||6.75-5-2146||6.50-5-2131||6.25-5-2116||6.00-5-2101||5.75-5-2046||5.50-5-2031||5.25-5-2016||5.00-5-2001||4.75-5-1946||4.50-5-1931||4.25-5-1916||4.00-5-1901||3.75-5-1846||3.50-5-1831||3.25-5-1816||3.00-5-1801||2.75-5-1746||2.50-5-1731||2.25-5-1716||2.00-5-1701||1.75-5-1646||1.50-5-1631||1.25-5-1616||1.00-5-1601||0.75-5-1546||0.50-5-1531||0.25-5-1516||0.00-5-1501||-0.25-5-1446||-0.50-5-1431||-0.75-5-1416||-1.00-5-1401||-1.25-5-1346||-1.50-5-1331||-1.75-5-1316||-2.00-5-1301||-2.25-5-1246||-2.50-5-1231||-2.75-5-1216||-3.00-5-1201||-3.25-5-1146||-3.50-5-1131||-3.75-5-1116||-4.00-5-1101||-4.25-5-1046||-4.50-5-1031||-4.75-5-1016||-5.00-5-1001||-5.25-5-946||-5.50-5-931||-5.75-5-916||-6.00-5-901||-6.25-5-846||-6.50-5-831||-6.75-5-816||-7.00-5-801||-7.25-5-746||-7.50-5-731||-7.75-5-716||-8.00-5-701||-8.25-5-646||-8.50-5-631||-8.75-5-616||-9.00-5-601||-9.25-5-546||-9.50-5-531||-9.75-5-516||-10.00-5-501||-10.25-5-446||-10.50-5-431||-10.75-5-416||-11.00-5-401||-11.25-5-346||-11.50-5-331||-11.75-5-316||-12.00-5-301||-12.25-5-246||-12.50-5-231||-12.75-5-216|
|SELECT * FROM vicidial_call_times where call_time_id='24hours';|
|SELECT * from vicidial_state_call_times where state_call_time_id='louisiana';|
|SELECT * from vicidial_state_call_times where state_call_time_id='mississipp';|
Starting hopper run for 5015 campaign- GMT: 24hours HOPPER: 10
hopper DONE cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='5015' and status IN('DONE');|
hopper GMT BAD cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='5015' 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','-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') and state NOT IN('LA','MS')) or (state='LA' 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','-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')) or (state='MS' 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','-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')) );|
hopper READY count: 6
|SELECT count(*) from vicidial_hopper where campaign_id='5015' and status='READY';|
hopper too low (6|10) starting hopper dump
campaign lists count: 1 | '5015'
|SELECT list_id FROM vicidial_lists where campaign_id='5015' and active='Y';|
no lead filter defined for campaign: 5015
|NONE|
|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('NEW') and list_id IN('5015') and ((gmt_offset_now IN('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','99') and state NOT IN('LA','MS')) or (state='LA' and gmt_offset_now IN('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','99')) or (state='MS' and gmt_offset_now IN('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','99')) ) ;|
leads to call count: 6
|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('NEW') and list_id IN('5015') and ((gmt_offset_now IN('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','99') and state NOT IN('LA','MS')) or (state='LA' and gmt_offset_now IN('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','99')) or (state='MS' and gmt_offset_now IN('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','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='5015';|
NO RECYCLE-LEADS INTO HOPPER DEFINED
lead call order: order by lead_id asc
|SELECT lead_id,list_id,gmt_offset_now,phone_number,state FROM vicidial_list where called_since_last_reset='N' and status IN('NEW') and list_id IN('5015') and lead_id NOT IN('707','708','709','710','711','712','0') and ((gmt_offset_now IN('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','99') and state NOT IN('LA','MS')) or (state='LA' and gmt_offset_now IN('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','99')) or (state='MS' and gmt_offset_now IN('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','99')) ) order by lead_id asc limit 10;|
Adding to hopper: 0
DONE with this campaign
DONE. Script execution time in seconds: 0

[ejansen]

I don't know what changed, but the hopper seems to be running fine now. Thanks for showing me how to debug the hopper script.

[Trying]

I have upgraded from VicidialNow to the SVN Trunk. I still had existing leads loaded and dialed the 5 leads in the Hopper but after that I have no leads in the Hopper and it will not reload. Underneath is the Hopper debug.

----- DEBUG -----


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

TIME DEBUG: 2.00|3|1| GMT: 01:09
SELECT * FROM vicidial_lists where active='N';Inactive Lists: 0
CALLBACK HOLD: 0|SELECT count(*) FROM vicidial_callbacks where callback_time <= '2008-04-07 4:09:02' and status='ACTIVE';|
CAMPAIGNS TO PROCESSES HOPPER FOR: 1|0

|GMT-DAY-HOUR| |13.00-1-1409||12.75-1-1354||12.50-1-1339||12.25-1-1324||12.00-1-1309||11.75-1-1254||11.50-1-1239||11.25-1-1224||11.00-1-1209||10.75-1-1154||10.50-1-1139||10.25-1-1124||10.00-1-1109||9.75-1-1054||9.50-1-1039||9.25-1-1024||9.00-1-1009||8.75-1-954||8.50-1-939||8.25-1-924||8.00-1-909||7.75-1-854||7.50-1-839||7.25-1-824||7.00-1-809||6.75-1-754||6.50-1-739||6.25-1-724||6.00-1-709||5.75-1-654||5.50-1-639||5.25-1-624||5.00-1-609||4.75-1-554||4.50-1-539||4.25-1-524||4.00-1-509||3.75-1-454||3.50-1-439||3.25-1-424||3.00-1-409||2.75-1-354||2.50-1-339||2.25-1-324||2.00-1-309||1.75-1-254||1.50-1-239||1.25-1-224||1.00-1-209||0.75-1-154||0.50-1-139||0.25-1-124||0.00-1-109||-0.25-1-54||-0.50-1-39||-0.75-1-24||-1.00-1-9||-1.25-0-2354||-1.50-0-2339||-1.75-0-2324||-2.00-0-2309||-2.25-0-2254||-2.50-0-2239||-2.75-0-2224||-3.00-0-2209||-3.25-0-2154||-3.50-0-2139||-3.75-0-2124||-4.00-0-2109||-4.25-0-2054||-4.50-0-2039||-4.75-0-2024||-5.00-0-2009||-5.25-0-1954||-5.50-0-1939||-5.75-0-1924||-6.00-0-1909||-6.25-0-1854||-6.50-0-1839||-6.75-0-1824||-7.00-0-1809||-7.25-0-1754||-7.50-0-1739||-7.75-0-1724||-8.00-0-1709||-8.25-0-1654||-8.50-0-1639||-8.75-0-1624||-9.00-0-1609||-9.25-0-1554||-9.50-0-1539||-9.75-0-1524||-10.00-0-1509||-10.25-0-1454||-10.50-0-1439||-10.75-0-1424||-11.00-0-1409||-11.25-0-1354||-11.50-0-1339||-11.75-0-1324||-12.00-0-1309||-12.25-0-1254||-12.50-0-1239||-12.75-0-1224|
|SELECT * FROM vicidial_call_times where call_time_id='24hours';|
Starting hopper run for AFF1090 campaign- GMT: 24hours HOPPER: 5 ORDER: DOWN
hopper DONE cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='AFF1090' and status IN('DONE');|
hopper GMT BAD cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='AFF1090' and ((gmt_offset_now IN('99') ) );|
hopper READY count: 0
|SELECT count(*) from vicidial_hopper where campaign_id='AFF1090' and status='READY';|
hopper too low (0|5) starting hopper dump
campaign lists count: 1 | '1090'
|SELECT list_id FROM vicidial_lists where campaign_id='AFF1090' and active='Y';|
no lead filter defined for campaign: AFF1090
|NONE|
|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('NEW') and list_id IN('1090') 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: 104
|SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('NEW') and list_id IN('1090') 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='AFF1090';|
NO RECYCLE-LEADS INTO HOPPER DEFINED
lead call order: order by lead_id asc
|SELECT lead_id,list_id,gmt_offset_now,phone_number,state,status FROM vicidial_list where called_since_last_reset='N' and status IN('NEW') and list_id IN('1090') 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 5;|
Adding to hopper: 5
DBD::mysql::db do failed: Unknown column 'priority' in 'field list' at /usr/share/astguiclient/AST_VDhopper.pl line 1273.
LEAD INSERTED: |106|
DBD::mysql::db do failed: Unknown column 'priority' in 'field list' at /usr/share/astguiclient/AST_VDhopper.pl line 1273.
LEAD INSERTED: |107|
DBD::mysql::db do failed: Unknown column 'priority' in 'field list' at /usr/share/astguiclient/AST_VDhopper.pl line 1273.
LEAD INSERTED: |108|
DBD::mysql::db do failed: Unknown column 'priority' in 'field list' at /usr/share/astguiclient/AST_VDhopper.pl line 1273.
LEAD INSERTED: |109|
DBD::mysql::db do failed: Unknown column 'priority' in 'field list' at /usr/share/astguiclient/AST_VDhopper.pl line 1273.
LEAD INSERTED: |110|
DONE with this campaign
DONE. Script execution time in seconds: 0
You have new mail in /var/spool/mail/root
[root@vicidialnow astguiclient]#

[mflorell]

looks like your code is not matching up to the database. Make sure you did the database updates.