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 <[email protected]> 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 >
--------------------------------------------------------------------- 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
