Sorry, there are no leads in the hopper for this campaign

[m160858]

Hi everyone,

i'm trying to access at agc/vicidial.php but show me the next message :

Sorry, there are no leads in the hopper for this campaign

I follow all steps of manual (buyed) .. but i still don't understand

Thanks

[mflorell]

please post the output of this command:

/home/cron/AST_VDhopper.pl --debugX

[m160858]

please post the output of this command:

/home/cron/AST_VDhopper.pl --debugX

Hey,

thats a nice tip ..

think that my problem is try to adapted for my country (Peru) everything's parameter for USA

[jslyg]

root@host:/home/cron/astguiclient# /home/cron/AST_VDhopper.pl --debugX

----- DEBUG -----


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

TIME DEBUG: -5|-4|1| GMT: 05:15
SELECT * FROM vicidial_lists where active='N';Inactive Lists: 0
CALLBACK HOLD: 0|SELECT count(*) FROM vicidial_callbacks where callback_time <= '2006-08-22 1:15:38' and status='ACTIVE';|

|GMT-DAY-HOUR| |13.00-2-1815||12.75-2-1800||12.50-2-1745||12.25-2-1730||12.00-2-1715||11.75-2-1700||11.50-2-1645||11.25-2-1630||11.00-2-1615||10.75-2-1600||10.50-2-1545||10.25-2-1530||10.00-2-1515||9.75-2-1500||9.50-2-1445||9.25-2-1430||9.00-2-1415||8.75-2-1400||8.50-2-1345||8.25-2-1330||8.00-2-1315||7.75-2-1300||7.50-2-1245||7.25-2-1230||7.00-2-1215||6.75-2-1200||6.50-2-1145||6.25-2-1130||6.00-2-1115||5.75-2-1100||5.50-2-1045||5.25-2-1030||5.00-2-1015||4.75-2-1000||4.50-2-945||4.25-2-930||4.00-2-915||3.75-2-900||3.50-2-845||3.25-2-830||3.00-2-815||2.75-2-800||2.50-2-745||2.25-2-730||2.00-2-715||1.75-2-700||1.50-2-645||1.25-2-630||1.00-2-615||0.75-2-600||0.50-2-545||0.25-2-530||0.00-2-515||-0.25-2-500||-0.50-2-445||-0.75-2-430||-1.00-2-415||-1.25-2-400||-1.50-2-345||-1.75-2-330||-2.00-2-315||-2.25-2-300||-2.50-2-245||-2.75-2-230||-3.00-2-215||-3.25-2-200||-3.50-2-145||-3.75-2-130||-4.00-2-115||-4.25-2-100||-4.50-2-45||-4.75-2-30||-5.00-2-15||-5.25-2-0||-5.50-1-2345||-5.75-1-2330||-6.00-1-2315||-6.25-1-2300||-6.50-1-2245||-6.75-1-2230||-7.00-1-2215||-7.25-1-2200||-7.50-1-2145||-7.75-1-2130||-8.00-1-2115||-8.25-1-2100||-8.50-1-2045||-8.75-1-2030||-9.00-1-2015||-9.25-1-2000||-9.50-1-1945||-9.75-1-1930||-10.00-1-1915||-10.25-1-1900||-10.50-1-1845||-10.75-1-1830||-11.00-1-1815||-11.25-1-1800||-11.50-1-1745||-11.75-1-1730||-12.00-1-1715||-12.25-1-1700||-12.50-1-1645||-12.75-1-1630|
|SELECT * FROM vicidial_call_times where call_time_id='24hours';|
Starting hopper run for TESTCAMP campaign- GMT: 24hours HOPPER: 5
hopper DONE cleared: 0
|DELETE from vicidial_hopper where campaign_id='TESTCAMP' and status IN('DONE');|
hopper GMT BAD cleared: 0
|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|5) starting hopper dump
campaign lists count: 1 | '107'
|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('NEW','','','','') and list_id IN('107') 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('107') 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') ) ) ;|
ERROR CANNOT ADD ANY NEW LEADS TO HOPPER
ERROR CANNOT ADD ANY LEADS TO HOPPER
DONE... Exiting... Goodbye... See you later... Really, I mean it

[mflorell]

You have no NEW leads in list 107

Is this where you imported your leads into?

Post output of this MySQL query:

SELECT count(*),list_id,status,phone_code from vicidial_list group by list_id,status,phone_code;

[jslyg]

mysql> SELECT count(*),list_id,status,phone_code from vicidial_list group by list_id,status,phone_code;
+----------+---------+--------+------------+
| count(*) | list_id | status | phone_code |
+----------+---------+--------+------------+
| 9 | 129 | NEW | 1 |
| 1 | 129 | NEW | 44 |
| 1 | 129 | NEW | 52 |
| 2 | 129 | NEW | 61 |
+----------+---------+--------+------------+
4 rows in set (0.04 sec)

[jslyg]

ok,chang 107 to 129,that's ok.
thanks!!