problem with ../AST_VDhopper.pl line 971

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

problem with ../AST_VDhopper.pl line 971

Postby cristncl » Fri Jun 08, 2007 2:19 pm

hi
we have a problem that does not update the table VICIDIAL_HOPPER with the command /usr/share/astguiclient/AST_VDhopper.pl
the error is

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

my versions =

mysql = 4.1.20-2
php = 4.3.9-3.22.5
astguiclient = 2.0.3
perl = perl 5.8.5-36
perl DBI = 1.40-8


Sorry for my writing I speak Spanish
cristncl
 
Posts: 6
Joined: Mon Dec 11, 2006 7:56 am

Postby mflorell » Sat Jun 09, 2007 8:44 am

looks like you have selected no dial statuses to call.
mflorell
Site Admin
 
Posts: 18387
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida


Return to Support

Who is online

Users browsing this forum: No registered users and 107 guests