----- DEBUG -----


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

TIME DEBUG: -5|-5|0|   GMT: 20:11
SELECT * FROM vicidial_lists where active='N';Inactive Lists:  2
Inactive List Leads Deleted:  0E0 |DELETE from vicidial_hopper where list_id IN('200','113');|
CALLBACK HOLD: 0|SELECT count(*) FROM vicidial_callbacks where callback_time <= '2008-04-01 15:11:50' and status='ACTIVE';|
CAMPAIGNS TO PROCESSES HOPPER FOR:  5|4

   |GMT-DAY-HOUR|   |13.00-3-911||12.75-3-856||12.50-3-841||12.25-3-826||12.00-3-811||11.75-3-756||11.50-3-741||11.25-3-726||11.00-3-711||10.75-3-656||10.50-3-641||10.25-3-626||10.00-3-611||9.75-3-556||9.50-3-541||9.25-3-526||9.00-3-511||8.75-3-456||8.50-3-441||8.25-3-426||8.00-3-411||7.75-3-356||7.50-3-341||7.25-3-326||7.00-3-311||6.75-3-256||6.50-3-241||6.25-3-226||6.00-3-211||5.75-3-156||5.50-3-141||5.25-3-126||5.00-3-111||4.75-3-56||4.50-3-41||4.25-3-26||4.00-3-11||3.75-2-2356||3.50-2-2341||3.25-2-2326||3.00-2-2311||2.75-2-2256||2.50-2-2241||2.25-2-2226||2.00-2-2211||1.75-2-2156||1.50-2-2141||1.25-2-2126||1.00-2-2111||0.75-2-2056||0.50-2-2041||0.25-2-2026||0.00-2-2011||-0.25-2-1956||-0.50-2-1941||-0.75-2-1926||-1.00-2-1911||-1.25-2-1856||-1.50-2-1841||-1.75-2-1826||-2.00-2-1811||-2.25-2-1756||-2.50-2-1741||-2.75-2-1726||-3.00-2-1711||-3.25-2-1656||-3.50-2-1641||-3.75-2-1626||-4.00-2-1611||-4.25-2-1556||-4.50-2-1541||-4.75-2-1526||-5.00-2-1511||-5.25-2-1456||-5.50-2-1441||-5.75-2-1426||-6.00-2-1411||-6.25-2-1356||-6.50-2-1341||-6.75-2-1326||-7.00-2-1311||-7.25-2-1256||-7.50-2-1241||-7.75-2-1226||-8.00-2-1211||-8.25-2-1156||-8.50-2-1141||-8.75-2-1126||-9.00-2-1111||-9.25-2-1056||-9.50-2-1041||-9.75-2-1026||-10.00-2-1011||-10.25-2-956||-10.50-2-941||-10.75-2-926||-11.00-2-911||-11.25-2-856||-11.50-2-841||-11.75-2-826||-12.00-2-811||-12.25-2-756||-12.50-2-741||-12.75-2-726|
   |SELECT * FROM vicidial_call_times where call_time_id='24hours';|
Starting hopper run for testcamp campaign- GMT: 24hours   HOPPER: 50
     hopper DONE cleared:  0E0
     |DELETE from vicidial_hopper where campaign_id='testcamp' and status IN('DONE');|
     hopper GMT BAD cleared:  0E0
     |DELETE from vicidial_hopper where campaign_id='testcamp' and ((gmt_offset_now IN('99') ) );|
     hopper READY count:   0
     |SELECT count(*) from vicidial_hopper where campaign_id='testcamp' and status='READY';|
     hopper too low (0|50) starting hopper dump
     campaign lists count: 0 | ''
     |SELECT list_id FROM vicidial_lists where campaign_id='testcamp' and active='Y';|
     no lead filter defined for campaign: testcamp
     |NONE|
     |SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN() and list_id 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') ) ) ;|
DBD::mysql::st execute failed: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') and list_id IN('') and ((gmt_offset_now IN('13.00','12.75','12.50','12.25','12' at line 1 at /usr/share/astguiclient/AST_VDhopper.pl line 971.
executing: SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN() and list_id 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') ) ) ; You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') and list_id IN('') and ((gmt_offset_now IN('13.00','12.75','12.50','12.25','12' at line 1 at /usr/share/astguiclient/AST_VDhopper.pl line 971.