Hello,<br><br>There are several bugs for similar errors reported:<br><br><a href="http://bugs.otrs.org/show_bug.cgi?id=2982">http://bugs.otrs.org/show_bug.cgi?id=2982</a><br><a href="http://bugs.otrs.org/show_bug.cgi?id=4524">http://bugs.otrs.org/show_bug.cgi?id=4524</a><br>
<a href="http://bugs.otrs.org/show_bug.cgi?id=4383">http://bugs.otrs.org/show_bug.cgi?id=4383</a><br><br>I hope a better way of dealing with SQL issues is quicky found, it&#39;s annoying how they fill the admin log without a simple way of getting rid of them<br>
<br>Leonardo Certuche<br><a href="http://www.itconsultores.com.co" target="_blank">www.itconsultores.com.co</a><br>Medellín, Colombia<br><br>
<br><br><div class="gmail_quote">On 11 October 2010 09:13, Ruzwan Abdul <span dir="ltr">&lt;<a href="mailto:ruzwan@pyrogroup.com">ruzwan@pyrogroup.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div>Hi,</div>
<div> </div>
<div>  I am getting the below error in System log Mysql when using Dashboard.</div>
<div>  version 2.4.6 OTRS</div>
<div>  </div>
<div> </div>
<div><font color="#ff0000">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 &#39;) AND st.until_time &gt;= 1286808536 ORDER BY st.until_time ASC LIMIT 25&#39; at line 1, SQL: &#39;SELECT DISTINCT <a href="http://st.id" target="_blank">st.id</a>, <a href="http://st.tn" target="_blank">st.tn</a>, st.until_time FROM ticket st, queue sq WHERE <a href="http://sq.id" target="_blank">sq.id</a> = st.queue_id AND st.ticket_state_id IN ( ) AND st.until_time &gt;= 1286808536 ORDER BY st.until_time ASC LIMIT 25&#39;</font></div>


<div> </div>
<div> </div>
<div> Please suggest what could be the problem.</div>
<div> </div>
<div> </div>
<div><br>-- <br></div>
<div>Regards,<br>Ruzwan<br><br></div>
<br>---------------------------------------------------------------------<br>
OTRS mailing list: otrs - Webpage: <a href="http://otrs.org/" target="_blank">http://otrs.org/</a><br>
Archive: <a href="http://lists.otrs.org/pipermail/otrs" target="_blank">http://lists.otrs.org/pipermail/otrs</a><br>
To unsubscribe: <a href="http://lists.otrs.org/cgi-bin/listinfo/otrs" target="_blank">http://lists.otrs.org/cgi-bin/listinfo/otrs</a><br></blockquote></div><br>