[rt-users] Unknown column 'main.Disabled' in 'where clause'

James McTavish jmctavish at matrixorbital.ca
Fri Jul 15 16:38:09 EDT 2005


I have just finished upgrading from 3.2.1 to 3.4.2 and everything is  
running smoothly except for custom fields.  When I bring up a ticket,  
I get a ton of these errors in the apache logs (repeated several times):

FastCGI: server "/var/www/rt/rt-3.4.2/bin/mason_handler.fcgi" stderr:  
DBD::mysql::st execute failed: Unknown column 'main.Disabled' in  
'where clause' at /usr/lib/perl5/vendor_perl/5.8.6/DBIx/SearchBuilder/ 
Handle.pm line 480., referer: http://rt/Search/Results.html? 
Query=Queue%20=%20'Technical%20Support'%20AND%20(Status%20=%20'open'% 
20OR%20Status%20=%20'new')&Rows=50

FastCGI: server "/var/www/rt/rt-3.4.2/bin/mason_handler.fcgi" stderr:  
RT::Handle=HASH(0x95d6ba0) couldn't execute the query 'SELECT count 
(main.id) FROM ObjectCustomFieldValues main   WHERE ((main.Disabled =  
'0')) AND ((main.ObjectId = '23707')) AND ((main.ObjectType =  
'RT::Transaction')) ' at /usr/lib/perl5/vendor_perl/5.8.6/DBIx/ 
SearchBuilder/Handle.pm line 494., referer: http://rt/Search/ 
Results.html?Query=Queue%20=%20'Technical%20Support'%20AND%20(Status% 
20=%20'open'%20OR%20Status%20=%20'new')&Rows=50

And when I try to edit custom fields I get:

FastCGI: server "/var/www/rt/rt-3.4.2/bin/mason_handler.fcgi" stderr:  
DBD::mysql::st execute failed: Unknown column 'Disabled' in 'field  
list' at /usr/lib/perl5/vendor_perl/5.8.6/DBIx/SearchBuilder/ 
Handle.pm line 480., referer: http://rt/Ticket/Modify.html?id=4798

FastCGI: server "/var/www/rt/rt-3.4.2/bin/mason_handler.fcgi" stderr:  
RT::Handle=HASH(0x95d6ba0) couldn't execute the query 'INSERT INTO  
ObjectCustomFieldValues (ContentType, LargeContent, CustomField,  
Creator, ObjectId, LastUpdatedBy, Disabled, Created, Content,  
ContentEncoding, LastUpdated, ObjectType) VALUES  
(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' at /usr/lib/perl5/vendor_perl/ 
5.8.6/DBIx/SearchBuilder/Handle.pm line 494., referer: http://rt/ 
Ticket/Modify.html?id=4798

I found elsewhere similar errors and the solution was to clear out  
the Mason cache.  The mason directories look empty and I've restarted  
the Apache server.  Is there anything else I can do or look at?

--
-James




More information about the rt-users mailing list