List Mix

[ykhan]

Is List Mix feature working in any of these versions 2.0.4.rc3, 2.0.4rc5 or SVN? If so which one?

Thanks

[mflorell]

It works, but you have to manually change the crontab entry for the VDhopper script to the mix test script to be able to use it.

We deactivated it by default because it is so complex that 99% of VICIDIAL users don't need it's advanced controls and would just be confused by them if they tried to use them.

[ykhan]

Upon changing the crontab entry to the MIXtest.pl file, I am getting htis output in mail:

From root@vici.vicidialnow.com Wed Feb 4 19:59:01 2009
Return-Path: <root@vici.vicidialnow.com>
Received: from vici.vicidialnow.com (localhost.localdomain [127.0.0.1])
by vici.vicidialnow.com (8.13.8/8.13. with ESMTP id n150x1he030250
for <root@vici.vicidialnow.com>; Wed, 4 Feb 2009 19:59:01 -0500
Received: (from root@localhost)
by vici.vicidialnow.com (8.13.8/8.13.8/Submit) id n150x19i030249;
Wed, 4 Feb 2009 19:59:01 -0500
Date: Wed, 4 Feb 2009 19:59:01 -0500
Message-Id: <200902050059.n150x19i030249@vici.vicidialnow.com>
From: root@vici.vicidialnow.com (Cron Daemon)
To: root@vici.vicidialnow.com
Subject: Cron <root@vici> /usr/share/astguiclient/AST_VDhopper_MIXtest.pl
Content-Type: text/plain; charset=UTF-8
Auto-Submitted: auto-generated
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>

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 '1044' and status IN('-)) or (list_id='1045' and status IN('-))) and ((gmt_offset' at line 1 at /usr/share/astguiclient/AST_VDhopper_MIXtest.pl line 1025.
executing: SELECT count(*) FROM vicidial_list where called_since_last_reset='N' and ((list_id='1042' and status IN('NEW')) or (list_id='1043' and status IN('-)) or (list_id='1044' and status IN('-)) or (list_id='1045' and status IN('-))) 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 '1044' and status IN('-)) or (list_id='1045' and status IN('-))) and ((gmt_offset' at line 1 at /usr/share/astguiclient/AST_VDhopper_MIXtest.pl line 1025.
no command line options set

From root@vici.vicidialnow.com Wed Feb 4 20:00:02 2009
Return-Path: <root@vici.vicidialnow.com>
Received: from vici.vicidialnow.com (localhost.localdomain [127.0.0.1])
by vici.vicidialnow.com (8.13.8/8.13. with ESMTP id n15101Of030380
for <root@vici.vicidialnow.com>; Wed, 4 Feb 2009 20:00:01 -0500
Received: (from root@localhost)
by vici.vicidialnow.com (8.13.8/8.13.8/Submit) id n151013K030379;
Wed, 4 Feb 2009 20:00:01 -0500
Date: Wed, 4 Feb 2009 20:00:01 -0500
Message-Id: <200902050100.n151013K030379@vici.vicidialnow.com>
From: root@vici.vicidialnow.com (Cron Daemon)
To: root@vici.vicidialnow.com
Subject: Cron <root@vici> /usr/share/astguiclient/AST_VDhopper_MIXtest.pl
Content-Type: text/plain; charset=UTF-8
Auto-Submitted: auto-generated
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>

no command line options set

[mflorell]

What is the last CHANGES data in the mix test script you are using?

What version and build of admin.php?

[ykhan]

Sorry Matt, but not sure what CHANGES data referes to.

VERSION: 2.0.4-121
BUILD: 80424-0442

[mflorell]

At this point we are not supporting List Mix in 2.0.4 branch.

I would suggest upgrading to SVN trunk if you want List Mix functionality, we currently have a few clients using it on a daily basis with no issues.