AST_VDhopper.pl producing SQL error.

[keithm]

Using mysql 4.1.20 on a Centos 4.4 server setup according to the SCRATCH_INSTALL instructions and Manager Manual.

Getting this error over and over in my cron logs. Any idea where I might look for what is setting this off?


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('') and ((gmt_offset_now IN('0.25','0.00','-0.25','-0.50','-0.7' 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('') and ((gmt_offset_now IN('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','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('') and ((gmt_offset_now IN('0.25','0.00','-0.25','-0.50','-0.7' at line 1 at /usr/share/astguiclient/AST_VDhopper.pl line 971.

[peacy]

Is you campaign set up correctly? Do you have active lists attached to that campaign?
From the SQL it looks like that the campaign doesn't have any lists and doesn't have any statuses defined either. ("...status IN() and list_id IN('')...")

[keithm]

Yup. I re-added a unique list to the campaign and populated it with the dummy leads from the test_VICIDIAL_lead_file.txt and now I get this error:

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('8800') and ((gmt_offset_now IN('-1.75','-2.00','-2.25','-2.50'' 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('8800') and ((gmt_offset_now IN('-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','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('8800') and ((gmt_offset_now IN('-1.75','-2.00','-2.25','-2.50'' at line 1 at /usr/share/astguiclient/AST_VDhopper.pl line 971.

[keithm]

Oh god never mind i'm an idiot.

Hadn't added dial statuses (statusi?) to the campaign.

*sigh*.