Please let me know what steps should i follow to get rid of this error is system log.
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 On Tue, Oct 12, 2010 at 4:17 PM, Ruzwan Abdul <[email protected]> wrote: > Yes i have deleted the unused tickets directly from SQL. > > Is this is a problem, please help me in fixing up the problem. > > Thanks, > Ruzwan > > > On Tue, Oct 12, 2010 at 4:02 PM, <[email protected]> wrote: > >> Send otrs mailing list submissions to >> [email protected] >> >> To subscribe or unsubscribe via the World Wide Web, visit >> http://lists.otrs.org/cgi-bin/listinfo/otrs >> or, via email, send a message with subject or body 'help' to >> [email protected] >> >> You can reach the person managing the list at >> [email protected] >> >> When replying, please edit your Subject line so it is more specific >> than "Re: Contents of otrs digest..." >> >> >> Today's Topics: >> >> 1. stadistic problem (values in zero) (DM_Julio Angulo) >> 2. errror in CGI 10 OTRS SYSTEM LOG (Ruzwan Abdul) >> 3. Re: errror in CGI 10 OTRS SYSTEM LOG (Leonardo Certuche) >> 4. Help in Escalation properties of a queue (Silver springs) >> 5. Re: errror in CGI 10 OTRS SYSTEM LOG (Nils Leideck - ITSM) >> >> >> ---------------------------------------------------------------------- >> >> Message: 1 >> Date: Mon, 11 Oct 2010 09:54:02 -0500 >> From: "DM_Julio Angulo" <[email protected]> >> Subject: [otrs] stadistic problem (values in zero) >> To: "User questions and discussions about OTRS." <[email protected]> >> Message-ID: >> >> <0160518e5338c846b9e673c6a70d470501391...@serv-zorexch3.infocorp.local> >> >> Content-Type: text/plain; charset="us-ascii" >> >> Hi, i have problems with the statistics (10042, 10043, 10044, 10045, >> 10046, 10047 and 10048) that do not show me time value only values zero, >> there is a way to correct this, if someone had the same problem, thanks. >> >> >> >> Julio Cesar Angulo Quiroz >> >> Telf.: 997066155 >> >> >> >> -------------- next part -------------- >> An HTML attachment was scrubbed... >> URL: < >> http://lists.otrs.org/pipermail/otrs/attachments/20101011/cbffe72a/attachment-0001.html >> > >> >> ------------------------------ >> >> Message: 2 >> Date: Mon, 11 Oct 2010 20:43:09 +0530 >> From: Ruzwan Abdul <[email protected]> >> Subject: [otrs] errror in CGI 10 OTRS SYSTEM LOG >> To: [email protected], [email protected] >> Message-ID: >> <[email protected]> >> Content-Type: text/plain; charset="iso-8859-1" >> >> 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 >> -------------- next part -------------- >> An HTML attachment was scrubbed... >> URL: < >> http://lists.otrs.org/pipermail/otrs/attachments/20101011/7551ff2d/attachment-0001.html >> > >> >> ------------------------------ >> >> Message: 3 >> Date: Mon, 11 Oct 2010 09:56:22 -0600 >> From: Leonardo Certuche <[email protected]> >> Subject: Re: [otrs] errror in CGI 10 OTRS SYSTEM LOG >> To: "User questions and discussions about OTRS." <[email protected]> >> Message-ID: >> <[email protected]> >> Content-Type: text/plain; charset="iso-8859-1" >> >> 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 >> > >> -------------- next part -------------- >> An HTML attachment was scrubbed... >> URL: < >> http://lists.otrs.org/pipermail/otrs/attachments/20101011/757be26b/attachment-0001.html >> > >> >> ------------------------------ >> >> Message: 4 >> Date: Mon, 11 Oct 2010 13:11:10 -0500 >> From: Silver springs <[email protected]> >> Subject: [otrs] Help in Escalation properties of a queue >> To: [email protected] >> Message-ID: >> <[email protected]> >> Content-Type: text/plain; charset="iso-8859-1" >> >> Hello, >> >> I have a question in the queue escalation properties. Please let me know >> if >> its possible to escalate a ticket to an individual person. Not sure how to >> tell it to escalate to one person and then second to another and last to >> the >> third person. Any help is greatly appreciated. >> >> Thanks >> Winter >> -------------- next part -------------- >> An HTML attachment was scrubbed... >> URL: < >> http://lists.otrs.org/pipermail/otrs/attachments/20101011/9d2a3e10/attachment-0001.html >> > >> >> ------------------------------ >> >> Message: 5 >> Date: Tue, 12 Oct 2010 23:32:04 +1300 >> From: Nils Leideck - ITSM <[email protected]> >> Subject: Re: [otrs] errror in CGI 10 OTRS SYSTEM LOG >> To: "User questions and discussions about OTRS." <[email protected]> >> Message-ID: <[email protected]> >> Content-Type: text/plain; charset="windows-1252" >> >> 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 >> >> >> >> -------------- next part -------------- >> An HTML attachment was scrubbed... >> URL: < >> http://lists.otrs.org/pipermail/otrs/attachments/20101012/e8766f36/attachment.html >> > >> >> ------------------------------ >> >> --------------------------------------------------------------------- >> 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 >> >> End of otrs Digest, Vol 25, Issue 21 >> ************************************ >> > > > > -- > Regards, > Ruzwan > > Technical Lead > Product Development & Delivery > Pyro Networks Pvt. Ltd, > Hyderabad - 500033, INDIA > Mobile: +91 9642333207 > http://www.pyrogroup.com > > --
--------------------------------------------------------------------- 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
