Hi all. I’ve been using RT for a few years and LOVE it. Its getting
to the point that I can’t do my job without it. Just in time for me to
break it. 
I just did an OS update (FreeBSD 4.9-Stable to 4.10-Stable) and
updated lots of third party ports (e.g. perl 5.6, apache 1.3.x, etc.).
This never caused RT problems before. However, it is the most
significant change I’ve made recently, so I’m guessing that one of the
Perl modules is on a bad version or installed wrong or is running into
an incompatibility or something… Here’s the error. If you have any
ideas, please let me know.
Thanks in advance,
Jaime
error:
Unsatisfied dependency chain in Joins Users_2 at
/usr/local/lib/perl5/site_perl/5.6.1/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/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm:889
/usr/local/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder.pm:316
/usr/local/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder.pm:109
/usr/local/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder.pm:400
/usr/local/rt-2-0-15/lib/RT/Tickets.pm:996
/usr/local/rt-2-0-15/WebRT/html/Elements/MyRequests:11
/usr/local/rt-2-0-15/WebRT/html/index.html:9
/usr/local/rt-2-0-15/WebRT/html/autohandler:58
Haul down DBIx::SearchBuilder 1.10_04. That release resolves this
issue. 1.10_05 resolves another ,that we’re working through today.
(1.10_05 should be out within a few hours)On Aug 31, 2004, at 8:16 PM, Jaime Kikpole wrote:
Hi all. I’ve been using RT for a few years and LOVE it. Its getting
to the point that I can’t do my job without it. Just in time for me
to break it. 
I just did an OS update (FreeBSD 4.9-Stable to 4.10-Stable) and
updated lots of third party ports (e.g. perl 5.6, apache 1.3.x, etc.).
This never caused RT problems before. However, it is the most
significant change I’ve made recently, so I’m guessing that one of the
Perl modules is on a bad version or installed wrong or is running into
an incompatibility or something… Here’s the error. If you have
any ideas, please let me know.
Thanks in advance,
Jaime
error:
Unsatisfied dependency chain in Joins Users_2 at
/usr/local/lib/perl5/site_perl/5.6.1/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/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm:889
/usr/local/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder.pm:316
/usr/local/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder.pm:109
/usr/local/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder.pm:400
/usr/local/rt-2-0-15/lib/RT/Tickets.pm:996
/usr/local/rt-2-0-15/WebRT/html/Elements/MyRequests:11
/usr/local/rt-2-0-15/WebRT/html/index.html:9
/usr/local/rt-2-0-15/WebRT/html/autohandler:58
The rt-users Archives
Be sure to check out the RT wiki at http://wiki.bestpractical.com
Haul down DBIx::SearchBuilder 1.10_04. That release resolves this
issue. 1.10_05 resolves another ,that we’re working through today.
(1.10_05 should be out within a few hours)
Gave that a try:
zeus# ls -l /var/db/pkg/|grep SearchBuilder
drwxr-xr-x 2 root wheel 512 Aug 31 21:12
bsdpan-DBIx-SearchBuilder-1.10_04
Got a new error:
error:
Unsatisfied dependency chain in Joins Users_2 at
/usr/local/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm line
889.
context:
…
885:
$args{‘ALIAS1’};
886:
$args{‘SearchBuilder’}->{‘left_joins’}{“$alias”}{‘criteria’}
887:
{ ‘criterion’ . $args{‘SearchBuilder’}->{‘criteria_count’}++ } =
888:
" $args{‘ALIAS1’}.$args{‘FIELD1’} = $alias.$args{‘FIELD2’}";
889:
890:
return ($alias);
891:
}
892:
893:
sub _NormalJoin {
…
code stack:
/usr/local/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm:889
/usr/local/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder.pm:316
/usr/local/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder.pm:109
/usr/local/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder.pm:400
/usr/local/rt-2-0-15/lib/RT/Tickets.pm:996
/usr/local/rt-2-0-15/WebRT/html/Elements/MyRequests:11
/usr/local/rt-2-0-15/WebRT/html/index.html:9
/usr/local/rt-2-0-15/WebRT/html/autohandler:58
Any clues? I don't understand most of the above.
If a 2-->3 upgrade is going to fix the problem and not cause others, I
would be willing to do that. It looks like RT3 and 3.2 are in the
FreeBSD ports collection. What do you think? Is the migration process
painless and/or have very little pain?
Thanks in advance,
Jaime
That line number sure doesn’t match my 1.10_04On Aug 31, 2004, at 9:16 PM, Jaime Kikpole wrote:
On Aug 31, 2004, at 8:45 PM, Jesse Vincent wrote:
Haul down DBIx::SearchBuilder 1.10_04. That release resolves this
issue. 1.10_05 resolves another ,that we’re working through today.
(1.10_05 should be out within a few hours)
Gave that a try:
zeus# ls -l /var/db/pkg/|grep SearchBuilder
drwxr-xr-x 2 root wheel 512 Aug 31 21:12
bsdpan-DBIx-SearchBuilder-1.10_04
Got a new error:
error:
Unsatisfied dependency chain in Joins Users_2 at
/usr/local/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm line
889.
context:
…
885:
$args{‘ALIAS1’};
886:
$args{‘SearchBuilder’}->{‘left_joins’}{“$alias”}{‘criteria’}
887:
{ ‘criterion’ . $args{‘SearchBuilder’}->{‘criteria_count’}++ } =
888:
" $args{‘ALIAS1’}.$args{‘FIELD1’} = $alias.$args{‘FIELD2’}";
889:
890:
return ($alias);
891:
}
892:
893:
sub _NormalJoin {
…
code stack:
/usr/local/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder/Handle.pm:889
/usr/local/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder.pm:316
/usr/local/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder.pm:109
/usr/local/lib/perl5/site_perl/5.6.1/DBIx/SearchBuilder.pm:400
/usr/local/rt-2-0-15/lib/RT/Tickets.pm:996
/usr/local/rt-2-0-15/WebRT/html/Elements/MyRequests:11
/usr/local/rt-2-0-15/WebRT/html/index.html:9
/usr/local/rt-2-0-15/WebRT/html/autohandler:58
Any clues? I don’t understand most of the above.
If a 2–>3 upgrade is going to fix the problem and not cause others,
I would be willing to do that. It looks like RT3 and 3.2 are in the
FreeBSD ports collection. What do you think? Is the migration
process painless and/or have very little pain?
Thanks in advance,
Jaime
Haul down DBIx::SearchBuilder 1.10_04. That release resolves this
issue. 1.10_05 resolves another ,that we’re working through today.
(1.10_05 should be out within a few hours)
I’m a bit new to CPAN. I think that I found directions to do this:
perl -MCPAN -e ‘install DBIx::SearchBuilder’
_ versions are ‘development’ versions. Go to search.cpan.org and
download the distribution by hand.
then untar it,
perl Makefile.PL
and ‘make install’
That line number sure doesn’t match my 1.10_04
I don't know if this helps any, but its not access to MySQL that is
the problem. Some custom additions that I wrote are still working.
(http://cns.cairodurham.org/rt/NoAuth/Summary/List.html and
http://cns.cairodurham.org/rt/NoAuth/Summary/Display.html) They still
look-up data correctly. However, attempts to reach the “home” page
(post-login) or to view a ticket (/rt/Tickets/Display.html) do not
work. They still give errors after I enter my name and password.
Any ideas?
Jaime
This is strange, but it does seem to have been the problem… I
don’t know why RT worked before and then stopped working, but an
apachectl restart gave a bunch of mod_perl errors which I managed to
trace back to Cache::Simple::TimedExpiry not being installed. I used
perl -MCPAN -e ‘install Cache::Simple::TimedExpiry’ and then apachectl
restart and then RT appeared to work correctly again.
*Phew!* Makes me realize just how valuable RT is, now that I faced
the fear of working without it. Thanks for the help, Jesse! Without
tinkering with CPAN and installing modules, I never would have figured
out the above.
Jaime