[rt-users] import 1.0 to 2.0

[Tasos Chronis]

Hi again

I cant find a solution. Right now I am struggling with rt-2.0.0.
What I've tried :
On a Solaris8 box with perl 5.6.1 and the latest modules trying to import
real data.
On a linux box with the data from the Sun box and a test data with on 
ticket.
I tried as root and as a user.
I tried with the two DBD::mysql one from DBD-mysql and other Mysql-Msql.
If you have a clue or an idea where the problem might be I can

Here is the output together with some extra warnings I put in the code:



Importing tickets...

1.
  RT:1

statel
id =>1
Queue =>statel
Status =>open
Requestor =>root@
Owner =>4
Subject =>test
Priority =>1
FinalPriority =>1
InitialPriority =>1
Due =>2001-07-04 21:00:00
Told =>1970-01-01 00:00:00
Created =>2001-06-28 10:07:25
Updated =>2001-06-28 10:07:25
ExtendedPrincipals::IsCc::IsOwner::IsRequestor::Right:CreateTicket:IsAdminCc::Scope:Queue:AppliesTo:2
Now Trying SELECT COUNT(ACL.id) FROM ACL, Groups WHERE  (((RightScope = 
'Queue') AND (RightAppliesTo = 2))) AND ((RightName = 'CreateTicket')) 
AND (((Groups.Name = 'Everyone') AND
                                        (PrincipalType = 'Group') AND
                                        (Groups.Id = PrincipalId)))
ExtendedPrincipals::IsCc::IsOwner::IsRequestor::Right:OwnTicket:IsAdminCc::Scope:Queue:AppliesTo:2
Now Trying SELECT COUNT(ACL.id) FROM ACL, Groups WHERE  (((RightScope = 
'Queue') AND (RightAppliesTo = 2))) AND ((RightName = 'OwnTicket')) AND 
(((Groups.Name = 'Everyone') AND
                                        (PrincipalType = 'Group') AND
                                        (Groups.Id = PrincipalId)))
No ACL matched MetaGroups query: SELECT COUNT(ACL.id) FROM ACL, Groups 
WHERE  (((RightScope = 'Queue') AND (RightAppliesTo = 2))) AND 
((RightName = 'OwnTicket')) AND (((Groups.Name = 'Everyone') AND
                                        (PrincipalType = 'Group') AND
                                        (Groups.Id = PrincipalId)))
Now Trying SELECT COUNT(ACL.id) FROM ACL, GroupMembers, Groups WHERE 
((((((RightScope = 'Queue') AND (RightAppliesTo = 2))) AND ((RightName = 
'OwnTicket'))) OR ((RightName = 'SuperUser') AND (RightScope = 'System') 
AND (RightAppliesTo = 0)))  AND (((ACL.PrincipalType = 'Group') AND 
(ACL.PrincipalId = Groups.Id) AND (GroupMembers.GroupId = Groups.Id) 
AND (GroupMembers.UserId = 4))))
No ACL matched SELECT COUNT(ACL.id) FROM ACL, GroupMembers, Groups WHERE 
  ((((((RightScope = 'Queue') AND (RightAppliesTo = 2))) AND ((RightName 
= 'OwnTicket'))) OR ((RightName = 'SuperUser') AND (RightScope = 
'System') AND (RightAppliesTo = 0)))  AND (((ACL.PrincipalType = 
'Group') AND (ACL.PrincipalId = Groups.Id) AND (GroupMembers.GroupId = 
Groups.Id)  AND (GroupMembers.UserId = 4))))
RT::User=HASH(0x88472e4)->HasQueueRight Couldn't find a queue id at 
/opt/rt2/lib//RT/User.pm line 609
         RT::User::HasQueueRight('RT::User=HASH(0x88472e4)', 
'TicketObj', 'RT::Ticket=HASH(0x88a89e4)', 'Right', 'ShowTicket') called 
at /opt/rt2/lib//RT/Ticket.pm line 2803
         RT::Ticket::HasRight('RT::Ticket=HASH(0x88a89e4)', 'Principal', 
'RT::User=HASH(0x88472e4)', 'Right', 'ShowTicket') called at 
/opt/rt2/lib//RT/Ticket.pm line 2774
         RT::Ticket::CurrentUserHasRight('RT::Ticket=HASH(0x88a89e4)', 
'ShowTicket') called at /opt/rt2/lib//RT/Ticket.pm line 2724
         RT::Ticket::_Value('RT::Ticket=HASH(0x88a89e4)', 'EffectiveId') 
called at /usr/lib/perl5/site_perl/5.6.0/DBIx/SearchBuilder/Record.pm 
line 406
         DBIx::SearchBuilder::Record::AUTOLOAD(undef, undef, 
'RT::Ticket=HASH(0x88a89e4)') called at /opt/rt2/lib//RT/Ticket.pm line 91
         RT::Ticket::Load('RT::Ticket=HASH(0x88a89e4)', 6) called at 
/opt/rt2/lib//RT/Record.pm line 96
         RT::Record::Create('id', 1, 'EffectiveId', 1, 'Queue', 2, 
'Owner', 4, ...) called at /opt/rt2/lib//RT/Ticket.pm line 449
         RT::Ticket::Import('RT::Ticket=HASH(0x88a89e4)', 'id', 1, 
'Queue', 'statel', 'Status', 'open', 'Requestor', ...) called at 
import-1.0-to-2.0 line 444
         main::MigrateTickets() called at import-1.0-to-2.0 line 72
1_HasRight called without an AppliesTo object
ExtendedPrincipals::IsCc::IsOwner::IsRequestor::Right:ShowTicket:IsAdminCc::Scope:System:AppliesTo:0
Now Trying SELECT COUNT(ACL.id) FROM ACL, Groups WHERE  ((RightScope = 
'System')) AND ((RightName = 'ShowTicket')) AND (((Groups.Name = 
'Everyone') AND
                                        (PrincipalType = 'Group') AND
                                        (Groups.Id = PrincipalId)))
No ACL matched MetaGroups query: SELECT COUNT(ACL.id) FROM ACL, Groups 
WHERE  ((RightScope = 'System')) AND ((RightName = 'ShowTicket')) AND 
(((Groups.Name
= 'Everyone') AND
                                        (PrincipalType = 'Group') AND
                                        (Groups.Id = PrincipalId)))
Now Trying SELECT COUNT(ACL.id) FROM ACL, GroupMembers, Groups WHERE 
(((((RightScope = 'System')) AND ((RightName = 'ShowTicket'))) OR 
((RightName = 'SuperUser') AND (RightScope = 'System') AND 
(RightAppliesTo = 0)))  AND (((ACL.PrincipalType = 'Group') AND 
(ACL.PrincipalId = Groups.Id) AND (GroupMembers.GroupId = Groups.Id) 
AND (GroupMembers.UserId = 1))))
No ACL matched SELECT COUNT(ACL.id) FROM ACL, GroupMembers, Groups WHERE 
  (((((RightScope = 'System')) AND ((RightName = 'ShowTicket'))) OR 
((RightName = 'SuperUser') AND (RightScope = 'System') AND 
(RightAppliesTo = 0)))  AND (((ACL.PrincipalType = 'Group') AND 
(ACL.PrincipalId = Groups.Id) AND (GroupMembers.GroupId = Groups.Id) 
AND (GroupMembers.UserId = 1))))
Trying to load an email address: root at localhost
Use of uninitialized value in concatenation (.) at import-1.0-to-2.0 
line 459.
id:
Use of uninitialized value in concatenation (.) at import-1.0-to-2.0 
line 460.
msg:
Use of uninitialized value in concatenation (.) at import-1.0-to-2.0 
line 461.

         main::MigrateTickets() called at import-1.0-to-2.0 line 72
Jesse wrote:

> Ok. we've upgraded you to the problem lots of other folks are having ;)
> 
>