Queue view does not work – 500 internal server error

[annagawin]

Hi guys – i have problem with Tickets-queue view), it displays 500 internal server error, instead of listing entries. The exact message is :
„500 Internal Server Error - The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator at webmaster@localhost to inform them of the time this error occurred, and the actions you performed just before this error. More information about this error may be available in the server error log.”

After checking logs i’ve go following error: „
„You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND ( st.responsible_user_id IN (21) ) AND sq.group_id IN (1,2,3,4,5,6,7,8,9' at line 1, SQL: 'SELECT COUNT(DISTINCT(st.id)) FROM ticket st INNER JOIN ticket_flag tf1 ON st.id = tf1.ticket_id INNER JOIN queue sq ON sq.id = st.queue_id WHERE 1=1 AND st.ticket_state_id IN ( ) AND ( st.responsible_user_id IN (21) ) AND sq.group_id IN (1,2,3,4,5,6,7,8,9) AND tf1.ticket_key = 'Seen' AND tf1.ticket_value = '1' AND tf1.create_by = 21 LIMIT 10000'”

AFAIU the problem is „st.ticket_state_id IN ()” – there are no IDs inside brackets. How can we find what caused this error?
Adding a new ticket doesn’t work – same error… What can we do with this ?

[root]

Hi,

Looks like someone messed with the SysConfig Ticket::ViewableStateType

- Roy

[annagawin]

Hi !
We don't have any states in ViewableStateType
How can we fix it ?

[root]

Hi !
We don't have any states in ViewableStateType
How can we fix it ?

Just reset the setting

- Roy

[annagawin]

Can you explain how to do this ? i will be very grateful

[annagawin]

Ok i reser setting but it still doesn't work

[zzz]

Hey,

This is how it should look by default or after resetting and deploying the setting:

Reset.png

You should also delete the cache. Exexute as OTRS user: /opt/otrs/bin/otrs.Console.pl Maint::Cache::Delete

— Emin

[annagawin]

It's working ! Thank you guys so much ! you saved my life