Hello all.
I use otrs version 4.0.6 with MySQL 5.5.
In Dashboard or queue view I have problem with filter TYPE. The filter don't show any data and in the system log is this:
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 t.type_id = tt.id AND ( t.id IN (33) ) ORDER BY t.type_id DESC' at line 1, SQL: 'SELECT DISTINCT(t.type_id), tt.name FROM ticket t, ticket_type tt WHERE AND t.type_id = tt.id AND ( t.id IN (33) ) ORDER BY t.type_id DESC'
Any idea?
Ticket filter
Moderator: crythias