an overview of my problem is below in my original post, basically upgrading to rt2 from rt1. was able to get the install working the first time, then havent been able to get to work since, weird thing is that im experiancing the problem on different machines. This is now third box i’ve tried and still getting the same error 
i originally thought was my modules, but i’ve removed and reinstalled and still nogo. I think my problem revolves around Apache::DBI , each and everytime i have followed the README to a tee , just doesn’t make sense to me
I would really appreciate any suggestions or ideas
thanks
michael----- Original Message -----
From: michael-list
To: rt-users@lists.bestpractical.com
Sent: Wednesday, July 14, 2004 2:23 AM
Subject: [rt-users] rt upgrade
Just upgraded to rt2,
Finished the install and data import from rt1, brings up login page, i can authenticate but get following error, I’m pretty sure its one of my installed modules, To me it looks like a mason error, I can log into the Admin area with no problems.just wondering if anyone can help me out
thanks all
michael
this is the Nice error:
error: Unsatisfied dependency chain in Joins Users_2 at /usr/local/share/perl/5.8.4/DBIx/SearchBuilder/Handle.pm line 889.
context: ...
885: $seen_aliases{$join} = 1;
886: }
887: else {
888: push ( @keys, $join );
889: die "Unsatisfied dependency chain in Joins @keys"
890: if $seen{"@keys"}++;
891: }
892:
893: }
...
code stack: /usr/local/share/perl/5.8.4/DBIx/SearchBuilder/Handle.pm:889
/usr/local/share/perl/5.8.4/DBIx/SearchBuilder.pm:316
/usr/local/share/perl/5.8.4/DBIx/SearchBuilder.pm:109
/usr/local/share/perl/5.8.4/DBIx/SearchBuilder.pm:400
/opt/rt2/lib/RT/Tickets.pm:996
/opt/rt2/WebRT/html/Elements/MyRequests:11
/opt/rt2/WebRT/html/index.html:9
/opt/rt2/WebRT/html/autohandler:58
And the raw error:
Unsatisfied dependency chain in Joins Users_2 at /usr/local/share/perl/5.8.4/DBIx/SearchBuilder/Handle.pm line 889.
Trace begun at /usr/local/share/perl/5.8.4/HTML/Mason/Exceptions.pm line 131
HTML::Mason::Exceptions::rethrow_exception(‘Unsatisfied dependency chain in Joins Users_2 at /usr/local/share/perl/5.8.4/DBIx/SearchBuilder/Handle.pm line 889.^J’) called at /usr/local/share/perl/5.8.4/DBIx/SearchBuilder/Handle.pm line 889
DBIx::SearchBuilder::Handle::_BuildJoins(‘RT::Handle=HASH(0x82601e4)’, ‘RT::Tickets=HASH(0x904b048)’) called at /usr/local/share/perl/5.8.4/DBIx/SearchBuilder.pm line 316
DBIx::SearchBuilder::_BuildJoins(‘RT::Tickets=HASH(0x904b048)’) called at /usr/local/share/perl/5.8.4/DBIx/SearchBuilder.pm line 109
DBIx::SearchBuilder::_DoSearch(‘RT::Tickets=HASH(0x904b048)’) called at /usr/local/share/perl/5.8.4/DBIx/SearchBuilder.pm line 400
DBIx::SearchBuilder::Next(‘RT::Tickets=HASH(0x904b048)’) called at /opt/rt2/lib/RT/Tickets.pm line 996
RT:
:Next(‘RT::Tickets=HASH(0x904b048)’) called at /opt/rt2/WebRT/html/Elements/MyRequests line 11
HTML::Mason::Commands::ANON at /usr/local/share/perl/5.8.4/HTML/Mason/Component.pm line 134
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0x902ce0c)’) called at /usr/local/share/perl/5.8.4/HTML/Mason/Request.pm line 1074
eval {…} at /usr/local/share/perl/5.8.4/HTML/Mason/Request.pm line 1068
HTML::Mason::Request::comp(undef, undef) called at /opt/rt2/WebRT/html/index.html line 9
HTML::Mason::Commands::ANON(‘pass’, , ‘user’, ) called at /usr/local/share/perl/5.8.4/HTML/Mason/Component.pm line 134
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0x8f71004)’, ‘pass’, , ‘user’, ) called at /usr/local/share/perl/5.8.4/HTML/Mason/Request.pm line 1074
eval {…} at /usr/local/share/perl/5.8.4/HTML/Mason/Request.pm line 1068
HTML::Mason::Request::comp(undef, undef, ‘pass’, , ‘user’, ) called at /usr/local/share/perl/5.8.4/HTML/Mason/Request.pm line 760
HTML::Mason::Request::call_next(‘HTML::Mason::Request::ApacheHandler=HASH(0x8fa3474)’) called at /opt/rt2/WebRT/html/autohandler line 58
HTML::Mason::Commands::ANON(‘pass’, , ‘user’, ) called at /usr/local/share/perl/5.8.4/HTML/Mason/Component.pm line 134
HTML::Mason::Component::run(‘HTML::Mason::Component::FileBased=HASH(0x8f5a448)’, ‘pass’, , ‘user’, ) called at /usr/local/share/perl/5.8.4/HTML/Mason/Request.pm line 1069
eval {…} at /usr/local/share/perl/5.8.4/HTML/Mason/Request.pm line 1068
HTML::Mason::Request::comp(undef, undef, undef, ‘pass’, , ‘user’, ) called at /usr/local/share/perl/5.8.4/HTML/Mason/Request.pm line 338
eval {…} at /usr/local/share/perl/5.8.4/HTML/Mason/Request.pm line 338
eval {…} at /usr/local/share/perl/5.8.4/HTML/Mason/Request.pm line 297
HTML::Mason::Request::exec(‘HTML::Mason::Request::ApacheHandler=HASH(0x8fa3474)’) called at /usr/local/share/perl/5.8.4/HTML/Mason/ApacheHandler.pm line 134
eval {…} at /usr/local/share/perl/5.8.4/HTML/Mason/ApacheHandler.pm line 134
HTML::Mason::Request::ApacheHandler::exec(‘HTML::Mason::Request::ApacheHandler=HASH(0x8fa3474)’) called at /usr/local/share/perl/5.8.4/HTML/Mason/ApacheHandler.pm line 792
HTML::Mason::ApacheHandler::handle_request(‘HTML::Mason::ApacheHandler=HASH(0x8260040)’, ‘Apache=SCALAR(0x8f2eb04)’) called at /opt/rt2/bin/webmux.pl line 170
RT::Mason::handler(‘Apache=SCALAR(0x8f2eb04)’) called at /dev/null line 0
eval {…} at /dev/null line 0
Be sure to check out the RT wiki at http://wiki.bestpractical.com
Be sure to check out the RT wiki at http://wiki.bestpractical.com