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 <[email protected]> > > > > To: "Development community of OTRS.org" <[email protected]> > > > > Cc: "Development community of OTRS.org" <[email protected]>, > [email protected] > > > Date: 02/19/2010 03:40 PM > > > > Subject: Re: [dev] SQL Error in System Log > > > > Sent by: [email protected] > > > > > > > > > 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 <[email protected]> > > > To: "Development community of OTRS.org" <[email protected]> > > > Date: 02/19/2010 01:58 PM > > > Subject: Re: [dev] SQL Error in System Log > > > Sent by: [email protected] > > > > > > > > Did you disable a ticket state, or can you try rebuilding sysconfig? > > > On 19 Feb 2010 06:18, "Arpit2 G" <[email protected]> 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/
