Re: [otrs] otrs Digest, Vol 25, Issue 36

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 Sat, Oct 16, 2010 at 5:30 PM, 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. Re: otrs Digest, Vol 25, Issue 35 (Ruzwan Abdul) 2. Re: Customer with multiple email addresses (Broderick Wood) 3. Comparing OTRS with other ticket system (Darshak)

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

Message: 1 Date: Sat, 16 Oct 2010 08:55:29 +0530 From: Ruzwan Abdul Subject: Re: [otrs] otrs Digest, Vol 25, Issue 35 To: otrs@otrs.org Message-ID: Content-Type: text/plain; charset="iso-8859-1"

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, 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 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 : :/// customer.pl?Action=CustomerTicketZoom&TicketID=http://customer.pl/?Action=CustomerTicketZoom&TicketID= http://customer.pl/?Action=CustomerTicketZoom&TicketID=

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