Hopper not filling

[ckwall]

everything seems to be working fine on my dialer, except for the fact that my campaign cannot get the list I created to populate the hopper. I dont know where do begin troubleshooting.

[mflorell]

post results of this command:
/usr/share/astguiclient/AST_VDhopper.pl --debugX

[albatroz]

Yesterday, I messed my Vicidial trying to import (actually importing)
new lists, and finally I had to erase all campaigns/lists and create
everything again.

How did I discovered the error?
After noticing that no numbers were put in the Hopper, I reviewed the
installation sheet and executed this script.

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

And got this error message:

Code: Select all

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('2007') and ((gmt_offset_now IN(' 13.00','12.75','12.50','12.25'' 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('2007') 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('2007') and ((gmt_offset_now IN(' 13.00','12.75','12.50','12.25'' at line 1 at /usr/share/astguiclient/AST_VDhopper.pl line 971.

What could I have done wrong?
Is it safe to run it again to make sure everything is OK?

[albatroz]

BTW, is this result good?

Last login: Thu Mar 22 09:13:49 2007 from 201.230.184.145
[root@homelinux ~]# /usr/share/astguiclient/AST_VDhopper.pl --debugX

----- DEBUG -----


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

TIME DEBUG: -5|-4|1| GMT: 14:22
SELECT * FROM vicidial_lists where active='N';Inactive Lists: 1
Inactive List Leads Deleted: 0E0 |DELETE from vicidial_hopper where list_id IN('32207');|
CALLBACK HOLD: 0|SELECT count(*) FROM vicidial_callbacks where callback_time <= '2007-03-22 10:22:49' and status='ACTIVE';|
CAMPAIGNS TO PROCESSES HOPPER FOR: 1|0

|GMT-DAY-HOUR| |13.00-5-322||12.75-5-307||12.50-5-252||12.25-5-237||12.00-5-222||11.75-5-207||11.50-5-152||11.25-5-137||11.00-5-122||10.75-5-107||10.50-5-52||10.25-5-37||10.00-5-22||9.75-5-7||9.50-4-2352||9.25-4-2337||9.00-4-2322||8.75-4-2307||8.50-4-2252||8.25-4-2237||8.00-4-2222||7.75-4-2207||7.50-4-2152||7.25-4-2137||7.00-4-2122||6.75-4-2107||6.50-4-2052||6.25-4-2037||6.00-4-2022||5.75-4-2007||5.50-4-1952||5.25-4-1937||5.00-4-1922||4.75-4-1907||4.50-4-1852||4.25-4-1837||4.00-4-1822||3.75-4-1807||3.50-4-1752||3.25-4-1737||3.00-4-1722||2.75-4-1707||2.50-4-1652||2.25-4-1637||2.00-4-1622||1.75-4-1607||1.50-4-1552||1.25-4-1537||1.00-4-1522||0.75-4-1507||0.50-4-1452||0.25-4-1437||0.00-4-1422||-0.25-4-1407||-0.50-4-1352||-0.75-4-1337||-1.00-4-1322||-1.25-4-1307||-1.50-4-1252||-1.75-4-1237||-2.00-4-1222||-2.25-4-1207||-2.50-4-1152||-2.75-4-1137||-3.00-4-1122||-3.25-4-1107||-3.50-4-1052||-3.75-4-1037||-4.00-4-1022||-4.25-4-1007||-4.50-4-952||-4.75-4-937||-5.00-4-922||-5.25-4-907||-5.50-4-852||-5.75-4-837||-6.00-4-822||-6.25-4-807||-6.50-4-752||-6.75-4-737||-7.00-4-722||-7.25-4-707||-7.50-4-652||-7.75-4-637||-8.00-4-622||-8.25-4-607||-8.50-4-552||-8.75-4-537||-9.00-4-522||-9.25-4-507||-9.50-4-452||-9.75-4-437||-10.00-4-422||-10.25-4-407||-10.50-4-352||-10.75-4-337||-11.00-4-322||-11.25-4-307||-11.50-4-252||-11.75-4-237||-12.00-4-222||-12.25-4-207||-12.50-4-152||-12.75-4-137|
|SELECT * FROM vicidial_call_times where call_time_id='24hours';|
Starting hopper run for HDP1 campaign- GMT: 24hours HOPPER: 100
hopper DONE cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='HDP1' and status IN('DONE');|
hopper GMT BAD cleared: 0E0
|DELETE from vicidial_hopper where campaign_id='HDP1' and ((gmt_offset_now IN('99') ) );|
hopper READY count: 100
|SELECT count(*) from vicidial_hopper where campaign_id='HDP1' and status='READY';|
DONE. Script execution time in seconds: 0
[root@homelinux ~]#

[mflorell]

That result is good, you have 100 READY which is what it was trying for, so you didn't have to load any additional leads.