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
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [EMAIL PROTECTED]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
