My problem is, when i try to load in some leads to the list it seems to be okay, but when i try to run the AST_VDhopper.pl i get the following error.
- Code: Select all
viciserv01:/usr/share/astguiclient# perl AST_VDhopper.pl -q
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('107') and ((gmt_offset_now IN('13.00','12.75','12.50','12.25',' at line 1 at AST_VDhopper.pl line 971.
executing: SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN() 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') ) ) ; 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('107') and ((gmt_offset_now IN('13.00','12.75','12.50','12.25',' at line 1 at AST_VDhopper.pl line 971.
I really dont know what to do. can anyone please help me on the way?