[rt-users] Upgraded, now LimitTransactionDate broken

Ben Goodwin ben at atomicmatrix.net
Wed Jun 8 12:58:22 EDT 2005


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I upgraded from 3.2.3 to 3.4.2 last night, and this code
 
my $tickets = new RT::Tickets($RT::SystemUser);
$tickets->LimitTransactionDate( VALUE => "2005-06-01 16:49:02",
                                OPERATOR => '>');
$tickets->LimitTransactionDate( VALUE => "2005-06-08 16:49:02",
                                OPERATOR => '<');
while (my $ticket = $tickets->Next())
  {
    print $tickets->id . "\n";
  }

 
doesn't show any tickets and produces these log entries
 
[Wed Jun  8 16:51:36 2005] [warning]: Use of uninitialized value in
concatenation (.) or string at
/usr/local/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder.pm line 1171.
 (/usr/local/rt3/lib/RT.pm:277)
[Wed Jun  8 16:51:36 2005] [warning]: Use of uninitialized value in
concatenation (.) or string at
/usr/local/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder/Handle.pm line 883.
 (/usr/local/rt3/lib/RT.pm:277)
[Wed Jun  8 16:51:36 2005] [warning]: Use of uninitialized value in
concatenation (.) or string at
/usr/local/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder.pm line 1171.
 (/usr/local/rt3/lib/RT.pm:277)
[Wed Jun  8 16:51:36 2005] [warning]: Use of uninitialized value in
concatenation (.) or string at
/usr/local/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder/Handle.pm line 883.
 (/usr/local/rt3/lib/RT.pm:277)
[Wed Jun  8 16:51:36 2005] [warning]: DBD::mysql::st execute failed: Table
'rt3._4' doesn't exist at
/usr/local/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder/Handle.pm line 480.
 (/usr/local/rt3/lib/RT.pm:277)
[Wed Jun  8 16:51:36 2005] [warning]: RT::Handle=HASH(0x8bfad64) couldn't
execute the query 'SELECT DISTINCT main.* FROM ((Tickets main  JOIN  _4  ON
( _4.id = Attachments_2.TransactionId))  JOIN  _3  ON ( _3.id =
Attachments_2.TransactionId)) , Transactions Transactions_1, Attachments
Attachments_2  WHERE ((Transactions_1.ObjectType =
'RT::Ticket')or(Transactions_1.ObjectType = 'RT::Ticket')) AND
((main.EffectiveId = main.id)) AND ((main.Status != 'deleted')) AND
((main.Type = 'ticket')) AND ( (  ( (Attachments_2.Created > '2005-06-01
16:49:02')AND(main.id = Transactions_1.ObjectId) ) AND (
(Attachments_2.Created < '2005-06-08 16:49:02')AND(main.id =
Transactions_1.ObjectId) )  ) ) ' at
/usr/local/lib/perl5/site_perl/5.8.6/DBIx/SearchBuilder/Handle.pm line 494.
 (/usr/local/rt3/lib/RT.pm:277)
 
Any ideas?
 
Thanks,
 
    -=| Ben

 
Perl v5.8.6 under linux 
  Apache v1.27;
  Apache::Connection v1.00;
  Apache::Constants v1.09;
  Apache::DBI v0.94;
  Apache::Request v1.33;
  Apache::Server v1.01;
  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;
  Apache::Status v2.03;
  Apache::Table v0.01;
  AutoLoader v5.60;
  B v1.07;
  base v2.06;
  Benchmark v1.06;
  bytes v1.01;
  Cache::Simple::TimedExpiry v0.23;
  Carp v1.03;
  CGI v3.05;
  CGI::Cookie v1.24;
  CGI::Util v1.5;
  Class::Container v0.12;
  Class::Data::Inheritable v0.02;
  Class::ReturnValue v0.52;
  constant v1.04;
  Cwd v3.01;
  Data::Dumper v2.121_02;
  DBD::mysql v2.9004;
  DBI v1.47;
  DBIx::SearchBuilder v1.27;
  DBIx::SearchBuilder::Unique v0.01;
  Devel::StackTrace v1.11;
  Devel::StackTraceFrame v0.6;
  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.20;
  Exception::Class::Base v1.2;
  Exporter v5.58;
  Exporter::Heavy v5.58;
  Fcntl v1.05;
  fields v2.03;
  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.28;
  HTML::Mason::ApacheHandler v1.69;
  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.47;
  Locale::Maketext::Lexicon::Gettext v0.14;
  Log::Dispatch v2.10;
  Log::Dispatch::Base v1.09;
  Log::Dispatch::File v1.22;
  Log::Dispatch::Output v1.26;
  Log::Dispatch::Screen v1.17;
  Log::Dispatch::Syslog v1.18;
  Mail::Address v1.66;
  Mail::Field v1.66;
  Mail::Field::AddrList v1.66;
  Mail::Header v1.66;
  Mail::Internet v1.66;
  MIME::Base64 v3.05;
  MIME::Body v5.417;
  MIME::Decoder v5.417;
  MIME::Decoder::NBit 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;
  mod_perl v1.29;
  Module::Versions::Report v1.02;
  overload v1.02;
  Params::Validate v0.76;
  POSIX v1.08;
  re v0.04;
  Regexp::Common v2.119;
  Regexp::Common::_support v2.101;
  Regexp::Common::balanced v2.101;
  Regexp::Common::CC v2.100;
  Regexp::Common::comment v2.114;
  Regexp::Common::delimited v2.103;
  Regexp::Common::lingua v2.104;
  Regexp::Common::list v2.103;
  Regexp::Common::net v2.105;
  Regexp::Common::number v2.107;
  Regexp::Common::profanity v2.104;
  Regexp::Common::SEN v2.101;
  Regexp::Common::URI v2.108;
  Regexp::Common::URI::fax v2.100;
  Regexp::Common::URI::file v2.100;
  Regexp::Common::URI::ftp v2.101;
  Regexp::Common::URI::gopher v2.100;
  Regexp::Common::URI::http v2.101;
  Regexp::Common::URI::news v2.100;
  Regexp::Common::URI::pop v2.100;
  Regexp::Common::URI::prospero v2.100;
  Regexp::Common::URI::RFC1035 v2.100;
  Regexp::Common::URI::RFC1738 v2.104;
  Regexp::Common::URI::RFC1808 v2.100;
  Regexp::Common::URI::RFC2384 v2.102;
  Regexp::Common::URI::RFC2396 v2.100;
  Regexp::Common::URI::RFC2806 v2.100;
  Regexp::Common::URI::tel v2.100;
  Regexp::Common::URI::telnet v2.100;
  Regexp::Common::URI::tv v2.100;
  Regexp::Common::URI::wais v2.100;
  Regexp::Common::whitespace v2.103;
  Regexp::Common::zip v2.112;
  RT v3.4.2;
  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.05;
  Text::Autoformat v1.12;
  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;
  Tree::Simple v1.14;
  utf8 v1.04;
  vars v1.01;
  warnings v1.03;
  warnings::register v1.00;
  XSLoader v0.02;

-----BEGIN PGP SIGNATURE-----
Version: PGP Desktop 9.0.1 (Build 2179)

iQA/AwUBQqcjrlQK10CpvqFVEQKj8QCeKItr3dItHrIVdj58TgchNy2OYt0An0TV
LMaey9xDh52T1HSD/edajbI/
=05Rq
-----END PGP SIGNATURE-----
-------------- next part --------------
A non-text attachment was scrubbed...
Name: PGPexch.htm.pgp
Type: application/octet-stream
Size: 3953 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20050608/c55ed693/attachment.obj>


More information about the rt-users mailing list