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-request@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-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.  Link to reopen a ticket (Pradumna Maheshwari)


----------------------------------------------------------------------

Message: 1
Date: Fri, 15 Oct 2010 16:40:28 +0530
From: Pradumna Maheshwari <pradumna.maheshwari@tcs.com>
Subject: [otrs] Link to reopen a ticket
To: otrs@otrs.org,      otrs-bounces@otrs.org
Message-ID:
       <OF7D3402D4.A7B0B5CE-ON652577BC.003D0CE9-652577BD.003D62D0@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=<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
************************************