Upgraded from 2.3.4 to 2.4.2 on IIS6 with a MySQL DB. The dashboard is not displaying anything under "New Tickets". Also, each time I click on the dashboard there is an error generated in PerlEx.
----------- *** 'C:\otrs\bin\cgi-bin\index.pl' log message at: 2009/08/12 08:33:25 [Wed Aug 12 08:33:24 2009] -e: DBD::mysql::st execute failed: 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.ticket_lock_id IN (2) AND st.user_id IN (2) AND sq.group_id IN (1, 2, ' at line 1 at C:/otrs/bin/cgi-bin/../../Kernel/System/DB.pm line 559. ERROR: OTRS-CGI-10 Perl: 5.10.0 OS: MSWin32 Time: Wed Aug 12 08:33:24 2009 Message: 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.ticket_lock_id IN (2) AND st.user_id IN (2) AND sq.group_id IN (1, 2, ' at line 1, SQL: 'SELECT DISTINCT st.id, st.tn, st.create_time_unix 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 (2) AND sq.group_id IN (1, 2, 3, 4, 5, 6) AND st.until_time <= 1250080344 ORDER BY st.create_time_unix DESC LIMIT 10' Traceback (3332): Module: Kernel::System::Ticket::TicketSearch (v1.408) Line: 4765 Module: Kernel::Output::HTML::DashboardTicketGeneric::Run (v1.16) Line: 179 Module: Kernel::Modules::AgentDashboard::_Element (v1.14) Line: 390 Module: Kernel::Modules::AgentDashboard::Run (v1.14) Line: 245 Module: Kernel::System::Web::InterfaceAgent::Run (v1.43) Line: 819 Module: PerlEx::Precompiler::c_::otrs::bin::cgi2dbin::index_pl::__ANON__ (v1.88) Line: 48 Module: (eval) (unknown version) Line: 458 Module: PerlEx::Precompiler::Execute (unknown version) Line: 458 [Wed Aug 12 08:33:24 2009] -e: DBD::mysql::st execute failed: 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 sq.group_id IN (1, 2, 3, 4, 5, 6) AND st.until_time <= 1250080344 LIMIT ' at line 1 at C:/otrs/bin/cgi-bin/../../Kernel/System/DB.pm line 559. ERROR: OTRS-CGI-10 Perl: 5.10.0 OS: MSWin32 Time: Wed Aug 12 08:33:24 2009 Message: 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 sq.group_id IN (1, 2, 3, 4, 5, 6) AND st.until_time <= 1250080344 LIMIT ' at line 1, SQL: 'SELECT DISTINCT count(*) FROM ticket st, queue sq WHERE sq.id = st.queue_id AND st.ticket_state_id IN ( ) AND sq.group_id IN (1, 2, 3, 4, 5, 6) AND st.until_time <= 1250080344 LIMIT 10000' Traceback (3332): Module: Kernel::System::Ticket::TicketSearch (v1.408) Line: 4765 Module: Kernel::Output::HTML::DashboardTicketGeneric::Run (v1.16) Line: 198 Module: Kernel::Modules::AgentDashboard::_Element (v1.14) Line: 390 Module: Kernel::Modules::AgentDashboard::Run (v1.14) Line: 245 Module: Kernel::System::Web::InterfaceAgent::Run (v1.43) Line: 819 Module: PerlEx::Precompiler::c_::otrs::bin::cgi2dbin::index_pl::__ANON__ (v1.88) Line: 48 Module: (eval) (unknown version) Line: 458 Module: PerlEx::Precompiler::Execute (unknown version) Line: 458 [Wed Aug 12 08:33:24 2009] -e: DBD::mysql::st execute failed: 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.ticket_lock_id IN (2) AND st.user_id IN (2) AND sq.group_id IN (1, 2, ' at line 1 at C:/otrs/bin/cgi-bin/../../Kernel/System/DB.pm line 559. ERROR: OTRS-CGI-10 Perl: 5.10.0 OS: MSWin32 Time: Wed Aug 12 08:33:24 2009 Message: 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.ticket_lock_id IN (2) AND st.user_id IN (2) AND sq.group_id IN (1, 2, ' at line 1, 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 (2) AND sq.group_id IN (1, 2, 3, 4, 5, 6) AND st.until_time <= 1250080344 LIMIT 10000' Traceback (3332): Module: Kernel::System::Ticket::TicketSearch (v1.408) Line: 4765 Module: Kernel::Output::HTML::DashboardTicketGeneric::Run (v1.16) Line: 198 Module: Kernel::Modules::AgentDashboard::_Element (v1.14) Line: 390 Module: Kernel::Modules::AgentDashboard::Run (v1.14) Line: 245 Module: Kernel::System::Web::InterfaceAgent::Run (v1.43) Line: 819 Module: PerlEx::Precompiler::c_::otrs::bin::cgi2dbin::index_pl::__ANON__ (v1.88) Line: 48 Module: (eval) (unknown version) Line: 458 Module: PerlEx::Precompiler::Execute (unknown version) Line: 458 [Wed Aug 12 08:33:24 2009] -e: DBD::mysql::st execute failed: 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.responsible_user_id IN (2) AND sq.group_id IN (1, 2, 3, 4, 5, 6) AND ' at line 1 at C:/otrs/bin/cgi-bin/../../Kernel/System/DB.pm line 559. ERROR: OTRS-CGI-10 Perl: 5.10.0 OS: MSWin32 Time: Wed Aug 12 08:33:24 2009 Message: 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.responsible_user_id IN (2) AND sq.group_id IN (1, 2, 3, 4, 5, 6) AND ' at line 1, 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 (2) AND sq.group_id IN (1, 2, 3, 4, 5, 6) AND st.until_time <= 1250080344 LIMIT 10000' Traceback (3332): Module: Kernel::System::Ticket::TicketSearch (v1.408) Line: 4765 Module: Kernel::Output::HTML::DashboardTicketGeneric::Run (v1.16) Line: 198 Module: Kernel::Modules::AgentDashboard::_Element (v1.14) Line: 390 Module: Kernel::Modules::AgentDashboard::Run (v1.14) Line: 245 Module: Kernel::System::Web::InterfaceAgent::Run (v1.43) Line: 819 Module: PerlEx::Precompiler::c_::otrs::bin::cgi2dbin::index_pl::__ANON__ (v1.88) Line: 48 Module: (eval) (unknown version) Line: 458 Module: PerlEx::Precompiler::Execute (unknown version) Line: 458 [Wed Aug 12 08:33:25 2009] -e: DBD::mysql::st execute failed: 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 sq.group_id IN (1, 2, 3, 4, 5, 6) AND st.until_time >= 1250079505 ORDER ' at line 1 at C:/otrs/bin/cgi-bin/../../Kernel/System/DB.pm line 559. ERROR: OTRS-CGI-10 Perl: 5.10.0 OS: MSWin32 Time: Wed Aug 12 08:33:25 2009 Message: 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 sq.group_id IN (1, 2, 3, 4, 5, 6) AND st.until_time >= 1250079505 ORDER ' 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 sq.group_id IN (1, 2, 3, 4, 5, 6) AND st.until_time >= 1250079505 ORDER BY st.until_time ASC LIMIT 25' Traceback (3332): Module: Kernel::System::Ticket::TicketSearch (v1.408) Line: 4765 Module: Kernel::Output::HTML::DashboardCalendar::Run (v1.11) Line: 100 Module: Kernel::Modules::AgentDashboard::_Element (v1.14) Line: 390 Module: Kernel::Modules::AgentDashboard::Run (v1.14) Line: 245 Module: Kernel::System::Web::InterfaceAgent::Run (v1.43) Line: 819 Module: PerlEx::Precompiler::c_::otrs::bin::cgi2dbin::index_pl::__ANON__ (v1.88) Line: 48 Module: (eval) (unknown version) Line: 458 Module: PerlEx::Precompiler::Execute (unknown version) Line: 458
--------------------------------------------------------------------- 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 NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW! http://www.otrs.com/en/support/enterprise-subscription/
