sql syntax error

[marcoe]

Hello, I'm getting this error every minute:

From root@vicidial.site Wed Jul 28 00:55:02 2010
X-Original-To: root
Delivered-To: root@vicidial.site
From: root@vicidial.site
To: root@vicidial.site
Subject: Cron <root@vicidial> /usr/share/astguiclient/AST_VDhopper.pl -q
X-Cron-Env: <SHELL=/bin/sh>
X-Cron-Env: <HOME=/root>
X-Cron-Env: <PATH=/usr/bin:/bin>
X-Cron-Env: <LOGNAME=root>
X-Cron-Env: <USER=root>
Date: Wed, 28 Jul 2010 00:55:02 -0300 (BRT)

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.


It will stop after I create the first campaign. I can't recall if this happened before, but since my last download of the .ISO I've been noticing this behavior.

I'm using the trunk VERSION: 2.4-265 BUILD: 100723-1519
ISO: ViciBox Redux 2.0.2
Asterisk: 1.4.27.1-vici

This is nothing to be too concerned, but I guess we have to help making this software better in every way.

[mflorell]

Thanks for posting. I believe that I fixed that bug when it was first reported last week, so it will be in the most recent SVN/trunk(2.4) codebase. If you update then it should not happen anymore.

[marcoe]

That's great, thanks.