[Rtir] RTIR

Wed Apr 25 11:35:10 EDT 2007

I fixed this problem in RT's repo several weeks ago, I can find
patches. Or you can downgrade SB to 1.45x or earlier.

On 4/25/07, Fernando Fugita <fugita at usp.br> wrote:
> Vicent,
>
> I running last version of SearchBuilder (1.48), and MySQL 5.0.18 in my test
> environment.
>
>
> code stack:
> /usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm:1045
> /usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder.pm:353
> /usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder.pm:430
> /usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder.pm:233
> /usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder.pm:498
> /usr/local/rt3/lib/RT/Tickets_Overlay.pm:2593
> /usr/local/rt3/share/html/RTIR/Elements/IncidentSummary:77
> /usr/local/rt3/share/html/RTIR/Tools/Lookup.html:44
> /usr/local/rt3/share/html/Widgets/TitleBox:49
> /usr/local/rt3/share/html/RTIR/Tools/Lookup.html:50
> /usr/local/rt3/share/html/autohandler:290
> raw error
>
>
> Unsatisfied dependency chain in joins Attachments_2 Transactions_1 at
> /usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 1045.
>
>
> Trace begun at /usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Exceptions.pm
> line 129
> HTML::Mason::Exceptions::rethrow_exception('Unsatisfied dependency chain in
> joins Attachments_2 Transactions_1 at
> /usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line
> 1045.^J') called at
> /usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 1045
> DBIx::SearchBuilder::Handle::_BuildJoins('RT::Handle=HASH(0x1110f218)',
> 'RT::Tickets=HASH(0x11eab464)') called at
> /usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder.pm line 353
> DBIx::SearchBuilder::_BuildJoins('RT::Tickets=HASH(0x11eab464)') called at
> /usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder.pm line 430
> DBIx::SearchBuilder::BuildSelectQuery('RT::Tickets=HASH(0x11eab464)') called at
> /usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder.pm line 233
> DBIx::SearchBuilder::_DoSearch('RT::Tickets=HASH(0x11eab464)') called at
> /usr/local/lib/perl5/site_perl/5.8.8/DBIx/SearchBuilder.pm line 498
> DBIx::SearchBuilder::Next('RT::Tickets=HASH(0x11eab464)') called at
> /usr/local/rt3/lib/RT/Tickets_Overlay.pm line 2593
> RT::Tickets::Next('RT::Tickets=HASH(0x11eab464)') called at
> /usr/local/rt3/share/html/RTIR/Elements/IncidentSummary line 77
> HTML::Mason::Commands::__ANON__('Type', 'Incident', 'ticket', 1, 'lookuptype',
> 'host', 'q', 'teste.com') called at
> /usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line 135
> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x11f05050)',
> 'Type', 'Incident', 'ticket', 1, 'lookuptype', 'host', 'q', 'teste.com') called
> at /usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1256
> eval {...} at /usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line
> 1250
> HTML::Mason::Request::comp(undef, undef, 'Type', 'Incident', 'ticket', 1,
> 'lookuptype', 'host', 'q', 'teste.com') called at
> /usr/local/rt3/share/html/RTIR/Tools/Lookup.html line 44
> HTML::Mason::Commands::__ANON__ at
> /usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1321
> HTML::Mason::Request::content('HTML::Mason::Request::ApacheHandler=HASH(0x11c99064)')
> called at /usr/local/rt3/share/html/Widgets/TitleBox line 49
> HTML::Mason::Commands::__ANON__('title', 'Incidents: teste.com') called at
> /usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line 135
> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x114feb38)',
> 'title', 'Incidents: teste.com') called at
> /usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1256
> eval {...} at /usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line
> 1250
> HTML::Mason::Request::comp(undef, undef, undef, 'title', 'Incidents: teste.com')
> called at /usr/local/rt3/share/html/RTIR/Tools/Lookup.html line 50
> HTML::Mason::Commands::__ANON__('q', 'teste.com', 'type', 'host', 'ticket', 1)
> called at /usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line
> 135
> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x11ea488c)',
> 'q', 'teste.com', 'type', 'host', 'ticket', 1) called at
> /usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1256
> eval {...} at /usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line
> 1250
> HTML::Mason::Request::comp(undef, undef, undef, 'q', 'teste.com', 'type',
> 'host', 'ticket', 1) called at /usr/local/rt3/share/html/autohandler line 290
> HTML::Mason::Commands::__ANON__('q', 'teste.com', 'type', 'host', 'ticket', 1)
> called at /usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Component.pm line
> 135
> HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x11420694)',
> 'q', 'teste.com', 'type', 'host', 'ticket', 1) called at
> /usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 1251
> eval {...} at /usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line
> 1250
> HTML::Mason::Request::comp(undef, undef, undef, 'q', 'teste.com', 'type',
> 'host', 'ticket', 1) called at
> /usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line 460
> eval {...} at /usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line
> 460
> eval {...} at /usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/Request.pm line
> 412
> HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0x11c99064)')
> called at /usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm line
> 168
> HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandler=HASH(0x11c99064)')
> called at /usr/local/lib/perl5/site_perl/5.8.8/HTML/Mason/ApacheHandler.pm line
> 826
> HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x1110a1b8)',
> 'Apache=SCALAR(0x11bfae70)') called at /usr/local/rt3/bin/webmux.pl line 123
> eval {...} at /usr/local/rt3/bin/webmux.pl line 123
> RT::Mason::handler('Apache=SCALAR(0x11bfae70)') called at /dev/null line 0
> eval {...} at /dev/null line 0
>
>
>
>
> Regards,
> Fernando.
>
>
>
> Citando Jesse Vincent <jesse at bestpractical.com>:
>
> >
> > On Apr 25, 2007, at 10:50 AM, Fernando Fugita wrote:
> >
> > > Hi,
> > >
> > > I tried to install this version, but II received this error at
> > > /RTIR/Tools/Lookup.html?ticket=1&type=host&q=teste.com :
> > >
> >
> > Are you current on DBIx::SearchBuilder? Can you give us the full
> > stack trace? Which Database/
> >
> _______________________________________________
> Rtir mailing list
> Rtir at lists.bestpractical.com
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rtir
>

-- 
Best regards, Ruslan.