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
<ruzwan@pyrogroup.com> 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,
RuzwanOn Tue, Oct 12, 2010 at 4:02 PM,
<otrs-request@otrs.org> wrote:
Send otrs mailing list submissions to
otrs@otrs.org
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
otrs-request@otrs.org
You can reach the person managing the list at
otrs-owner@otrs.org
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" <dm_jangulo@equifax.com.pe>
Subject: [otrs] stadistic problem (values in zero)
To: "User questions and discussions about OTRS." <otrs@otrs.org>
Message-ID:
<0160518E5338C846B9E673C6A70D47050139162B@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 <ruzwan@pyrogroup.com>
Subject: [otrs] errror in CGI 10 OTRS SYSTEM LOG
To: otrs@otrs.org, otrs-request@otrs.org
Message-ID:
<AANLkTim7Woq9VkEfTR_Opi7cy4mw=KmFCfPVOFzfEkEA@mail.gmail.com>
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 <leonardo.certuche@itconsultores.com.co>
Subject: Re: [otrs] errror in CGI 10 OTRS SYSTEM LOG
To: "User questions and discussions about OTRS." <otrs@otrs.org>
Message-ID:
<AANLkTin72_=JkDg-czsRC5hjr_4PiLOr=HFsm-VjHNDw@mail.gmail.com>
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 <ruzwan@pyrogroup.com> 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 <win2xl@gmail.com>
Subject: [otrs] Help in Escalation properties of a queue
To: otrs@otrs.org
Message-ID:
<AANLkTimrtuc91X7qA_wqxZDH8ckPvKe=0jBt4o0zS8k_@mail.gmail.com>
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 <nils.leideck@leidex.net>
Subject: Re: [otrs] errror in CGI 10 OTRS SYSTEM LOG
To: "User questions and discussions about OTRS." <otrs@otrs.org>
Message-ID: <1083D82F-2EDC-4A78-9885-4D16C2346907@leidex.net>
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
--