[rt-users] rt-2-0-15 to rt-3.2.2 using rt2-to-rt3-1.23 fails
seamus at pur.nu
seamus at pur.nu
Wed Sep 29 14:26:55 EDT 2004
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)
> 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]
>>
>> Seamus
>
More information about the rt-users
mailing list