MySQL error

[mustu]

Hi,

I'm getting these error much frequently in my OTRS Log. The Facility column is OTRS-CGI-10

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 st.ticket_lock_id IN (2) AND st.user_id IN (143) AND st.until_time <= 130' 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 st.ticket_lock_id IN (2) AND st.user_id IN (143) AND st.until_time <= 1306138992 LIMIT 10000'

This is OTRS v3.0.3. Database is upgraded from 2.3=>2.4=>3.0.

OTRS 2.3 application was dumped and new OTRS 3.0.3 app was setup with the up-graded database. This app+DB is running on CentOS 5.5 Linux.

Screenshot is attached. Any clue?

[crythias]

This is because you're using a filter that is asking for a state or stateid that no longer exists. Usually, this is because you've renamed states in the state list.

[mustu]

can you kindly brief a bit more. What needs to be done to fix it? I am getting issue of OTRS getting emails but not opening tickets (not permanent but missing few emails after a while). Could this be the reason?

[crythias]

If you've changed the names of the states, set them back.

[mustu]

fine i'll look into that..