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, <[email protected]> wrote: > Send otrs mailing list submissions to > [email protected] > > 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 > [email protected] > > You can reach the person managing the list at > [email protected] > > 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 <[email protected]> > Subject: Re: [otrs] OTRS 2.4.8. the signature is no more shown on > email-tickets > To: "User questions and discussions about OTRS." <[email protected]> > Message-ID: > > <[email protected]<aanlktikjmhh71fhtqufn4cvf7ia%2bjiy%2bc_%[email protected]> > > > 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 < > [email protected]> 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 : [email protected] > > 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
--------------------------------------------------------------------- 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
