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