vicidial.org

Hi there!
I'm using (trying to use) the list mix function for an outbound autodial campaign.
Unfortunately the query fails to execute because is generated in this way:

Code: Select all

SELECT count(*) FROM vicidial_list FORCE INDEX(list_id)
where
called_since_last_reset='N'
and ((((list_id="566565")) and status IN('KONONI','ADC','KOIRRE','NA','PDROP','N','ERI','DROP','B','AB','A','NEW')) or (() and status IN('KONONI','ADC','KOIRRE','NA','PDROP','N','ERI','DROP','B','AB','A','NEW')))
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 can see the

Code: Select all

or (()

in the query that brakes the query.

Here's a screenshot of the configuration:


ViciBox Redux v.6.0.3-141118 single server

VERSION: 2.12-512a
BUILD: 150927-0820

Run the AST_VDhopper.pl script for this campaign with the --debugX flag and post the results.

Also, check that both lists are active and assigned to the campaign.

I've found the errore using that flag, but, you were right, someone deactivated one of those list. Thank you very much