[rt-users] After upgrade errors

[Ruslan Zakirov]

On 3/11/06, Yevgeniy Busel <yevgeniy.busel at sf.akqa.com> wrote:
> Well, upgrading was done according UPGRADING and README instructions.
Then reread them again.

> Could someone tell me what that error means, so I can start investigate
> how to solve the problem?
This error means that table has no field 'LookupType' which was added
in RT-3.3.0, see etc/upgrade/3.3.0/schema.*. While upgrade you should
upgrade your DB.

>
> RT: DBD::mysql::st execute failed: Unknown column 'main.LookupType' in
> > 'where clause' at
> > /usr/local/lib/perl5/site_perl/5.8.4/DBIx/SearchBuilder/Handle.pm
> > line 480.  (/usr/local/rt3/lib/RT.pm:277)
>
> Thank you.  Yevgeniy
> -----Original Message-----
> From: Ruslan Zakirov [mailto:ruslan.zakirov at gmail.com]
> Sent: Friday, March 10, 2006 4:32 PM
> To: Yevgeniy Busel
> Cc: rt-users at lists.bestpractical.com
> Subject: Re: [rt-users] After upgrade errors
>
> Read UPGRADING and README files.
>
> On 3/10/06, Yevgeniy Busel <yevgeniy.busel at sf.akqa.com> wrote:
> >
> >
> >
> > From: Yevgeniy Busel
> > Sent: Thursday, March 09, 2006 4:56 PM
> > To: 'rt-users at lists.bestpractical.com'
> > Subject: After upgrade errors
> >
> >
> >
> > I've upgraded RT 3.0.11 to 3.4.4 and it seems to be running fine. But
> > I have one consistent error in the log:
> >
> >
> >
> > Also, I cannot remove any old users from the old groups. However, I
> > can create new users and new groups just fine and add/remove users
> > from newly created groups just fine.  Whenever I try to delete user
> > from the old group rt just hangs for a long period of time and the
> > only way to stop it, I know of , is just to restart apache. So I
> > decided that something wrong with my upgrade and went ahead and made
> > totally new installation of RT 3.4.2 on a different machine and
> > imported my database. I still cannot remove old users and old groups
> > and  getting same error.. but in addition to that error getting a few
> new ones:
> >
> > RT: DBD::mysql::st execute failed: Unknown column 'main.LookupType' in
>
> > 'where clause' at
> > /usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm
> > line 480.  (/usr/local/rt3/lib/RT.pm:277)
> >
> > Mar  9 16:40:37 rtest RT: RT::Handle=HASH(0xa86e7a0) couldn't execute
> the
> > query 'SELECT main.* FROM CustomFields main   WHERE ((main.Disabled =
> '0'))
> > AND ((main.LookupType = 'RT::Group')or(main.LookupType = NULL)) ORDER
> > BY main.Name ASC' at
> > /usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm
> > line 494.  (/usr/local/rt3/lib/RT.pm:277)
> >
> > Mar  9 16:40:39 rtest RT: DBD::mysql::st execute failed: Unknown
> > column 'main.LookupType' in 'where clause' at
> > /usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm
> > line 480.  (/usr/local/rt3/lib/RT.pm:277)
> >
> > Mar  9 16:40:39 rtest RT: RT::Handle=HASH(0xa86e7a0) couldn't execute
> > the query 'SELECT main.* FROM CustomFields main , ObjectCustomFields
> > ObjectCustomFields_1  WHERE ((ObjectCustomFields_1.ObjectId =
> > '89')OR(ObjectCustomFields_1.ObjectId = '0')) AND ((main.Disabled =
> > '0')) AND ((main.LookupType = 'RT::Group')) AND ((main.id =
> > ObjectCustomFields_1.CustomField)) ORDER BY
> > ObjectCustomFields_1.ObjectId ASC, ObjectCustomFields_1.SortOrder ASC'
>
> > at /usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Handle.pm
> > line 494.  (/usr/local/rt3/lib/RT.pm:277)
> >
> > Mar  9 16:40:48 rtest RT: Deep recursion on subroutine
> > "RT::ACE::_Value" at
> > /usr/local/lib/perl5/site_perl/5.8.7/DBIx/SearchBuilder/Record.pm
> > line 425.  (/usr/local/rt3/lib/RT.pm:277)
> >
> > and by the way, on upgraded machine I was running freeBSD4.9, mysql
> > 4.0.20,
> > apache1.3 and perl 5.8.4
> > on new machine I'm running freeBSD6.0, mysql 4.1.13 and perl 5.8.7
> >
> > If someone knows work around, please answer. Any help would be greatly
> > appreciated.   Thank you.
> >
> >
> >
> >
> >
> >
> > Yevgeniy Busel
> > Network/System Administrator
> > yevgeniy.busel at akqa.com
> >
> > AKQA Inc.,
> > 118 King Street, 6th Floor
> > San Francisco, CA 94107
> > Tel: 415.645.9483   Fax: 415.645.9420    www.akqa.com
> >
> > _______________________________________________
> > http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> >
> > Community help: http://wiki.bestpractical.com Commercial support:
> > sales at bestpractical.com
> >
> >
> > Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
> > Buy a copy at http://rtbook.bestpractical.com
> >
> >
> > We're hiring! Come hack Perl for Best Practical:
> > http://bestpractical.com/about/jobs.html
> >
> >
>
>
> --
> Best regards, Ruslan.
>


--
Best regards, Ruslan.