Probleme to load leads in the hopper

[sephiroth22]

Hey

I work on Goautodial and i create list and put leads in the list.
I affect this in my campaign.
But when i use this campaign he says than i haven't leads in the hopper.

I have execute the perl script AST_VDhopper.pl

and i have this results:

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 ((gmt_offset_now IN('1.50','1.25','1.00','0.75','0.50','0.25','0.00','-0.2' at line 1 at ./AST_VDhopper.pl line 1631.
executing: SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and () and ((gmt_offset_now IN('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','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 ((gmt_offset_now IN('1.50','1.25','1.00','0.75','0.50','0.25','0.00','-0.2' at line 1 at ./AST_VDhopper.pl line 1631.


Help me plz

Goautodial VERSION: 2.2.1-260 BUILD: 100527-2211

[striker]

change the call time to 24 HRs in the campaign .
and also select Y for the force reset hopper , and check if the hopper gets loaded

[williamconley]

Code: Select all

screen -list

at the command line. if your hopper script is having mysql issues, it may be that others are as well and your entire system may in fact be messed up.

if you have less than 8 screens (like ...4?) your system is not really installed correctly (which would be unusual for GoAutoDial).