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
