Hi Team, Please suggest the steps what i need to do for getting rid of the Sql error in system log.. because of this Ticket that are lock or not getting autamatically unlocl..' Please suggest. Regards, Ruzwan On Mon, Oct 11, 2010 at 9:28 AM, Ruzwan Abdul 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