AST_VDhopper.pl errors

[ktsaou]

Hi,

AST_VDhopper.pl sends me this e-mail once every minute:

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('500') 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('500') 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('500') 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.


Any ideas?

[mcargile]

Vicidial is running the following query:

Code: Select all

SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and
 status IN() and list_id IN('500') 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' ) ) ) ;


The part of that that is interesting is the:

Code: Select all

and status IN()


If you notice there is nothing in that IN() statement. This means that it is trying there are no statuses set. Please check that the campaign has dial statuses set.

Hope this helps. [/code]

[seaq]

I had this issue sometime ago and effectively it was an inbound campaing WITHOUT dial status.

It was breaking the hopper script...

[mflorell]

I believe that this issue might be fixed in SVN. But when campaigns are created I believe that they defaultot having NEW as a status in the campaign so by default it shouldn't be a problem unless you remove that status.

[Op3r]

I just had that this week!!!!

the thing that solved that problem was to delete the list that was causing it. So in my case that latest list that I created.