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
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
************************************