[rt-users] Problem Upgrading Database

sjmarts sjmarts at gmail.com
Tue May 26 08:34:23 EDT 2009


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-tp23721373p23721373.html
Sent from the Request Tracker - User mailing list archive at Nabble.com.




More information about the rt-users mailing list