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