[Fri Feb 11 15:04:09 2011] -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 '((st.customer_id = '6721') )(st.customer_id = '792 210') )) ORDER BY st.create_t' at line 1 at /opt/otrs//Kernel/System/DB.pm line 553. ERROR: OTRS-CGI-99 Perl: 5.10.1 OS: linux Time: Fri Feb 11 15:04:09 2011 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 '((st.customer_id = '6721') )(st.customer_id = '792 210') )) ORDER BY st.create_t' 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 sq.group_id IN (1, 2, 3) AND (((st.customer_id = '49') ((st.customer_id = '6721') )(st.customer_id = '792 210') )) ORDER BY st.create_time_unix DESC LIMIT 250' Traceback (823): Module: Kernel::System::Ticket::TicketSearch (v1.486) Line: 5115 Module: Kernel::Modules::AgentCustomerSearch::Run (v1.28) Line: 156 Module: Kernel::System::Web::InterfaceAgent::Run (v1.58) Line: 838 Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 45 Module: (eval) (v1.89) Line: 204 Module: ModPerl::RegistryCooker::run (v1.89) Line: 204 Module: ModPerl::RegistryCooker::default_handler (v1.89) Line: 170 Module: ModPerl::Registry::handler (v1.99) Line: 31 [Fri Feb 11 15:04:09 2011] -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 '((st.customer_id = '6721') )(st.customer_id = '792 210') )) LIMIT 10000' at line 1 at /opt/otrs//Kernel/System/DB.pm line 553. ERROR: OTRS-CGI-99 Perl: 5.10.1 OS: linux Time: Fri Feb 11 15:04:09 2011 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 '((st.customer_id = '6721') )(st.customer_id = '792 210') )) LIMIT 10000' at line 1, SQL: 'SELECT DISTINCT count(*) FROM ticket st, queue sq WHERE sq.id = st.queue_id AND st.ticket_state_id IN ( 1, 4, 6, 7, 8 ) AND sq.group_id IN (1, 2, 3) AND (((st.customer_id = '49') ((st.customer_id = '6721') )(st.customer_id = '792 210') )) LIMIT 10000' Traceback (852): Module: Kernel::System::Ticket::TicketSearch (v1.486) Line: 5115 Module: Kernel::Output::HTML::CustomerUserGenericTicket::Run (v1.16) Line: 142 Module: Kernel::Output::HTML::LayoutTicket::AgentCustomerViewTable (v1.122) Line: 147 Module: Kernel::Modules::AgentCustomerSearch::Run (v1.28) Line: 117 Module: Kernel::System::Web::InterfaceAgent::Run (v1.58) Line: 838 Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 45 Module: (eval) (v1.89) Line: 204 Module: ModPerl::RegistryCooker::run (v1.89) Line: 204 Module: ModPerl::RegistryCooker::default_handler (v1.89) Line: 170 Module: ModPerl::Registry::handler (v1.99) Line: 31 [Fri Feb 11 15:04:09 2011] -e: Use of uninitialized value $Count in concatenation (.) or string at /opt/otrs//Kernel/Output/HTML/CustomerUserGenericTicket.pm line 162.