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