Rt-2-0-15 to rt-3.2.2 using rt2-to-rt3-1.23 fails

RT Users
1

I have searched all the threads, and haven’t found a solution.

Tested on

Fedora core 2
Suse 8.1

apache_1.3.31
mod_perl-1.29
mod_ssl-2.8.19-1.3.31
mysql-4.0.21
openssl-0.9.7d
php-4.3.8

Fresh install of all perl modules

rt-2.0-to-dumpfile works with no errors.

I get these errors every time, even if I create three test tickets in
rt-2-0-15 and try to export/import them.

Been trying to fix this for 3 days, help please.

It manages to create the original users, but I get lots of these errors,
and then it crashes with: Couldn’t create ticket HASH(0x9455234).

.[Wed Sep 29 07:14:44 2004] [error]: Could not create a new user -
(/opt/rt3/lib/RT/User_Overlay.pm:260)
Failed to create user for$VAR1 = {
‘CryptedPassword’ => undef,
‘Name’ => 'Unnamed user 1328

Couldn’t create custom field Importing tickets…t-1151
Couldn’t create ticket HASH(0x9455234) $VAR1 = {
‘Requestor’ => [
‘amanda@ns2.fibercloud.com’
],
‘Queue’ => ‘amanda’,
‘Creator’ => ‘’,
‘Owner’ => ‘’,
‘LastUpdatedBy’ => ‘’,
’_RecordTransaction’ => ‘0’,
‘id’ => 1151
};

I have the
/opt/rc2/lib
/opt/rc2/ect
for rt-2.0-to-dumpfile

and /opt/rc3/lib
for dumpfile-to-rt-3.0

Thanks for your time,

Seamus

2

seamus cranley wrote:

I have searched all the threads, and haven�t found a solution.

Does RT3 run fine? Can you login in it via web?

Enable debug log level in RT3.
http://wiki.bestpractical.com/index.cgi?Debug

Then try again and send us info from rt3.log.

I get these errors every time, even if I create three test tickets in
rt-2-0-15 and try to export/import them.

Been trying to fix this for 3 days, help please.

It manages to create the original users, but I get lots of these errors,
and then it crashes with: Couldn’t create ticket HASH(0x9455234).

.[Wed Sep 29 07:14:44 2004] [error]: Could not create a new user -
(/opt/rt3/lib/RT/User_Overlay.pm:260)

Failed to create user for$VAR1 = {

      'CryptedPassword' => undef,

      'Name' => 'Unnamed user 1328

Couldn’t create custom field Importing tickets…t-1151

Couldn’t create ticket HASH(0x9455234) $VAR1 = {

[snip]

3

Hello,

Yes, RT3 runs fine, I can login and create users and queues, etc.

When I trt to run dumpfile-to-rt-3.0, I get the following it rt3.log

after I setup Debug as requested.

[Wed Sep 29 18:12:21 2004] [warning]: DBD::mysql::st execute failed:
Unknown column ‘CryptedPassword’ in ‘field list’ at
/usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle.pm line 478.
(/opt/rt3/lib/RT.pm:250)
[Wed Sep 29 18:12:21 2004] [warning]: RT::Handle=HASH(0x9677eb0) couldn’t
execute the query ‘INSERT INTO Users (EmailAddress, Creator, Password,
LastUpdatedBy, CryptedPassword, Created, id, Name, LastUpdated) VALUES (?,
?, ?, ?, ?, ?, ?, ?, ?)’ at
/usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle.pm line 492.
(/opt/rt3/lib/RT.pm:250)
[Wed Sep 29 18:12:21 2004] [error]: Could not create a new user -
(/opt/rt3/lib/RT/User_Overlay.pm:238)
[Wed Sep 29 18:12:21 2004] [warning]: DBD::mysql::st execute failed:
Unknown column ‘CryptedPassword’ in ‘field list’ at
/usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle.pm line 478.
(/opt/rt3/lib/RT.pm:250)
[Wed Sep 29 18:12:21 2004] [warning]: RT::Handle=HASH(0x9677eb0) couldn’t
execute the query ‘INSERT INTO Users (EmailAddress, Creator, Password,
LastUpdatedBy, CryptedPassword, Created, id, Name, LastUpdated) VALUES (?,
?, ?, ?, ?, ?, ?, ?, ?)’ at
/usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle.pm line 492.
(/opt/rt3/lib/RT.pm:250)
[Wed Sep 29 18:12:21 2004] [error]: Could not create a new user -
(/opt/rt3/lib/RT/User_Overlay.pm:238)
[Wed Sep 29 18:12:21 2004] [warning]: DBD::mysql::st execute failed:
Unknown column ‘CryptedPassword’ in ‘field list’ at
/usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle.pm line 478.
(/opt/rt3/lib/RT.pm:250)
[Wed Sep 29 18:12:21 2004] [warning]: RT::Handle=HASH(0x9677eb0) couldn’t
execute the query ‘INSERT INTO Users (EmailAddress, Creator, Password,
LastUpdatedBy, CryptedPassword, Created, id, Name, LastUpdated) VALUES (?,
?, ?, ?, ?, ?, ?, ?, ?)’ at
/usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle.pm line 492.
(/opt/rt3/lib/RT.pm:250)
[Wed Sep 29 18:12:21 2004] [error]: Could not create a new user -
(/opt/rt3/lib/RT/User_Overlay.pm:238)
[Wed Sep 29 18:12:21 2004] [warning]: DBD::mysql::st execute failed:
Unknown column ‘CryptedPassword’ in ‘field list’ at
/usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle.pm line 478.
(/opt/rt3/lib/RT.pm:250)
[Wed Sep 29 18:12:21 2004] [warning]: RT::Handle=HASH(0x9677eb0) couldn’t
execute the query ‘INSERT INTO Users (EmailAddress, Creator, Password,
LastUpdatedBy, CryptedPassword, Created, id, Name, LastUpdated) VALUES (?,
?, ?, ?, ?, ?, ?, ?, ?)’ at
/usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle.pm line 492.
(/opt/rt3/lib/RT.pm:250)
[Wed Sep 29 18:12:21 2004] [error]: Could not create a new user -
(/opt/rt3/lib/RT/User_Overlay.pm:238)
[Wed Sep 29 18:12:21 2004] [warning]: DBD::mysql::st execute failed:
Unknown column ‘CryptedPassword’ in ‘field list’ at
/usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle.pm line 478.
(/opt/rt3/lib/RT.pm:250)
[Wed Sep 29 18:12:21 2004] [warning]: RT::Handle=HASH(0x9677eb0) couldn’t
execute the query ‘INSERT INTO Users (EmailAddress, Creator, Password,
LastUpdatedBy, CryptedPassword, Created, id, Name, LastUpdated) VALUES (?,
?, ?, ?, ?, ?, ?, ?, ?)’ at
/usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle.pm line 492.
(/opt/rt3/lib/RT.pm:250)
[Wed Sep 29 18:12:21 2004] [error]: Could not create a new user -
(/opt/rt3/lib/RT/User_Overlay.pm:238)
[Wed Sep 29 18:12:21 2004] [warning]: at /opt/rt3/lib/RT/ACE_Overlay.pm
line 884
RT::ACE::_CanonicalizePrincipal(‘RT::ACE=HASH(0x91aa724)’,‘undef’,’’)
called at /opt/rt3/lib/RT/ACE_Overlay.pm line 201
RT::ACE::Create(‘RT::ACE=HASH(0x91aa724)’,‘RightName’,‘SuperUser’,‘Object’,‘RT::System=HASH(0x967b6f4)’,‘PrincipalType’,’’,‘PrincipalId’,‘undef’,…)
called at /opt/rt3/lib/RT/Principal_Overlay.pm line 139
RT::Principal::GrantRight(‘RT::Principal=HASH(0x9e11e70)’,‘Object’,‘RT::System=HASH(0x967b6f4)’,‘Right’,‘SuperUser’)
called at ./dumpfile-to-rt-3.0 line 192
(/opt/rt3/lib/RT.pm:250)
[Wed Sep 29 18:12:21 2004] [crit]: 1 (/opt/rt3/lib/RT/ACE_Overlay.pm:884)
[Wed Sep 29 18:12:21 2004] [crit]: Can’t load a principal for id
(/opt/rt3/lib/RT/ACE_Overlay.pm:885)
[Wed Sep 29 18:12:21 2004] [warning]: Use of uninitialized value in join
or string at (eval 206) line 2.
(/opt/rt3/lib/RT.pm:250)
[Wed Sep 29 18:12:21 2004] [warning]: at /opt/rt3/lib/RT/ACE_Overlay.pm
line 884
RT::ACE::_CanonicalizePrincipal(‘RT::ACE=HASH(0x9e1047c)’,‘undef’,’’)
called at /opt/rt3/lib/RT/ACE_Overlay.pm line 201
RT::ACE::Create(‘RT::ACE=HASH(0x9e1047c)’,‘RightName’,‘SuperUser’,‘Object’,‘RT::System=HASH(0x967b6f4)’,‘PrincipalType’,’’,‘PrincipalId’,‘undef’,…)
called at /opt/rt3/lib/RT/Principal_Overlay.pm line 139
RT::Principal::GrantRight(‘RT::Principal=HASH(0x9e11e70)’,‘Object’,‘RT::System=HASH(0x967b6f4)’,‘Right’,‘SuperUser’)
called at ./dumpfile-to-rt-3.0 line 192
(/opt/rt3/lib/RT.pm:250)
[Wed Sep 29 18:12:21 2004] [crit]: 1 (/opt/rt3/lib/RT/ACE_Overlay.pm:884)
[Wed Sep 29 18:12:21 2004] [crit]: Can’t load a principal for id
(/opt/rt3/lib/RT/ACE_Overlay.pm:885)
[Wed Sep 29 18:12:21 2004] [warning]: Use of uninitialized value in join
or string at (eval 206) line 2.
(/opt/rt3/lib/RT.pm:250)
[Wed Sep 29 18:12:21 2004] [warning]: at /opt/rt3/lib/RT/ACE_Overlay.pm
line 884
RT::ACE::_CanonicalizePrincipal(‘RT::ACE=HASH(0x9e20c90)’,‘undef’,’’)
called at /opt/rt3/lib/RT/ACE_Overlay.pm line 201
RT::ACE::Create(‘RT::ACE=HASH(0x9e20c90)’,‘RightName’,‘SuperUser’,‘Object’,‘RT::System=HASH(0x967b6f4)’,‘PrincipalType’,’’,‘PrincipalId’,‘undef’,…)
called at /opt/rt3/lib/RT/Principal_Overlay.pm line 139
RT::Principal::GrantRight(‘RT::Principal=HASH(0x9e11e70)’,‘Object’,‘RT::System=HASH(0x967b6f4)’,‘Right’,‘SuperUser’)
called at ./dumpfile-to-rt-3.0 line 192
(/opt/rt3/lib/RT.pm:250)
[Wed Sep 29 18:12:21 2004] [crit]: 1 (/opt/rt3/lib/RT/ACE_Overlay.pm:884)
[Wed Sep 29 18:12:22 2004] [crit]: Can’t load a principal for id
(/opt/rt3/lib/RT/ACE_Overlay.pm:885)
[Wed Sep 29 18:12:22 2004] [warning]: Use of uninitialized value in join
or string at (eval 206) line 2.
(/opt/rt3/lib/RT.pm:250)
[Wed Sep 29 18:12:22 2004] [warning]: at /opt/rt3/lib/RT/ACE_Overlay.pm
line 884
RT::ACE::_CanonicalizePrincipal(‘RT::ACE=HASH(0x9e21fa4)’,‘undef’,’’)
called at /opt/rt3/lib/RT/ACE_Overlay.pm line 201
RT::ACE::Create(‘RT::ACE=HASH(0x9e21fa4)’,‘RightName’,‘SuperUser’,‘Object’,‘RT::System=HASH(0x967b6f4)’,‘PrincipalType’,’’,‘PrincipalId’,‘undef’,…)
called at /opt/rt3/lib/RT/Principal_Overlay.pm line 139
RT::Principal::GrantRight(‘RT::Principal=HASH(0x9e11e70)’,‘Object’,‘RT::System=HASH(0x967b6f4)’,‘Right’,‘SuperUser’)
called at ./dumpfile-to-rt-3.0 line 192
(/opt/rt3/lib/RT.pm:250)
[Wed Sep 29 18:12:22 2004] [crit]: 1 (/opt/rt3/lib/RT/ACE_Overlay.pm:884)
[Wed Sep 29 18:12:22 2004] [crit]: Can’t load a principal for id
(/opt/rt3/lib/RT/ACE_Overlay.pm:885)
[Wed Sep 29 18:12:22 2004] [warning]: Use of uninitialized value in join
or string at (eval 206) line 2.
(/opt/rt3/lib/RT.pm:250)
[Wed Sep 29 18:12:22 2004] [warning]: at /opt/rt3/lib/RT/ACE_Overlay.pm
line 884
RT::ACE::_CanonicalizePrincipal(‘RT::ACE=HASH(0x9e20c48)’,‘undef’,’’)
called at /opt/rt3/lib/RT/ACE_Overlay.pm line 201
RT::ACE::Create(‘RT::ACE=HASH(0x9e20c48)’,‘RightName’,‘SuperUser’,‘Object’,‘RT::System=HASH(0x967b6f4)’,‘PrincipalType’,’’,‘PrincipalId’,‘undef’,…)
called at /opt/rt3/lib/RT/Principal_Overlay.pm line 139
RT::Principal::GrantRight(‘RT::Principal=HASH(0x9e11e70)’,‘Object’,‘RT::System=HASH(0x967b6f4)’,‘Right’,‘SuperUser’)
called at ./dumpfile-to-rt-3.0 line 192
(/opt/rt3/lib/RT.pm:250)
[Wed Sep 29 18:12:22 2004] [crit]: 1 (/opt/rt3/lib/RT/ACE_Overlay.pm:884)
[Wed Sep 29 18:12:22 2004] [crit]: Can’t load a principal for id
(/opt/rt3/lib/RT/ACE_Overlay.pm:885)
[Wed Sep 29 18:12:22 2004] [warning]: Use of uninitialized value in join
or string at (eval 206) line 2.
(/opt/rt3/lib/RT.pm:250)
[Wed Sep 29 18:12:22 2004] [warning]: DBD::mysql::st execute failed:
Column ‘Name’ cannot be null at
/usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle.pm line 478.
(/opt/rt3/lib/RT.pm:250)
[Wed Sep 29 18:12:22 2004] [warning]: RT::Handle=HASH(0x9677eb0) couldn’t
execute the query ‘INSERT INTO Queues (CorrespondAddress, FinalPriority,
Creator, DefaultDueIn, CommentAddress, InitialPriority, LastUpdatedBy,
Created, Name, Description, LastUpdated) VALUES (?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?)’ at /usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle.pm
line 492.
(/opt/rt3/lib/RT.pm:250)
[Wed Sep 29 18:12:22 2004] [warning]: DBD::mysql::st execute failed:
Column ‘Name’ cannot be null at
/usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle.pm line 478.
(/opt/rt3/lib/RT.pm:250)
[Wed Sep 29 18:12:22 2004] [warning]: RT::Handle=HASH(0x9677eb0) couldn’t
execute the query ‘INSERT INTO Queues (CorrespondAddress, FinalPriority,
Creator, DefaultDueIn, LastUpdatedBy, InitialPriority, CommentAddress,
Created, Description, Name, LastUpdated) VALUES (?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?)’ at /usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle.pm
line 492.
(/opt/rt3/lib/RT.pm:250)
[Wed Sep 29 18:12:22 2004] [warning]: DBD::mysql::st execute failed:
Column ‘Name’ cannot be null at
/usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle.pm line 478.
(/opt/rt3/lib/RT.pm:250)
[Wed Sep 29 18:12:22 2004] [warning]: RT::Handle=HASH(0x9677eb0) couldn’t
execute the query ‘INSERT INTO Queues (CorrespondAddress, FinalPriority,
Creator, DefaultDueIn, LastUpdatedBy, InitialPriority, CommentAddress,
Created, Description, Name, LastUpdated) VALUES (?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?)’ at /usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle.pm
line 492.
(/opt/rt3/lib/RT.pm:250)
[Wed Sep 29 18:12:22 2004] [warning]: DBD::mysql::st execute failed:
Duplicate entry ‘1’ for key 1 at
/usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle.pm line 478.
(/opt/rt3/lib/RT.pm:250)
[Wed Sep 29 18:12:22 2004] [warning]: RT::Handle=HASH(0x9677eb0) couldn’t
execute the query ‘INSERT INTO Tickets (Status, Queue, Started, Type,
InitialPriority, Starts, id, LastUpdated, Subject, FinalPriority, Creator,
Owner, LastUpdatedBy, Resolved, Created, Priority, Due) VALUES (?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)’ at
/usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle.pm line 492.
(/opt/rt3/lib/RT.pm:250)
[Wed Sep 29 18:12:22 2004] [crit]: Couldn’t create a ticket: Internal
Error: Couldn’t execute the query 'INSERT INTO Tickets (Status, Queue,
Started, Type, InitialPriority, Starts, id, LastUpdated, Subject,
FinalPriority, Creator, Owner, LastUpdatedBy, Resolved, Created, Priority,
Due) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)'Duplicate
entry ‘1’ for key 1 (/opt/rt3/lib/RT/Ticket_Overlay.pm:562)