Hi, Did you previously delete an unused ticket status by executing a SQL statement ? On 12.10.2010, at 04:13, Ruzwan Abdul wrote:
I am getting the below error in System log Mysql when using Dashboard. version 2.4.6 OTRS
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.until_time >= 1286808536 ORDER BY st.until_time ASC LIMIT 25' at line 1, SQL: 'SELECT DISTINCT st.id, st.tn, st.until_time FROM ticket st, queue sq WHERE sq.id = st.queue_id AND st.ticket_state_id IN ( ) AND st.until_time >= 1286808536 ORDER BY st.until_time ASC LIMIT 25'
Please suggest what could be the problem.
Cheers, Nils — Nils Leideck Senior Consultant http://webint.cryptonode.de / a Fractal project