[rt-users] Can't locate RT/Condition/.pm

[Kevin Falcone]

On Tue, Aug 17, 2010 at 10:14:33AM -0700, Dylan Choi wrote:
> Sorry for my insufficient explanation ;)
> 
> So when I ran "select * from Scrips", there were 2 "Autoreply" in the
> table and the latter Autoreply didn't have ScripCondition, meaning it
> was set to 0. 

The Creator/Created/LastUpdated/LastUpdatedBy fields are really
interesting when you find strange data like that.

> I may have to take a look at "upgrade-mysql-schema.pl"
> script to see why Autoreply had been inserted even though it's already
> existed in the table.

upgrade-mysql-schema.pl won't insert new data into your Scrips table

-kevin

> On Mon, Aug 16, 2010 at 5:15 AM, Kevin Falcone
> <falcone at bestpractical.com> wrote:
> > On Sun, Aug 15, 2010 at 11:19:17AM -0700, Dylan Choi wrote:
> >> Thanks a bunch Kevin. Finally, httpd runs on the system and I was able
> >> to see all the data from my old machine after I ran below sql.
> >>
> >> delete from Scrips where ScripCondition=0;
> >
> > It might have been better to select * from Scrips where ScripCondition
> > = 0; and then go fix it in the UI.  It isn't clear to me why you had
> > blank condition scrips in the first place.
> >
> > -kevin
> >
> >> On Sun, Aug 15, 2010 at 6:35 AM, Kevin Falcone
> >> <falcone at bestpractical.com> wrote:
> >> > On Sun, Aug 15, 2010 at 02:14:36AM -0700, Dylan Choi wrote:
> >> >> Hello,
> >> >>
> >> >> I'm currently running RT(3.6.6) and trying to upgrade system hardwares
> >> >> as well as RT itself. I have setup a latest RT(3.8.8) on my brand new
> >> >> system and with just fresh setup, it works fine. However, since I've
> >> >> restored dumped mysql data from RT 3.6.6 and upgraded database scheme
> >> >> using "upgrade-mysql-schema.pl", httpd always fails to start. Below is
> >> >> the error messages in error_log and there are no errors in rt.log
> >> >> (..../rt3/var/log/rt.log). I'm really trying to figure out why perl
> >> >> can't locate RT::Condition modules when httpd starts. Please shed some
> >> >> lights on me. Thanks !
> >> >
> >> > One of your scrips has a blank condition, you'll need to find it and
> >> > fix it.
> >> >
> >> > -kevin
> >> >
> >> >> I'm running RT 3.8.8 with following packages.
> >> >> - CentOS 5.5
> >> >> - httpd-2.2.3-43
> >> >> - mod_perl-2.0.4-6
> >> >> - mysql-5.0.77-4
> >> >>
> >> >> --------------- error_log
> >> >> [Sun Aug 15 08:28:28 2010] [error] Require of RT::Condition::
> >> >> failed.\nCan't locate RT/Condition/.pm in @INC (@INC contains:
> >> >> /data/www/rt3/bin/../local/lib /data/www/rt3/bin/../lib
> >> >> /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi
> >> >> /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl
> >> >> /usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi
> >> >> /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl
> >> >> /usr/lib/perl5/5.8.8/i386-linux-thread-multi /usr/lib/perl5/5.8.8 .
> >> >> /etc/httpd) at (eval 1326) line 3.\n\nCompilation failed in require at
> >> >> (eval 2) line 1.\n
> >> >> [Sun Aug 15 08:28:28 2010] [error] Can't load Perl file:
> >> >> /data/www/rt3/bin/webmux.pl for server foo.mydomain.com:0, exiting...
> >> >> ----------------
> >> >>
> >> >> -Dylan
> >> >>
> >> >> RT Training in Washington DC, USA on Oct 25 & 26 2010
> >> >> Last one this year -- Learn how to get the most out of RT!
> >> >
> >> >
> >> > RT Training in Washington DC, USA on Oct 25 & 26 2010
> >> > Last one this year -- Learn how to get the most out of RT!
> >> >
> >>
> >>
> >>
> >> --
> >> - Dylan Choi
> >>
> >> RT Training in Washington DC, USA on Oct 25 & 26 2010
> >> Last one this year -- Learn how to get the most out of RT!
> >
> >
> > RT Training in Washington DC, USA on Oct 25 & 26 2010
> > Last one this year -- Learn how to get the most out of RT!
> >
> 
> 
> 
> -- 
> - Dylan Choi
> 
> RT Training in Washington DC, USA on Oct 25 & 26 2010
> Last one this year -- Learn how to get the most out of RT!
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 195 bytes
Desc: not available
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20100817/8e2d7424/attachment.sig>