Please let me know what steps should i follow to get rid of this error is system log. 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.

Regards, Ruzwan On Tue, Oct 12, 2010 at 4:17 PM, Ruzwan Abdul wrote:

Yes i have deleted the unused tickets directly from SQL.

Is this is a problem, please help me in fixing up the problem.

Thanks, Ruzwan

On Tue, Oct 12, 2010 at 4:02 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. stadistic problem (values in zero) (DM_Julio Angulo) 2. errror in CGI 10 OTRS SYSTEM LOG (Ruzwan Abdul) 3. Re: errror in CGI 10 OTRS SYSTEM LOG (Leonardo Certuche) 4. Help in Escalation properties of a queue (Silver springs) 5. Re: errror in CGI 10 OTRS SYSTEM LOG (Nils Leideck - ITSM)

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

Message: 1 Date: Mon, 11 Oct 2010 09:54:02 -0500 From: "DM_Julio Angulo" Subject: [otrs] stadistic problem (values in zero) To: "User questions and discussions about OTRS." Message-ID:

<0160518E5338C846B9E673C6A70D47050139162B@serv-zorexch3.infocorp.local>

Content-Type: text/plain; charset="us-ascii"

Hi, i have problems with the statistics (10042, 10043, 10044, 10045, 10046, 10047 and 10048) that do not show me time value only values zero, there is a way to correct this, if someone had the same problem, thanks.

Julio Cesar Angulo Quiroz

Telf.: 997066155