Problem Upgrading Database

RT Users
1

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,
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,
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,
    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

2

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

Column ContentType is part of etc/upgrade/3.3.0/, so either your RT is
not RT 3.4.x or you skipped an upgrade long time ago.

[snip]

Best regards, Ruslan.

3

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,
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,
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,
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

4

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,
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,
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,
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

5

Greeting all,

Is there a scrip to automatically notify Admin of a queue when a ticket
is moved into their queue from another queue? The only way that I know
is by changing the queue and replying to the ticket. Otherwise, the
Admins of the queue I moved the ticket to won’t be notified.

Cheers,
Hossein Rafighi

_____ _____ _____ _ _ _ _ ____ Hossein Rafighi
|_ || _ \ | || | | || _/ || __|TRIUMF, 4004 Wesbrook Mall
| | | || ) | | | | | || || |__ Vancouver BC, Canada, V6T 2A3
| | | _ / | | | _/ || _/ || |Voice: (604) 222-1047
| | | | \ \ | | | || | | || | Fax: (604) 222-1074
|| || _|_| _/ || |||_| Website: http://www.triumf.ca

6

Just use a global scrip “Configuration → Global → Scrips → New Scrip” with the following values:
Condition: On Queue Change
Action: Notify Owner
Template: Global temlate: Transaction
Stage: TransactionCreate

And click on “Create” on the right side.

Hossein Rafighi Hossein.Rafighi@triumf.ca 2009-05-26 18:58 >>>

Greeting all,

Is there a scrip to automatically notify Admin of a queue when a ticket
is moved into their queue from another queue? The only way that I know
is by changing the queue and replying to the ticket. Otherwise, the
Admins of the queue I moved the ticket to won’t be notified.

Cheers,
Hossein Rafighi

_____ _____ _____ _ _ _ _ ____ Hossein Rafighi
|_ || _ \ | || | | || _/ || __|TRIUMF, 4004 Wesbrook Mall
| | | || ) | | | | | || || |__ Vancouver BC, Canada, V6T 2A3
| | | _ / | | | _/ || _/ || |Voice: (604) 222-1047
| | | | \ \ | | | || | | || | Fax: (604) 222-1074
|| || _|_| _/ || |||_| Website: http://www.triumf.ca

http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

7

Thanks for your reply. Close, but no cigar! Scrip runs but it doesn’t
send the email.
May 26 12:17:12 helpdesk RT: #2309/36953 - Scrip 27
NotifyAdminsOnQueueChange (/opt/rt3/bin/…/lib/RT/Action/SendEmail.pm:302)
May 26 12:17:12 helpdesk RT: No recipients found. Not sending.
(/opt/rt3/bin/…/lib/RT/Interface/Email.pm:338)

Any ideas?
Hossein

Thomas Fluch wrote:

Just use a global scrip “Configuration → Global → Scrips → New
Scrip” with the following values:
Condition: On Queue Change
Action: Notify Owner
Template: Global temlate: Transaction
Stage: TransactionCreate

And click on “Create” on the right side.

Hossein Rafighi Hossein.Rafighi@triumf.ca 2009-05-26 18:58 >>>
Greeting all,

Is there a scrip to automatically notify Admin of a queue when a ticket
is moved into their queue from another queue? The only way that I know
is by changing the queue and replying to the ticket. Otherwise, the
Admins of the queue I moved the ticket to won’t be notified.

Cheers,
Hossein Rafighi

–
_____ _____ _____ _ _ _ _ ____ Hossein Rafighi
|_ || _ \ | || | | || _/ || __|TRIUMF, 4004 Wesbrook Mall
| | | || ) | | | | | || || |__ Vancouver BC, Canada, V6T 2A3
| | | _ / | | | _/ || _/ || |Voice: (604) 222-1047
| | | | \ \ | | | || | | || | Fax: (604) 222-1074
|| || _|_| _/ || |||_| Website: http://www.triumf.ca

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

_____ _____ _____ _ _ _ _ ____ Hossein Rafighi
|_ || _ \ | || | | || _/ || __|TRIUMF, 4004 Wesbrook Mall
| | | || ) | | | | | || || |__ Vancouver BC, Canada, V6T 2A3
| | | _ / | | | _/ || _/ || |Voice: (604) 222-1047
| | | | \ \ | | | || | | || | Fax: (604) 222-1074
|| || _|_| _/ || |||_| Website: http://www.triumf.ca

8

Please ignore my previous message. It should have been obvious. Changed
the Action to Notify AdminCcs and works like a charm.

Many thanks again indeed.
Hossein

Hossein Rafighi wrote:

Thanks for your reply. Close, but no cigar! Scrip runs but it doesn’t
send the email.
May 26 12:17:12 helpdesk RT: #2309/36953 - Scrip 27
NotifyAdminsOnQueueChange (/opt/rt3/bin/…/lib/RT/Action/SendEmail.pm:302)
May 26 12:17:12 helpdesk RT: No recipients found. Not sending.
(/opt/rt3/bin/…/lib/RT/Interface/Email.pm:338)

Any ideas?
Hossein

Thomas Fluch wrote:

Just use a global scrip “Configuration → Global → Scrips → New
Scrip” with the following values:
Condition: On Queue Change
Action: Notify Owner
Template: Global temlate: Transaction
Stage: TransactionCreate

And click on “Create” on the right side.

Hossein Rafighi Hossein.Rafighi@triumf.ca 2009-05-26 18:58 >>>

Greeting all,

Is there a scrip to automatically notify Admin of a queue when a ticket
is moved into their queue from another queue? The only way that I know
is by changing the queue and replying to the ticket. Otherwise, the
Admins of the queue I moved the ticket to won’t be notified.

Cheers,
Hossein Rafighi

–
_____ _____ _____ _ _ _ _ ____ Hossein Rafighi
|_ || _ \ | || | | || _/ || __|TRIUMF, 4004 Wesbrook Mall
| | | || ) | | | | | || || |__ Vancouver BC, Canada, V6T 2A3
| | | _ / | | | _/ || _/ || |Voice: (604) 222-1047
| | | | \ \ | | | || | | || | Fax: (604) 222-1074
|| || _|_| _/ || |||_| Website: http://www.triumf.ca

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

_____ _____ _____ _ _ _ _ ____ Hossein Rafighi
|_ || _ \ | || | | || _/ || __|TRIUMF, 4004 Wesbrook Mall
| | | || ) | | | | | || || |__ Vancouver BC, Canada, V6T 2A3
| | | _ / | | | _/ || _/ || |Voice: (604) 222-1047
| | | | \ \ | | | || | | || | Fax: (604) 222-1074
|| || _|_| _/ || |||_| Website: http://www.triumf.ca

9

Hossein,

Perhaps that ticket did NOT have an owner. We do the same thing only

we set the action to “Notify AdninCcs”. Of course, the Queue has to have
an AdminCc as a queue watcher in order for someone to get the email.
Hope this helps.

Kenn
LBNLOn 5/26/2009 12:21 PM, Hossein Rafighi wrote:

Thanks for your reply. Close, but no cigar! Scrip runs but it doesn’t
send the email.
May 26 12:17:12 helpdesk RT: #2309/36953 - Scrip 27
NotifyAdminsOnQueueChange (/opt/rt3/bin/…/lib/RT/Action/SendEmail.pm:302)
May 26 12:17:12 helpdesk RT: No recipients found. Not sending.
(/opt/rt3/bin/…/lib/RT/Interface/Email.pm:338)

Any ideas?
Hossein

Thomas Fluch wrote:

Just use a global scrip “Configuration → Global → Scrips → New
Scrip” with the following values:
Condition: On Queue Change
Action: Notify Owner
Template: Global temlate: Transaction
Stage: TransactionCreate

And click on “Create” on the right side.

Hossein Rafighi Hossein.Rafighi@triumf.ca 2009-05-26 18:58 >>>

Greeting all,

Is there a scrip to automatically notify Admin of a queue when a ticket
is moved into their queue from another queue? The only way that I know
is by changing the queue and replying to the ticket. Otherwise, the
Admins of the queue I moved the ticket to won’t be notified.

Cheers,
Hossein Rafighi

–
_____ _____ _____ _ _ _ _ ____ Hossein Rafighi
|_ || _ \ | || | | || _/ || __|TRIUMF, 4004 Wesbrook Mall
| | | || ) | | | | | || || |__ Vancouver BC, Canada, V6T 2A3
| | | _ / | | | _/ || _/ || |Voice: (604) 222-1047
| | | | \ \ | | | || | | || | Fax: (604) 222-1074
|| || _|_| _/ || |||_| Website: http://www.triumf.ca

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com