Cron Error: SQL Syntax (2.4-266)

[bmorrison]

Hello,

I just installed vicibox with the lastest from the svn. Root's mail is getting hit with this 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 ((gmt_offset_now IN('99') ) )' at line 1 at /usr/share/astguiclient/AST_VDhopper.pl line 1624.
executing: SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and () and ((gmt_offset_now IN('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('99') ) )' at line 1 at /usr/share/astguiclient/AST_VDhopper.pl line 1624.

BUILD: 100726-1017

[mflorell]

Do you have a campaign active on your system?

I just added some code in SVN to prevent this error, but if you have a properly configured campaign this error should not be happening.

[bmorrison]

There is no campaign.

I'll add one and kill the errors.

Thanks!