Hi Team,
 
  Can any one help me in finding why i am getting SQL error in system log.
 
OTRS verion - 2.4.6 Linux Suse.
 
I dont know what configuration change made me getting this error. and from that time my Autoresponse email is not going untill i manual run the postmaster script.
 
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 tw.user_id IN (1) AND st.until_time <= 1286735389 LIMIT 10000' at line 1, SQL: 'SELECT DISTINCT count(*) FROM ticket st, queue sq , ticket_watcher tw WHERE sq.id = st.queue_id AND st.id = tw.ticket_id AND st.ticket_state_id IN ( ) AND tw.user_id IN (1) AND st.until_time <= 1286735389 LIMIT 10000'
 
Thanks
--

Regards,
Ruzwan

On Sun, Oct 10, 2010 at 5:30 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. Re:  OTRS 2.4.8. the signature is no more shown on
     email-tickets (Gerald Young)


----------------------------------------------------------------------

Message: 1
Date: Sat, 9 Oct 2010 16:57:01 -0400
From: Gerald Young <crythias@gmail.com>
Subject: Re: [otrs] OTRS 2.4.8. the signature is no more shown on
       email-tickets
To: "User questions and discussions about OTRS." <otrs@otrs.org>
Message-ID:
       <AANLkTikJMHh71FhTQuFn4CVf7iA+JiY+c_+sxA0Y9x2o@mail.gmail.com>
Content-Type: text/plain; charset="iso-8859-1"

One who creates his own theme -- http://doc.otrs.org/2.4/en/html/c2079.html --
may avoid this issue in the future.

On Fri, Oct 8, 2010 at 4:53 AM, Martignier, Philippe <
Philippe.Martignier@wipo.int> wrote:

> I found the reason why ...
>
> I use themes and for these themes the signature is not appearing on screen
>
> If I take the standard theme it is ok and now it appears in html
>
> Could be a great idea to have a file saying which files are modified in a
> release ... (maybe it is the case and I don't know as the upgrade is not
> made by me but the IT people)
>
> Thanks
>
> Philippe Martignier
> Communications Division
> Customer Service Section
> Email : Philippe.Martignier@wipo.int
> Phone : 00 41 022 338 72 36
> Building : GB II
> Office : 0,3
>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.otrs.org/pipermail/otrs/attachments/20101009/639aa23f/attachment-0001.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 18
************************************

--

Regards,
Ruzwan

Technical Lead
Product Development & Delivery

Pyro Networks Pvt. Ltd,

Hyderabad - 500033, INDIA 

Mobile: +91 9642333207
http://www.pyrogroup.com