Custome Field Problem on Upgrade to 3.6.1

RT Users
1

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

2

OK, going over the upgrade scripts, I missed this error.

When I try to run “rt-setup-database --action schema” with a text
containing the 3.3.0 RT mysql schema updates related to the custom field
modifications (including LookupType column), I get the following error,
which doesn’t make sense to me since there is no mention of that table
in the schema file:

Creating database schema.
readline() on closed filehandle SCHEMA_LOCAL at
/usr/sbin/rt-setup-database line 223.
Problem with statement:

CREATE TABLE Attachments (
id INTEGER NOT NULL AUTO_INCREMENT,
TransactionId integer NOT NULL ,
Parent integer NOT NULL DEFAULT 0 ,
MessageId varchar(160) NULL ,
Subject varchar(255) NULL ,
Filename varchar(255) NULL ,
ContentType varchar(80) NULL ,
ContentEncoding varchar(80) NULL ,
Content LONGTEXT NULL ,
Headers LONGTEXT NULL ,
Creator integer NOT NULL DEFAULT 0 ,
Created DATETIME NULL ,
PRIMARY KEY (id)
) TYPE=InnoDB
Table ‘Attachments’ already exists at /usr/sbin/rt-setup-database line 243.

– Chris

Chris Poupart wrote: