Hello Michiel,
Still getting the same error, even after disabling the "New Ticket".
but i don't want to disable this feature. Please suggest me will these
error cause any trouble to OTRS system.
Thanks & Regards
Arpit Gupta
ESM Sub Focus Area, TEG Open Source Platform
Tata Consultancy Services
Cell:- 91-9769256991
Mailto: arpit2.g@tcs.com
Website: http://www.tcs.com
____________________________________________
Experience certainty. IT Services
Business Solutions
Outsourcing
____________________________________________
From: Michiel Beijen
To: "Development community of OTRS.org"
Date: 02/22/2010 05:02 PM
Subject: Re: [dev] SQL Error in System Log
Sent by: dev-bounces@otrs.org
Sure. In this case you have the "New Tickets" dashboard item that will
generate these errors. Please just disable and/or modify
DashboardBackend####0120-TicketNew in Sysconfig. You can find it under
Admin > SysConfig > Ticket > Agent::Dashboard.
--
Michiel Beijen
R&D
OTRS AG
Norsk-Data-Str 1.
61352 Bad Homburg
Germany
T: +31 (0) 6457 42418
F: +49 (0) 9421 56818-18
I: http://www.otrs.com/
Business Location: Bad Homburg, Country Court: Bad Homburg, HRB 10751, VAT
ID: 003 240
97505 Chairman of the Board: Burchard Steinbild, Managing Board: André
Mindermann
CU@ CeBIT 2010 in Hannover (Germany) and get to know more about OTRS at
booth no. C37, in hall 2 from March 2-6, 2010!
On Fri, 2010-02-19 at 15:52 +0530, Arpit2 G wrote:
same error even after running otrs.RebuildConfig.pl :(
Thanks & Regards
Arpit Gupta
From: Arpit2 G
To: "Development community of OTRS.org"
Cc: "Development community of OTRS.org" ,
dev-bounces@otrs.org
Date: 02/19/2010 03:40 PM
Subject: Re: [dev] SQL Error in System Log
Sent by: dev-bounces@otrs.org
Hello Michiel,
I had just renamed the "New" state to "registered" in status and
"ZZZAuto".
I will try to rebuild the config.
Thanks & Regards
Arpit Gupta
From: Michiel Beijen
To: "Development community of OTRS.org"
Date: 02/19/2010 01:58 PM
Subject: Re: [dev] SQL Error in System Log
Sent by: dev-bounces@otrs.org
Did you disable a ticket state, or can you try rebuilding sysconfig?
On 19 Feb 2010 06:18, "Arpit2 G" wrote:
Hello Everyone,
I have OTRS 2.4.5 on windows 2008 with MSSQL as the DB. I am
getting
some
SQL error in the log, when i click on Dashboard.
[Fri Feb 19 05:46:49
2010][Error][Kernel::System::Ticket::TicketSearch][4752]
[Microsoft][ODBC
SQL Server Driver][SQL Server]Incorrect syntax near ')'.
(SQL-42000)
[Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s)
could not
be
prepared. (SQL-42000), 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.ticket_lock_id IN (2) AND st.user_id IN (1) AND
st.ticket_state_id IN (7) AND st.until_time <= 1266554749
ORDER BY
st.until_time DESC'
[Fri Feb 19 05:46:49
2010][Error][Kernel::System::Ticket::TicketSearch][4752]
[Microsoft][ODBC
SQL Server Driver][SQL Server]Incorrect syntax near ')'.
(SQL-42000)
[Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s)
could not
be
prepared. (SQL-42000), SQL: 'SELECT DISTINCT count(*) FROM
ticket st,
queue
sq WHERE sq.id = st.queue_id AND st.ticket_state_id IN ( )
AND
st.ticket_state_id IN (7) AND st.until_time <= 1266554749'
[Fri Feb 19 05:46:49
2010][Error][Kernel::System::Ticket::TicketSearch][4752]
[Microsoft][ODBC
SQL Server Driver][SQL Server]Incorrect syntax near ')'.
(SQL-42000)
[Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s)
could not
be
prepared. (SQL-42000), SQL: 'SELECT DISTINCT count(*) FROM
ticket st,
queue
sq WHERE sq.id = st.queue_id AND st.ticket_state_id IN ( )
AND
st.ticket_lock_id IN (2) AND st.user_id IN (1) AND
st.ticket_state_id
IN
(7) AND st.until_time <= 1266554749'
[Fri Feb 19 05:46:49
2010][Error][Kernel::System::Ticket::TicketSearch][4752]
[Microsoft][ODBC
SQL Server Driver][SQL Server]Incorrect syntax near ')'.
(SQL-42000)
[Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s)
could not
be
prepared. (SQL-42000), SQL: 'SELECT DISTINCT count(*) FROM
ticket st,
queue
sq WHERE sq.id = st.queue_id AND st.ticket_state_id IN ( )
AND
st.queue_id IN (3, 4, 6, 8, 13, 14, 15, 16, 17, 18, 19, 20, 21,
23,
24, 25,
26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41,
42,
43, 44,
45, 46, 47, 48, 49, 50, 51, 52) AND st.ticket_state_id IN (7)
AND
st.until_time <= 1266554749'
[Fri Feb 19 05:46:49
2010][Error][Kernel::System::Ticket::TicketSearch][4752]
[Microsoft][ODBC
SQL Server Driver][SQL Server]Incorrect syntax near ')'.
(SQL-42000)
[Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s)
could not
be
prepared. (SQL-42000), SQL: 'SELECT DISTINCT count(*) FROM
ticket st,
queue
sq WHERE sq.id = st.queue_id AND st.ticket_state_id IN ( )
AND
st.responsible_user_id IN (1) AND st.ticket_state_id IN (7)
AND
st.until_time <= 1266554749'
[Fri Feb 19 05:46:49
2010][Error][Kernel::System::Ticket::TicketSearch][4752]
[Microsoft][ODBC
SQL Server Driver][SQL Server]Incorrect syntax near ')'.
(SQL-42000)
[Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s)
could not
be
prepared. (SQL-42000), 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.ticket_state_id IN (7) AND st.until_time <= 1266554749'
[Fri Feb 19 05:46:49
2010][Error][Kernel::System::Ticket::TicketSearch][4752]
[Microsoft][ODBC
SQL Server Driver][SQL Server]Incorrect syntax near ')'.
(SQL-42000)
[Microsoft][ODBC SQL Server Driver][SQL Server]Statement(s)
could not
be
prepared. (SQL-42000), 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.ticket_state_id IN (7) AND st.until_time >=
1266553909
ORDER BY st.until_time ASC'
The reason of this issue as of my understanding is
"st.ticket_state_id IN
( )", there is no value in IN( ) but what is the reason behind
this,
why
this happening, Please guide me.
Thanks & Regards
Arpit Gupta
=====-----=====-----=====
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
---------------------------------------------------------------------
OTRS mailing list: dev - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/dev
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/
---------------------------------------------------------------------
OTRS mailing list: dev - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/dev
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/
=====-----=====-----=====
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
---------------------------------------------------------------------
OTRS mailing list: dev - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/dev
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/
=====-----=====-----=====
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
---------------------------------------------------------------------
OTRS mailing list: dev - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/dev
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/
---------------------------------------------------------------------
OTRS mailing list: dev - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/dev
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/dev
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/
=====-----=====-----=====
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
