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
--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
