Hi All, I am getting the below error in System log Mysql when using Dashboard. version 2.4.6 OTRS
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 st.until_time >= 1286808536 ORDER BY st.until_time ASC LIMIT 25' at line 1, SQL: 'SELECT DISTINCT st.id, st.tn, st.until_time FROM ticket st, queue sq WHERE sq.id = st.queue_id AND st.ticket_state_id IN ( ) AND st.until_time >= 1286808536 ORDER BY st.until_time ASC LIMIT 25' Please suggest what could be the problem, because of this my lock tickets are not getting unlock getting same error. Regards, Ruzwan On Fri, Oct 15, 2010 at 5:30 PM, <otrs-requ...@otrs.org> 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-requ...@otrs.org > > You can reach the person managing the list at > otrs-ow...@otrs.org > > When replying, please edit your Subject line so it is more specific > than "Re: Contents of otrs digest..." > > > Today's Topics: > > 1. Link to reopen a ticket (Pradumna Maheshwari) > > > ---------------------------------------------------------------------- > > Message: 1 > Date: Fri, 15 Oct 2010 16:40:28 +0530 > From: Pradumna Maheshwari <pradumna.maheshw...@tcs.com> > Subject: [otrs] Link to reopen a ticket > To: otrs@otrs.org, otrs-boun...@otrs.org > Message-ID: > <of7d3402d4.a7b0b5ce-on652577bc.003d0ce9-652577bd.003d6...@tcs.com> > Content-Type: text/plain; charset="us-ascii" > > Hello, > > I want to give a link in Survey, so that Customer can re-open the ticket. > > I tried this : > <OTRS_CONFIG_HttpType>://<OTRS_CONFIG_FQDN>/<OTRS_CONFIG_ScriptAlias> > customer.pl?Action=CustomerTicketZoom&TicketID=<http://customer.pl/?Action=CustomerTicketZoom&TicketID=> > <OTRS_TICKET_ID> > > but not working. It is giving error : "Message: No Permission! " > > What to do..? > > Thanks... > > Pradumna Maheshwari > =====-----=====-----===== > Notice: The information contained in this e-mail > message and/or attachments to it may contain > confidential or privileged information. If you are > not the intended recipient, any dissemination, use, > review, distribution, printing or copying of the > information contained in this e-mail message > and/or attachments to it are strictly prohibited. If > you have received this communication in error, > please notify us by reply e-mail or telephone and > immediately and permanently delete the message > and any attachments. Thank you > > > -------------- next part -------------- > An HTML attachment was scrubbed... > URL: < > http://lists.otrs.org/pipermail/otrs/attachments/20101015/5e16b562/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 34 > ************************************ >
--------------------------------------------------------------------- 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
