[Solved] The given param 'StateIDs' is invalid or an empty..

[Niklaus]

When I'm trying to go to page Tickets > Queueview I get these errors to the log and browser shows "500 Internal Server Error":

Wed Jan 30 15:11:18 2013 error 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 ')
Wed Jan 30 15:11:18 2013 error 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 ')
Wed Jan 30 15:11:18 2013 error OTRS-CGI-10 The given param 'StateIDs' is invalid or an empty array reference!
Wed Jan 30 15:11:18 2013 error OTRS-CGI-10 The given param 'StateIDs' is invalid or an empty array reference!
Wed Jan 30 15:11:18 2013 error OTRS-CGI-10 The given param 'StateIDs' is invalid or an empty array reference!

How to fix this?

[crythias]

Seems as if you may have changed the labelling/spelling of default states.

If not that, you have tickets that have States that no longer exist in the database.

[Niklaus]

Yes, I have changed the labels, since I'm using OTRS in Finnish. How can I fix this? Which settings should I set and how?

[Niklaus]

And if it helps, I get this:

Copyright (C) 2001-2013 xxx, http://otrs.org/
Unlock old tickets:
DBD::mysql::st execute failed: 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 NOT IN ( 1, 3 )' at line 5 at /opt/otrs-3.2.1/Kernel/System/DB.pm line 618.
ERROR: OTRS-otrs.UnlockTickets.pl-10 Perl: 5.10.1 OS: linux Time: Wed Jan 30 15:39:45 2013

Message: 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 NOT IN ( 1, 3 )' at line 5, SQL: '
SELECT st.tn, st.id, st.timeout, sq.unlock_timeout
FROM ticket st, queue sq
WHERE st.queue_id = sq.id
AND sq.unlock_timeout != 0
AND st.ticket_state_id IN ( )
AND st.ticket_lock_id NOT IN ( 1, 3 ) '

Traceback (25115):
Module: /opt/otrs/bin/otrs.UnlockTickets.pl (v1.14) Line: 115


When trying to run otrs.UnlockTickets.pl.

[jojo]

please reset everything and just change the translation file

[Niklaus]

please reset everything and just change the translation file

Thanks that solved it. I used http://doc.otrs.org/3.1/en/html/states-customizing.html as reference (even I'm running 3.2.1).