Help with Survey Setup

[jmckenna]

Starting to pull my hair out with this one.
I am trying to set up a survey in OTRS I have followed all the steps:
- Changed sysconfig Survey::SendPeriod: settings to 0 and tried variations 0.1 and 0.001
- The Survey is set to Master

Still doesnt seem to work,this error appears in system log and I think it is related but un sure:

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 sq.group_id IN (2, 3, 7, 7, 8, 8, 9, 9, 10, 11, 12, 13, 14, 14, 15) AND ' at line 1, SQL: 'SELECT DISTINCT count(*) FROM ticket st, queue sq , ticket_watcher tw WHERE sq.id = st.queue_id AND st.id = tw.ticket_id AND st.ticket_state_id IN ( ) AND sq.group_id IN (2, 3, 7, 7, 8, 8, 9, 9, 10, 11, 12, 13, 14, 14, 15) AND tw.user_id IN (8) AND st.until_time <= 1275999766 LIMIT 10000'

Any help would be appreciated and if possible can you check my other help post regarding dashboard help

Thanks Jon

[jmckenna]

can anyone help??

[danielz]

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 sq.group_id IN (2, 3, 7, 7, 8, 8, 9, 9, 10, 11, 12, 13, 14, 14, 15) AND ' at line 1, SQL: 'SELECT DISTINCT count(*) FROM ticket st, queue sq , ticket_watcher tw WHERE sq.id = st.queue_id AND st.id = tw.ticket_id AND st.ticket_state_id IN ( ) AND sq.group_id IN (2, 3, 7, 7, 8, 8, 9, 9, 10, 11, 12, 13, 14, 14, 15) AND tw.user_id IN (8) AND st.until_time <= 1275999766 LIMIT 10000'

This seems like a framework problem not a survey problem, if you see -> st.ticket_state_id IN ( ) which means is not getting state ids, did you modify the ticket states?
and could be great if you specify when is this error triggered, and how to reproduce it step by step.

also to get more help you can post your problems in:
http://bugs.otrs.org/
and you will get help from the otrs developers, and the community.

I hope this is not too late