Ticket filter

Moderator: crythias

Locked
rezab
Znuny newbie
Posts: 1
Joined: 17 Apr 2013, 22:38
Znuny Version: 4.0.6
Real Name: Jan Rezab

Ticket filter

Post by rezab »

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?
Locked