Hello, There are several bugs for similar errors reported: http://bugs.otrs.org/show_bug.cgi?id=2982 http://bugs.otrs.org/show_bug.cgi?id=4524 http://bugs.otrs.org/show_bug.cgi?id=4383 I hope a better way of dealing with SQL issues is quicky found, it's annoying how they fill the admin log without a simple way of getting rid of them Leonardo Certuche www.itconsultores.com.co Medellín, Colombia On 11 October 2010 09:13, Ruzwan Abdul wrote:

Hi,

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.

-- Regards, Ruzwan

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