GOautodial Open Source Omni-channel Contact Center Suite

Hi,

When i try to Export Calls report, is see this error:

Error Number: 1064

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 vl.status IN order by vl.call_date limit 100000' at line 1

SELECT vl.call_date,vl.phone_number,vl.status,vl.user,vu.full_name,vl.campaign_id,vi.vendor_lead_code,vi.source_id,vi.list_id,vi.gmt_offset_now,vi.phone_code,vi.phone_number,vi.title,vi.first_name,vi.middle_initial,vi.last_name,vi.address1,vi.address2,vi.address3,vi.city,vi.state,vi.province,vi.postal_code,vi.country_code,vi.gender,vi.date_of_birth,vi.alt_phone,vi.email,vi.security_phrase,vi.comments,vl.length_in_sec,vl.user_group,vl.queue_seconds,vi.rank,vi.owner,vi.lead_id,vl.closecallid,vi.entry_list_id,vl.uniqueid from vicidial_users vu,vicidial_closer_log vl,vicidial_list vi where date_format(vl.call_date, '%Y-%m-%d') BETWEEN '2015-02-08' AND '2015-02-08' and vu.user=vl.user and vi.lead_id=vl.lead_id and vi.list_id IN and vl.campaign_id IN and vl.status IN order by vl.call_date limit 100000

I use Goautodial v3.3

How can resoleve this issue?

Best regards .