[rt-users] After upgrade errors

[Yevgeniy Busel]

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://www.akqa.com/> 
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20060310/8ec14b9d/attachment.htm>