[SOLVED]Sql Error

[mistermunios]

I have this error (a lot of) in the otrs log :

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 (1) AND st.until_time <= 13028' 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 (1) AND st.until_time <= 1302859662 LIMIT 10000'.

This error apears when i refresh the Dashboard... (or any ticket view i think)

Help me please ! (sorry for my poor english)

[thomkortekaas]

What file did you recently change?

And happens this for all users or just your useraccount?

[mistermunios]

I make the installation this morning :

i just modifi /Kernel/Language.pm
l 84:
# user language
$Self->{UserLanguage} = 'en' i set 'en' because i have a problem with the default language
|| $Self->{ConfigObject}->Get('DefaultLanguage')
|| 'en';

but return to the default configuration makes no change.

This problem happens with all users.

[crythias]

You have no visible state_ids. http://forums.otrs.org/viewtopic.php?f=62&t=8807#p35033

[mistermunios]

ok thanks for your reply.

I read the topic, but i don't know how to do this.

Why my state_ids are not visible?

[crythias]

This part:

Code: Select all

 AND st.ticket_state_id IN ( )

means that it is looking for Ticket State Ids. It can't find any to sort.

This means:
You've changed the labels for States.
You've changed the state types (labels) that apply to a State or a Dashboard.

What to look for:
States that you've changed the names of (probably due to translation)
State Types that you've changed (probably due to translation)
Visible State Types that you've changed (search System Config)

[mistermunios]

The problem that i modify any translation file or parameters ...

I resolv my problem directly into the conf file (i'm putting the id directly in the request) but i know that is a horrible way ... when i have more time i try to find the real problem

tanks for your help