[rt-users] Custome Field Problem on Upgrade to 3.6.1

[Chris Poupart]

Hi,

I recently upgraded my installation from 3.2.2 to 3.6.1 and it would 
seem as though the custom fields were not properly modified in the database.

I have ensured that my users have SeeCustomFields, etc, but nothing works.

I have a similar problem with the RTFM upgrade -- all of the custom 
fields are no longer there (making the RTFM fairly useless at the moment 
as well!)

My logs give this error when any page loads that is supposed to contain 
a custom field:

-----
 RT: RT::Handle=HASH(0x98badec) couldn't execute the query 'SELECT 
DISTINCT main.* FROM CustomFields main , ObjectCustomFields 
ObjectCustomFields_1  WHERE ((ObjectCustomFields_1.ObjectId = '0')) AND 
((main.Disabled = '0')) AND ((main.LookupType = 'RT::Queue-RT::Ticket')) 
AND ((main.id = ObjectCustomFields_1.CustomField))  ORDER BY 
main.SortOrder ASC, main.id ASC ' at 
/usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 518 
^IDBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x98badec)', 
'SELECT DISTINCT main.* FROM CustomFields main , ObjectCustomF...') 
called at /usr/share/perl5/DBIx/SearchBuilder.pm line 231 
^IDBIx::SearchBuilder::_DoSearch('RT::CustomFields=HASH(0xa5a4670)') 
called at /usr/share/request-tracker3.6/lib/RT/CustomFields_Overlay.pm 
line 170 
^IRT::CustomFields::_DoSearch('RT::CustomFields=HASH(0xa5a4670)') called 
at /usr/share/perl5/DBIx/SearchBuilder.pm line 491 
^IDBIx::SearchBuilder::Next('RT::CustomFields=HASH(0xa5a4670)') called 
at /usr/share/request-tracker3.6/lib/R
-----

The problem seems to stem from a lack of the main.LookupType column.

Any ideas on how to properly resolve this would be much appreciated.

-- Chris