[otrs] [Ticket #520] otrs Digest, Vol 25, Issue 18

This is a notification from the Help Desk. On Jul 02, 2011 @ 02:42 pm, ruzwan@pyrogroup.com wrote: 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, 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 Subject: Re: [otrs] OTRS 2.4.8. the signature is no more shown on email-tickets To: "User questions and discussions about OTRS." Message-ID:

...

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