Hi Jeff, Can you please report this on http://bugs.otrs.org ?
Kindest regards, -- Michiel Beijen Software Consultant +31 6 - 457 42 418 Bee Free IT + http://beefreeit.nl On Wed, Aug 12, 2009 at 14:36, Jeff Travers <[email protected]> wrote: > 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/ >
--------------------------------------------------------------------- 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/
