Query Error when list mix is activated

[DarknessBBB]

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

[mflorell]

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.

[DarknessBBB]

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