Dashlet not showing ticketcount/OTRS-CGI-10 in SysLog

[Federico]

The dashboard dashlet for "Reminder Tickets" (unsure of translation, running Swedish lanuage version) does not show any numbers within it's perentesis - i.e. "Locket tickets ()" instead of "Locket tickets (0)"

One of my administrators temporarily marked a State - pending reminder - as invalid, this might possibly be the cause but I'm not sure.
The state har been re-enabled but the problem still persists.

The SysLog gives me the following - 9 times per Dashboad load;

Code: Select all

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 (2) AND st.ticket_state_id IN ' 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 (2) AND st.ticket_state_id IN (12) AND st.until_time <= 1305106025 LIMIT 10000'

"st.ticket_state_id IN ( )"
Any ideas what could be causing this?

[crythias]

Yes. It means *something* is attempting to use a state or state type that does not exist. usually, this means you've changed a state's name or state type, but you didn't change it where it's being requested in the widget via sysconfig (template, dashboard, etc.)