
Hi, Can anyone help? OTRS is not currently returning any results on the ticket search even though I know there are some matches. I have included the lines from our logs. -e: DBD::mysql::st execute failed: Got error 134 from storage engine at /opt/otrs//Kernel/System/DB.pm line 440, <PRODUCT> line 48. ERROR: OTRS-CGI-10 Perl: 5.8.5 OS: linux Time: Fri Mar 9 16:56:13 2007 Message: Got error 134 from storage engine, SQL: 'SELECT at.id FROM article at WHERE at.ticket_id = 50644 ORDER BY at.id' Traceback (3460): Module: Kernel::System::Ticket::Article::ArticleIndex (v1.94) Line: 855 Module: Kernel::System::Ticket::Article::ArticleFirstArticle (v1.94) Line: 789 Module: Kernel::Modules::AgentTicketSearch::Run (v1.10) Line: 304 Module: Kernel::System::Web::InterfaceAgent::Run (v1.8) Line: 651 Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::han dler (v) Line: 48 Module: (eval) (v1.80) Line: 202 Module: ModPerl::RegistryCooker::run (v1.80) Line: 202 Module: ModPerl::RegistryCooker::default_handler (v1.80) Line: 168 Module: ModPerl::Registry::handler (v1.99) Line: 30 [Fri Mar 9 16:56:13 2007] -e: DBD::mysql::st fetchrow_array failed: fetch() without execute() at /opt/otrs//Kernel/System/DB.pm line 477, <PRODUCT> line 48. ERROR: OTRS-CGI-10 Perl: 5.8.5 OS: linux Time: Fri Mar 9 16:56:13 2007 Message: No article found for TicketID 50644! Traceback (3460): Module: Kernel::System::Ticket::Article::ArticleFirstArticle (v1.94) Line: 795 Module: Kernel::Modules::AgentTicketSearch::Run (v1.10) Line: 304 Module: Kernel::System::Web::InterfaceAgent::Run (v1.8) Line: 651 Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::han dler (v) Line: 48 Module: (eval) (v1.80) Line: 202 Module: ModPerl::RegistryCooker::run (v1.80) Line: 202 Module: ModPerl::RegistryCooker::default_handler (v1.80) Line: 168 Module: ModPerl::Registry::handler (v1.99) Line: 30 Thanks, Donna

Grant, DM ((Donna)) wrote:
Can anyone help? OTRS is not currently returning any results on the ticket search even though I know there are some matches. I have included the lines from our logs.
<snip>
What version of OTRS? Did you recently upgrade? If so, was the database schema updated as well? Nils Breunese.
participants (2)
-
Grant, DM (Donna)
-
Nils Breunese (Lemonbit)