<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.2769" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left> </DIV>
<DIV></DIV>
<DIV dir=ltr align=left><FONT face=Tahoma size=2><B>From:</B> Yevgeniy Busel
<BR><B>Sent:</B> Thursday, March 09, 2006 4:56 PM<BR><B>To:</B>
'rt-users@lists.bestpractical.com'<BR><B>Subject:</B> After upgrade
errors<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><SPAN class=412493400-10032006><FONT face=Arial size=2>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:</FONT></SPAN></DIV>
<DIV><SPAN class=412493400-10032006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=412493400-10032006><FONT face=Arial size=2>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)</FONT></SPAN></DIV>
<DIV><SPAN class=412493400-10032006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=412493400-10032006><FONT face=Arial size=2>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: </FONT></SPAN></DIV>
<DIV><SPAN class=412493400-10032006><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=412493400-10032006><FONT face=Arial size=2>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)</FONT></SPAN></DIV><SPAN
class=412493400-10032006>
<DIV><BR><FONT face=Arial size=2>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)</FONT></DIV>
<DIV><BR><FONT face=Arial size=2>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)</FONT></DIV>
<DIV><BR><FONT face=Arial size=2>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)</FONT></DIV>
<DIV><BR><FONT face=Arial size=2>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)</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><SPAN class=412493400-10032006></SPAN><FONT face=Arial size=2>a<SPAN
class=412493400-10032006>nd by the way, on upgraded machine I was running
freeBSD4.9, mysql 4.0.20, apache1.3 and perl 5.8.4</SPAN></FONT></DIV>
<DIV><FONT size=+0><SPAN class=412493400-10032006></SPAN><SPAN
class=412493400-10032006></SPAN><FONT face=Arial size=2>o<SPAN
class=412493400-10032006>n new machine I'm running freeBSD6.0, mysql 4.1.13 and
perl 5.8.7</SPAN></FONT></FONT></DIV>
<DIV><FONT size=+0><FONT face=Arial size=2><SPAN
class=412493400-10032006></SPAN></FONT></FONT> </DIV>
<DIV><FONT size=+0><FONT face=Arial size=2><SPAN class=412493400-10032006>If
someone knows work around, please answer. Any help would be greatly
appreciated. Thank you.</SPAN></DIV>
<DIV><BR></DIV></FONT></FONT>
<DIV><FONT face=Arial><BR><FONT size=2></FONT></FONT></DIV></SPAN>
<DIV> </DIV>
<DIV align=left>
<DIV><FONT face=Arial size=2><SPAN class=003173816-04022005>Yevgeniy
Busel</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=003173816-04022005>Network/System
Administrator</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=003173816-04022005><A
href="mailto:yevgeniy.busel@akqa.com">yevgeniy.busel@akqa.com</A></SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=003173816-04022005></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=003173816-04022005>AKQA
Inc.,</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=003173816-04022005>118 King Street, 6th
Floor</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=003173816-04022005>San Francisco, CA
94107</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN class=003173816-04022005>Tel:
415.645.9483 Fax: 415.645.9420 <A
href="http://www.akqa.com/">www.akqa.com</A></SPAN></FONT></DIV></DIV>
<DIV> </DIV></BODY></HTML>