[rt-users] After upgrade errors

[Ruslan Zakirov]

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:
>
> 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)
>
> 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.