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 sub missions 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 s ignature 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<AANLkTikJMHh71FhTQuFn4CVf7iA%2BJiY%2Bc_%2BsxA0Y9x2o@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
> >
> > Cou ld 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