Canno't create phone/Mail tickets

[wraith]

Good morning,

two days ago OTRS didn't allow customers to create tickets. So i rearched the problem and ended up changing the ticket_state_type table in order to match the names to the ticket_state table. The custumer interface so far works correctly but the agent interface does not. Now i can't create phone and email tickets, and the new tickets dont't appear on the dashboard, only on queue view.
I've already tried undoing the changes but it still didn't work.

This is the error:

Backend ERROR: OTRS-CGI-10 Perl: 5.10.1 OS: MSWin32 Time: Tue Jan 25 09:10:43 2011

Message: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ')'. (SQL-42000)
[Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s) could not be prepared. (SQL-42000), 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.until_time <= 1295946583'

Traceback (7820):
Module: Kernel::System::Ticket::TicketSearch (v1.485) Line: 5115
Module: Kernel::Output::HTML::ToolBarTicketLocked::Run (v1.6) Line: 65
Module: Kernel::Output::HTML::Layout::Header (v1.345) Line: 1402
Module: Kernel::Output::HTML::Layout::ErrorScreen (v1.345) Line: 1099
Module: Kernel::Modules::AgentTicketPhone::Run (v1.175) Line: 956
Module: Kernel::System::Web::InterfaceAgent::Run (v1.58) Line: 838
Module: E:\Hdesk\Logitools\bin\cgi-bin\index.pl (v1.88) Line: 48


I imagine this is the error - st.queue_id AND st.ticket_state_id IN ( ) - because the condition can't be blank.

[jojo]

you should not change content manually in the database!

Please use the provided scripts for database creation for the correct SQL Server Version