SQL Error in LOG

[vishnupv]

Hi,

Could you please help me by stating why this issue occurs in sys log?

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 (1, 2, 3, 4, 5, 6, 7, 8, 9, 11, 16, 17, 18, 20, 22, 25, 26' at line 1, SQL: 'SELECT DISTINCT count(*) FROM ticket st, queue sq WHERE sq.id = st.queue_id AND st.ticket_state_id IN ( ) AND sq.group_id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 11, 16, 17, 18, 20, 22, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42) AND st.until_time <= 1320820661 AND archive_flag = 0 LIMIT 10000'

Thanks in advance.
-Vishnu

[crythias]

This is because something is requesting a ticket state that you've changed the label or made invalid, yet is still referenced somewhere in sysconfig.

[vishnupv]

Thanks Crythias... need more help from you. I tried my best to figure out where i would have went wrong, but could not locate and fix this issue. Can you please guide me with more details?, would be a GREAT help if you can let me know where is should checked exactly.

Thanks in advance.

[crythias]

This code is used several places.

This: st.ticket_state_id IN ( ) is what's the problem.

This is because something is requesting a ticket state that you've changed the label or made invalid, yet is still referenced somewhere in sysconfig.

The first place to check is invalid states being used (where?) probably you changed some state names for a filter somewhere. Maybe you invalidated an existing state. Maybe you changed a state's label.

[vishnupv]

Thanks Thanks Thanks a TON.