Hopper update script error

All installation and configuration problems and questions

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

Hopper update script error

Postby aster1 » Sun Dec 24, 2006 7:44 am

Hello people


I am new to vicidial .. just installed it on centos . I got a strange campaign list reset problem .. I am using vicidial 2.0.2 latest one with asterisk 1.2.14 .

I set force reset of hoppe = Y in campaign and it said me to wait one minute .. i saw after few minutes and list wasnt reset so i did

/usr/share/astguiclient/AST_VDhopper.pl --debugX


it shows a sql query
SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and status IN('NEW','','','','') and list_id IN('101') 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') ) ) ;

and result wsa 0 . I checked the mysql table and when the agents click no answer it status to N instead of NEW .. this script check's for status NEW only .. so result was zero .

Is it supposed to be like this and we should self edit script ? or is it a mistake in script ?
aster1
 
Posts: 281
Joined: Sun Dec 24, 2006 6:48 am
Location: India

Postby aster1 » Sun Dec 24, 2006 1:19 pm

oop sorry my mistake :D didnt see we can setup in conferences :)
aster1
 
Posts: 281
Joined: Sun Dec 24, 2006 6:48 am
Location: India


Return to Support

Who is online

Users browsing this forum: Majestic-12 [Bot] and 138 guests