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@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/

Read UPGRADING and README files.On 3/10/06, Yevgeniy Busel yevgeniy.busel@sf.akqa.com wrote:

From: Yevgeniy Busel
Sent: Thursday, March 09, 2006 4:56 PM
To: 'rt-users@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@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@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.

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@gmail.com]
Sent: Friday, March 10, 2006 4:32 PM
To: Yevgeniy Busel
Cc: rt-users@lists.bestpractical.com
Subject: Re: [rt-users] After upgrade errors

Read UPGRADING and README files.

From: Yevgeniy Busel
Sent: Thursday, March 09, 2006 4:56 PM
To: 'rt-users@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@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@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.