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

[Chris Poupart]

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:
> 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: sales at bestpractical.com
>
>
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com