[rt-users] Problem Upgrading Database

Tue May 26 10:13:29 EDT 2009

I have since tried doing the manual upgrade from 3.3.0 (god bless VMware
snapshots!) and that upgrade seems to run but then I hit the same problems
at 3.5.1 with the same error message...

sjmarts wrote:
> 
> I wonder if someone can help me. I have spent the best part of a week
> trying to get my 3.4.5 RT database upgraded and ready for 3.8.2. I have
> read all readme files countless times and rebuilt the server from scratch
> twice now following the instructions exactly. I keep hitting the same
> error though and wonder if there is something fundementally wrong with my
> database (It is currently up and working on 3.4.5 - however I do see some
> errors in my messages file as this is running - i'll post this later in my
> post)
> 
> I am following the new install for Fedora 9 (although I am running version
> 10) and all goes absolutely fine with no error messages until I am running
> the upgrade script. This error is encountered if I run the auto script or
> the manual process of:
> 
>  rt-setup-database --action insert --datafile ./etc/upgrade/3.5.1/content
> --dba root 
> 
> I get the following errors (sorry for the long error - thought it was best
> to post it all!) - Below this error it the errors I am seeing on my
> current isntall. Any help much appreciated!!
> 
> [warning]: DBD::mysql::st execute failed: Unknown column 'ContentType' in
> 'field list' at
> /usr/lib/perl5/vendor_perl/5.10.0/DBIx/SearchBuilder/Handle.pm line 505,
> <STDIN> line 1.
> (/usr/lib/perl5/vendor_perl/5.10.0/DBIx/SearchBuilder/Handle.pm:505)
> [Tue May 26 11:19:58 2009] [warning]: RT::Handle=HASH(0xb413b74) couldn't
> execute the query 'INSERT INTO Attributes (ContentType, Creator, ObjectId,
> LastUpdatedBy, Created, Content, Description, LastUpdated, Name,
> ObjectType) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' at
> /usr/lib/perl5/vendor_perl/5.10.0/DBIx/SearchBuilder/Handle.pm line 518
> 	DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0xb413b74)',
> 'INSERT INTO Attributes (ContentType, Creator, ObjectId, LastU...',
> 'storable', 1, 1, 1, '2009-05-26 11:19:58',
> 'BQcDAAAABAoEREVTQwAAAAVPcmRlcgpDIE93bmVyID0gJ19fQ3VycmVudFVzZ...', '[_1]
> highest priority tickets I own', ...) called at
> /usr/lib/perl5/vendor_perl/5.10.0/DBIx/SearchBuilder/Handle.pm line 353
> 	DBIx::SearchBuilder::Handle::Insert('RT::Handle=HASH(0xb413b74)',
> 'Attributes', 'ContentType', 'storable', 'Creator', 1, 'ObjectId', 1,
> 'LastUpdatedBy', ...) called at
> /usr/lib/perl5/vendor_perl/5.10.0/DBIx/SearchBuilder/Handle/mysql.pm line
> 36
> 	DBIx::SearchBuilder::Handle::mysql::Insert('RT::Handle=HASH(0xb413b74)',
> 'Attributes', 'ContentType', 'storable', 'Creator', 1, 'ObjectId', 1,
> 'LastUpdatedBy', ...) called at
> /usr/lib/perl5/vendor_perl/5.10.0/DBIx/SearchBuilder/Record.pm line 1293
> 	DBIx::SearchBuilder::Record::Create('RT::Attribute=HASH(0xb517aec)',
> 'ContentType', 'storable', 'Creator', 1, 'ObjectId', 1, 'LastUpdatedBy',
> 1, ...) called at /usr/lib/perl5/vendor_perl/5.10.0/RT/Record.pm line 289
> 	RT::Record::Create('RT::Attribute=HASH(0xb517aec)', 'Name', 'Search - My
> Tickets', 'Content',
> 'BQcDAAAABAoEREVTQwAAAAVPcmRlcgpDIE93bmVyID0gJ19fQ3VycmVudFVzZ...',
> 'ContentType', 'storable', 'Description', '[_1] highest priority tickets I
> own', ...) called at
> /usr/lib/perl5/vendor_perl/5.10.0/RT/Attribute_Overlay.pm line 181
> 	RT::Attribute::Create('RT::Attribute=HASH(0xb517aec)', 'Object',
> 'RT::System=HASH(0xb51765c)', 'Name', 'Search - My Tickets',
> 'Description', '[_1] highest priority tickets I own', 'Content',
> 'HASH(0xb517afc)', ...) called at
> /usr/lib/perl5/vendor_perl/5.10.0/RT/Record.pm line 173
> 	RT::Record::AddAttribute('RT::System=HASH(0xb51765c)', 'Content',
> 'HASH(0xb517afc)', 'Description', '[_1] highest priority tickets I own',
> 'Name', 'Search - My Tickets') called at
> /usr/lib/perl5/vendor_perl/5.10.0/RT/Handle.pm line 1001
> 	RT::Handle::InsertData('RT::Handle=HASH(0xb413b74)',
> './etc/upgrade/3.5.1/content') called at /usr/sbin/rt-setup-database line
> 244
> 	main::action_insert('datafile', './etc/upgrade/3.5.1/content', 'action',
> 'insert', 'dba', 'root') called at /usr/sbin/rt-setup-database line 166
> (/usr/lib/perl5/5.10.0/Carp.pm:47)
> [Tue May 26 11:19:58 2009] [error]: Internal Error: Couldn't execute the
> query 'INSERT INTO Attributes (ContentType, Creator, ObjectId,
> LastUpdatedBy, Created, Content, Description, LastUpdated, Name,
> ObjectType) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'Unknown column
> 'ContentType' in 'field list'
> (/usr/lib/perl5/vendor_perl/5.10.0/RT/Handle.pm:1003)
> [Tue May 26 11:19:58 2009] [warning]: DBD::mysql::st execute failed:
> Unknown column 'ContentType' in 'field list' at
> /usr/lib/perl5/vendor_perl/5.10.0/DBIx/SearchBuilder/Handle.pm line 505,
> <STDIN> line 1.
> (/usr/lib/perl5/vendor_perl/5.10.0/DBIx/SearchBuilder/Handle.pm:505)
> [Tue May 26 11:19:58 2009] [warning]: RT::Handle=HASH(0xb413b74) couldn't
> execute the query 'INSERT INTO Attributes (ContentType, Creator, ObjectId,
> LastUpdatedBy, Created, Content, Name, Description, LastUpdated,
> ObjectType) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' at
> /usr/lib/perl5/vendor_perl/5.10.0/DBIx/SearchBuilder/Handle.pm line 518
> 	DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0xb413b74)',
> 'INSERT INTO Attributes (ContentType, Creator, ObjectId, LastU...',
> 'storable', 1, 1, 1, '2009-05-26 11:19:58',
> 'BQcDAAAABAoEREVTQwAAAAVPcmRlcgo6IE93bmVyID0gJ05vYm9keScgQU5EI...',
> 'Search - Unowned Tickets', ...) called at
> /usr/lib/perl5/vendor_perl/5.10.0/DBIx/SearchBuilder/Handle.pm line 353
> 	DBIx::SearchBuilder::Handle::Insert('RT::Handle=HASH(0xb413b74)',
> 'Attributes', 'ContentType', 'storable', 'Creator', 1, 'ObjectId', 1,
> 'LastUpdatedBy', ...) called at
> /usr/lib/perl5/vendor_perl/5.10.0/DBIx/SearchBuilder/Handle/mysql.pm line
> 36
> 	DBIx::SearchBuilder::Handle::mysql::Insert('RT::Handle=HASH(0xb413b74)',
> 'Attributes', 'ContentType', 'storable', 'Creator', 1, 'ObjectId', 1,
> 'LastUpdatedBy', ...) called at
> /usr/lib/perl5/vendor_perl/5.10.0/DBIx/SearchBuilder/Record.pm line 1293
> 	DBIx::SearchBuilder::Record::Create('RT::Attribute=HASH(0xb51795c)',
> 'ContentType', 'storable', 'Creator', 1, 'ObjectId', 1, 'LastUpdatedBy',
> 1, ...) called at /usr/lib/perl5/vendor_perl/5.10.0/RT/Record.pm line 289
> 	RT::Record::Create('RT::Attribute=HASH(0xb51795c)', 'Name', 'Search -
> Unowned Tickets', 'Content',
> 'BQcDAAAABAoEREVTQwAAAAVPcmRlcgo6IE93bmVyID0gJ05vYm9keScgQU5EI...',
> 'ContentType', 'storable', 'Description', '[_1] newest unowned tickets',
> ...) called at /usr/lib/perl5/vendor_perl/5.10.0/RT/Attribute_Overlay.pm
> line 181
> 	RT::Attribute::Create('RT::Attribute=HASH(0xb51795c)', 'Object',
> 'RT::System=HASH(0xb51765c)', 'Name', 'Search - Unowned Tickets',
> 'Description', '[_1] newest unowned tickets', 'Content',
> 'HASH(0xb517bac)', ...) called at
> /usr/lib/perl5/vendor_perl/5.10.0/RT/Record.pm line 173
> 	RT::Record::AddAttribute('RT::System=HASH(0xb51765c)', 'Content',
> 'HASH(0xb517bac)', 'Description', '[_1] newest unowned tickets', 'Name',
> 'Search - Unowned Tickets') called at
> /usr/lib/perl5/vendor_perl/5.10.0/RT/Handle.pm line 1001
> 	RT::Handle::InsertData('RT::Handle=HASH(0xb413b74)',
> './etc/upgrade/3.5.1/content') called at /usr/sbin/rt-setup-database line
> 244
> 	main::action_insert('datafile', './etc/upgrade/3.5.1/content', 'action',
> 'insert', 'dba', 'root') called at /usr/sbin/rt-setup-database line 166
> (/usr/lib/perl5/5.10.0/Carp.pm:47)
> [Tue May 26 11:19:58 2009] [error]: Internal Error: Couldn't execute the
> query 'INSERT INTO Attributes (ContentType, Creator, ObjectId,
> LastUpdatedBy, Created, Content, Name, Description, LastUpdated,
> ObjectType) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'Unknown column
> 'ContentType' in 'field list'
> (/usr/lib/perl5/vendor_perl/5.10.0/RT/Handle.pm:1003)
> [Tue May 26 11:19:58 2009] [warning]: DBD::mysql::st execute failed:
> Unknown column 'ContentType' in 'field list' at
> /usr/lib/perl5/vendor_perl/5.10.0/DBIx/SearchBuilder/Handle.pm line 505,
> <STDIN> line 1.
> (/usr/lib/perl5/vendor_perl/5.10.0/DBIx/SearchBuilder/Handle.pm:505)
> [Tue May 26 11:19:58 2009] [warning]: RT::Handle=HASH(0xb413b74) couldn't
> execute the query 'INSERT INTO Attributes (ContentType, Creator, ObjectId,
> LastUpdatedBy, Created, Content, Name, Description, LastUpdated,
> ObjectType) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' at
> /usr/lib/perl5/vendor_perl/5.10.0/DBIx/SearchBuilder/Handle.pm line 518
> 	DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0xb413b74)',
> 'INSERT INTO Attributes (ContentType, Creator, ObjectId, LastU...',
> 'storable', 1, 1, 1, '2009-05-26 11:19:58',
> 'BQcDAAAAAgQCAAAAAwQDAAAAAgoKTXkgVGlja2V0cwAAAARuYW1lCgZzeXN0Z...',
> 'HomepageSettings', ...) called at
> /usr/lib/perl5/vendor_perl/5.10.0/DBIx/SearchBuilder/Handle.pm line 353
> 	DBIx::SearchBuilder::Handle::Insert('RT::Handle=HASH(0xb413b74)',
> 'Attributes', 'ContentType', 'storable', 'Creator', 1, 'ObjectId', 1,
> 'LastUpdatedBy', ...) called at
> /usr/lib/perl5/vendor_perl/5.10.0/DBIx/SearchBuilder/Handle/mysql.pm line
> 36
> 	DBIx::SearchBuilder::Handle::mysql::Insert('RT::Handle=HASH(0xb413b74)',
> 'Attributes', 'ContentType', 'storable', 'Creator', 1, 'ObjectId', 1,
> 'LastUpdatedBy', ...) called at
> /usr/lib/perl5/vendor_perl/5.10.0/DBIx/SearchBuilder/Record.pm line 1293
> 	DBIx::SearchBuilder::Record::Create('RT::Attribute=HASH(0xb5176cc)',
> 'ContentType', 'storable', 'Creator', 1, 'ObjectId', 1, 'LastUpdatedBy',
> 1, ...) called at /usr/lib/perl5/vendor_perl/5.10.0/RT/Record.pm line 289
> 	RT::Record::Create('RT::Attribute=HASH(0xb5176cc)', 'Name',
> 'HomepageSettings', 'Content',
> 'BQcDAAAAAgQCAAAAAwQDAAAAAgoKTXkgVGlja2V0cwAAAARuYW1lCgZzeXN0Z...',
> 'ContentType', 'storable', 'Description', 'HomepageSettings', ...) called
> at /usr/lib/perl5/vendor_perl/5.10.0/RT/Attribute_Overlay.pm line 181
> 	RT::Attribute::Create('RT::Attribute=HASH(0xb5176cc)', 'Object',
> 'RT::System=HASH(0xb51765c)', 'Name', 'HomepageSettings', 'Description',
> 'HomepageSettings', 'Content', 'HASH(0xb56c4ec)', ...) called at
> /usr/lib/perl5/vendor_perl/5.10.0/RT/Record.pm line 173
> 	RT::Record::AddAttribute('RT::System=HASH(0xb51765c)', 'Content',
> 'HASH(0xb56c4ec)', 'Description', 'HomepageSettings', 'Name',
> 'HomepageSettings') called at
> /usr/lib/perl5/vendor_perl/5.10.0/RT/Handle.pm line 1001
> 	RT::Handle::InsertData('RT::Handle=HASH(0xb413b74)',
> './etc/upgrade/3.5.1/content') called at /usr/sbin/rt-setup-database line
> 244
> 	main::action_insert('datafile', './etc/upgrade/3.5.1/content', 'action',
> 'insert', 'dba', 'root') called at /usr/sbin/rt-setup-database line 166
> (/usr/lib/perl5/5.10.0/Carp.pm:47)
> [Tue May 26 11:19:58 2009] [error]: Internal Error: Couldn't execute the
> query 'INSERT INTO Attributes (ContentType, Creator, ObjectId,
> LastUpdatedBy, Created, Content, Name, Description, LastUpdated,
> ObjectType) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'Unknown column
> 'ContentType' in 'field list'
> (/usr/lib/perl5/vendor_perl/5.10.0/RT/Handle.pm:1003)
> 
> 
> 
> ==============================================
> 
> Error on Current working install (3.4.5):
> 
> RT: DBD::mysql::st execute failed: Unknown column 'main.LookupType' in
> 'where clause' at
> /usr/lib/perl5/vendor_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 505.
> (/usr/lib/perl5/vendor_perl/5.8.7/RT.pm:287)
> May 26 09:40:01 front RT: RT::Handle=HASH(0x8290febc) couldn't execute the
> query 'SELECT COUNT(DISTINCT main.id) FROM CustomFields main JOIN
> ObjectCustomFields ObjectCustomFields_1  ON (
> ObjectCustomFields_1.CustomField = main.id )  WHERE
> (ObjectCustomFields_1.ObjectId = '7' OR ObjectCustomFields_1.ObjectId =
> '0') AND (main.LookupType = 'RT::Queue-RT::Ticket') ' at
> /usr/lib/perl5/vendor_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 518 
> DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x8290febc)',
> 'SELECT COUNT(DISTINCT main.id) FROM CustomFields main JOIN Ob...') called
> at /usr/lib/perl5/vendor_perl/5.8.8/DBIx/SearchBuilder.pm line 294  
> DBIx::SearchBuilder::_DoCount('RT::CustomFields=HASH(0x839f57a4)') called
> at /usr/lib/perl5/vendor_perl/5.8.8/DBIx/SearchBuilder.pm line 1379  
> DBIx::SearchBuilder::Count('RT::CustomFields=HASH(0x839f57a4)') called at
> /var/www/rt3/Ticket/Elements/EditCustomFields line 53        
> HTML::Mason::Commands::__ANON__('TicketObj',
> 'RT::Ticket=HASH(0x839d8204)') called at /usr/lib/pe
> May 26 09:40:01 front RT: DBD::mysql::st execute failed: Unknown column
> 'main.LookupType' in 'where clause' at
> /usr/lib/perl5/vendor_perl/5.8.8/DBIx/SearchBuilder/Handle.pm line 505.
> (/usr/lib/perl5/vendor_perl/5.8.7/RT.pm:287)
> 
> 
> 
> 

-- 
View this message in context: http://www.nabble.com/Problem-Upgrading-Database-tp23721373p23723565.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.