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. 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.
-Dylan On Mon, Aug 16, 2010 at 5:15 AM, Kevin Falcone <falc...@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 >> <falc...@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!