I feared that might be the answer... Someone else upgraded last time and went to 3.4.5. I suspected they may not have run the update correctly.
The question is - is there anything I can do now with the database?? Thanks for your prompt reply! 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-tp23721373p23722433.html Sent from the Request Tracker - User mailing list archive at Nabble.com. _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: sa...@bestpractical.com Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com