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 > <[email protected]> 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 > >> <[email protected]> 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!
pgp8yqmilpEFS.pgp
Description: PGP signature
RT Training in Washington DC, USA on Oct 25 & 26 2010 Last one this year -- Learn how to get the most out of RT!
