[rt-users] A bug? Searchbuilder?

Torsten Brumm tob at brummix.de
Mon May 8 09:32:40 EDT 2006


Hi Rangarajan,

I'm using Mysql 4.12, i have also tried  to update DBIxSearchbuilder 
from the old version to the newest, same result.

 > If you can, you may want to print out the query that is being 
generated by putting some debug statement in DBIx::SearchBuilder. And 
see if it runs against the database you are using.

How can i do this? Now idea at this moment.

Thanks

Torsten

PS: The problem looks similar to yours. i also have tried this with 
3.6pre1, same result.


Rangarajan Radhakrishnan schrieb:
>
> Torsten Brumm wrote:
>
>> Hi RT Users,
>>
>> I think, i found a bug, or i'm too dumb.
>>
>> I'm trying the following query (from within a website, but also 
>> occurs from the Query Builder)
>>
>> ( Queue = 'GAI_ABF_NW' ) AND ( 'CF.{Tournummer}' = '03376' OR 
>> 'CF.{Tournummer}' = '03361' ) AND ( Status = 'new' OR Status = 'open' 
>> Or Status = 'stalled' OR Status = 'resolved')
>>
>> In this Query, CF.{Tournummer} is a normal Custom field.
>>
>> If i fire this Query i get the following error:
>>
>> [Mon May 08 13:00:45 2006] [error] [client 10.63.253.97] FastCGI: 
>> server "/opt/rt3/bin/mason_handler.fcgi" stderr: 
>> \tHTML::Mason::CGIHandler::_handler('HTML::Mason::CGIHandler=HASH(0x9dec5d8)', 
>> 'HASH(0x9f06f28)') called at 
>> /usr/lib/perl5/vendor_perl/5.8.6/HTML/Mason/CGIHandler.pm line 73, 
>> referer: http://astdev.int.kn/Sendungen/index.html
>>
>> I'm running RT 3.5.6 on Fedora Core:
>>
>> Perl v5.8.6 under linux
>>  Apache::Session v1.6;
>>  Apache::Session::Generate::MD5 v2.1;
>>  Apache::Session::Lock::MySQL v1.00;
>>  Apache::Session::MySQL v1.01;
>>  Apache::Session::Serialize::Storable v1.00;
>>  Apache::Session::Store::DBI v1.02;
>>  Apache::Session::Store::MySQL v1.04;
>>  AutoLoader v5.60;
>>  base v2.06;
>>  Benchmark v1.06;
>>  bytes v1.01;
>>  Cache::Simple::TimedExpiry v0.23;
>>  capitalization v0.03;
>>  Carp v1.03;
>>  CGI v3.10;
>>  CGI::Cookie v1.25;
>>  CGI::Fast v1.05;
>>  CGI::Util v1.5;
>>  Class::Container v0.12;
>>  Class::Data::Inheritable v0.04;
>>  Class::ReturnValue v0.53;
>>  Clone v0.18;
>>  constant v1.04;
>>  Cwd v3.01;
>>  Data::Dumper v2.121_02;
>>  Date::Format v2.22;
>>  Date::Parse v2.27;
>>  DBD::mysql v2.9007;
>>  DBI v1.48;
>>  DBIx::SearchBuilder v1.38;
>>  DBIx::SearchBuilder::Union v0;
>>  DBIx::SearchBuilder::Unique v0.01;
>>  Devel::StackTrace v1.12;
>>  Devel::StackTraceFrame v0.6;
>>  Devel::Symdump v2.03;
>>  Digest::base v1.00;
>>  Digest::MD5 v2.33;
>>  DynaLoader v1.05;
>>  Encode v2.08;
>>  Encode::Alias v2.02;
>>  Encode::Config v2.00;
>>  Encode::Encoding v2.02;
>>  Errno v1.09;
>>  Exception::Class v1.21;
>>  Exception::Class::Base v1.2;
>>  Exporter v5.58;
>>  Exporter::Heavy v5.58;
>>  FCGI v0.67;
>>  Fcntl v1.05;
>>  File::Basename v2.73;
>>  File::Glob v1.03;
>>  File::Path v1.06;
>>  File::Spec v3.01;
>>  File::Spec::Unix v1.5;
>>  File::Temp v0.14;
>>  FileHandle v2.01;
>>  HTML::Entities v1.29;
>>  HTML::Mason v1.3101;
>>  HTML::Mason::CGIHandler v1.00;
>>  HTML::Mason::Exception v1.1;
>>  HTML::Mason::Exception::Abort v1.1;
>>  HTML::Mason::Exception::Compilation v1.1;
>>  HTML::Mason::Exception::Compilation::IncompatibleCompiler v1.1;
>>  HTML::Mason::Exception::Compiler v1.1;
>>  HTML::Mason::Exception::Decline v1.1;
>>  HTML::Mason::Exception::Params v1.1;
>>  HTML::Mason::Exception::Syntax v1.1;
>>  HTML::Mason::Exception::System v1.1;
>>  HTML::Mason::Exception::TopLevelNotFound v1.1;
>>  HTML::Mason::Exception::VirtualMethod v1.1;
>>  HTML::Mason::Exceptions v1.43;
>>  HTML::Parser v3.45;
>>  HTML::Scrubber v0.08;
>>  I18N::LangTags v0.35;
>>  I18N::LangTags::Detect v1.03;
>>  integer v1.00;
>>  IO v1.21;
>>  IO::File v1.10;
>>  IO::Handle v1.24;
>>  IO::InnerFile v2.110;
>>  IO::Lines v2.110;
>>  IO::Scalar v2.110;
>>  IO::ScalarArray v2.110;
>>  IO::Seekable v1.09;
>>  IO::Wrap v2.110;
>>  IO::WrapTie v2.110;
>>  IPC::Open2 v1.01;
>>  IPC::Open3 v1.0106;
>>  lib v0.5565;
>>  List::Util v1.14;
>>  locale v1.00;
>>  Locale::Maketext v1.09;
>>  Locale::Maketext::Fuzzy v0.02;
>>  Locale::Maketext::Lexicon v0.53;
>>  Locale::Maketext::Lexicon::Gettext v0.14;
>>  Log::Dispatch v2.11;
>>  Log::Dispatch::Base v1.09;
>>  Log::Dispatch::Output v1.26;
>>  Log::Dispatch::Screen v1.17;
>>  Log::Dispatch::Syslog v1.18;
>>  Mail::Address v1.67;
>>  Mail::Field v1.67;
>>  Mail::Field::AddrList v1.67;
>>  Mail::Field::Date v1.67;
>>  Mail::Header v1.67;
>>  Mail::Internet v1.67;
>>  MIME::Base64 v3.05;
>>  MIME::Body v5.417;
>>  MIME::Decoder v5.417;
>>  MIME::Entity v5.417;
>>  MIME::Field::ContDisp v5.417;
>>  MIME::Field::ConTraEnc v5.417;
>>  MIME::Field::ContType v5.417;
>>  MIME::Field::ParamVal v5.417;
>>  MIME::Head v5.417;
>>  MIME::Parser v5.417;
>>  MIME::QuotedPrint v3.03;
>>  MIME::Tools v5.417;
>>  MIME::Words v5.417;
>>  Module::Refresh v0.08;
>>  Module::Versions::Report v1.02;
>>  overload v1.02;
>>  Params::Validate v0.78;
>>  POSIX v1.08;
>>  re v0.04;
>>  Regexp::Common v2.120;
>>  Regexp::Common::delimited v2.104;
>>  RT v3.5.6;
>>  RT::Interface::Email v1.02;
>>  Scalar::Util v1.14;
>>  SelectSaver v1.00;
>>  Socket v1.77;
>>  Storable v2.13;
>>  strict v1.03;
>>  Symbol v1.05;
>>  Sys::Hostname v1.11;
>>  Sys::Syslog v0.08;
>>  Text::Autoformat v1.13;
>>  Text::Quoted v1.8;
>>  Text::Reform v1.11;
>>  Text::Tabs v98.112801;
>>  Text::Template v1.44;
>>  Text::Wrapper v1.000;
>>  Time::HiRes v1.65;
>>  Time::JulianDay v2003.1125;
>>  Time::Local v1.1;
>>  Time::ParseDate v2003.1126;
>>  Time::Timezone v2003.0211;
>>  Time::Zone v2.22;
>>  utf8 v1.04;
>>  vars v1.01;
>>  warnings v1.03;
>>  warnings::register v1.00;
>>  XSLoader v0.02;
>>
>> Any Ideas or hints???
>>
>> Thanks
>>
>> Torsten
>> _______________________________________________
>> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>>
>> Community help: http://wiki.bestpractical.com
>> Commercial support: sales at bestpractical.com
>>
>>
>> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
>> Buy a copy at http://rtbook.bestpractical.com
>>
>>
>> We're hiring! Come hack Perl for Best Practical: 
>> http://bestpractical.com/about/jobs.html
>>
> I think I had come across the same problem using 3.6.0pre0. Seems to 
> happen when the same custom field is involved in more than one clause 
> in the query. Please see:
> http://lists.bestpractical.com/pipermail/rt-users/2006-May/039046.html
>
> I haven't had a chance to dig deeper to fix this.
>
> If you can, you may want to print out the query that is being 
> generated by putting some debug statement in DBIx::SearchBuilder. And 
> see if it runs against the database you are using. What database are 
> you using?
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
>
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com
>
>
> We're hiring! Come hack Perl for Best Practical: 
> http://bestpractical.com/about/jobs.html




More information about the rt-users mailing list