Please assist me in closing this problem of SQL error in system log... Because of this tickets are not getting unlock automatically.
Regards, Ruzwan On Mon, Oct 11, 2010 at 9:28 AM, Ruzwan Abdul <[email protected]> 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, <[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
