Upgraded, now LimitTransactionDate broken

-----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-----

PGPexch.htm.pgp (3.86 KB)