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::handler (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::handler (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