[rt-users] Problems with migration from old ticket system.

[Jonas Lindvall (AllTele)]

Since we wanted the same Ticket ID numbers for our old tickets.

I manually added a new record into the database. Tracked down to what
commands that were written into the mysql database by request tracker.
And inserted all the tickets from out old system.

Thou this came along with some problems. 
#1; I cant "Take" any of those imported cases. It says:
System error

      error:  Can't call method "Delete" on an undefined value at /usr/local/rt3/lib/RT/Ticket_Overlay.pm line 3112.
     
      context:  ...   
            3108:   
            3109:  # Delete the owner in the owner group, then add a new one 
            3110:  # TODO: is this safe? it's not how we really want the API to work 
            3111:  # for most things, but it's fast. 
            3112:  my ( $del_id, $del_msg ) = $self->OwnerGroup->MembersObj->First->Delete(); 
            3113:  unless ($del_id) { 
            3114:  $RT::Handle->Rollback(); 
            3115:  return ( 0, $self->loc("Could not change owner. ") . $del_msg ); 
            3116:  } 
            ...   
     
      code stack:  /usr/local/rt3/lib/RT/Ticket_Overlay.pm:3112
      /usr/local/rt3/lib/RT/Ticket_Overlay.pm:3174
      /usr/local/rt3/share/html/Ticket/Display.html:93
      /usr/local/rt3/share/html/autohandler:196
     

raw error

Can't call method "Delete" on an undefined value at /usr/local/rt3/lib/RT/Ticket_Overlay.pm line 3112.
Trace begun at /usr/local/lib/perl5/site_perl/5.8.4/HTML/Mason/Exceptions.pm line 131
HTML::Mason::Exceptions::rethrow_exception('Can\'t call method "Delete" on an undefined value at /usr/local/rt3/lib/RT/Ticket_Overlay.pm line 3112.^J') called at /usr/local/rt3/lib/RT/Ticket_Overlay.pm line 3112
RT::Ticket::SetOwner('RT::Ticket=HASH(0xa669df0)', 34, 'Take') called at /usr/local/rt3/lib/RT/Ticket_Overlay.pm line 3174
RT::Ticket::Take('RT::Ticket=HASH(0xa669df0)') called at /usr/local/rt3/share/html/Ticket/Display.html line 93
HTML::Mason::Commands::__ANON__('Action', 'Take', 'id', 4385, 'Action', 'Take', 'id', 4385) called at /usr/local/lib/perl5/site_perl/5.8.4/HTML/Mason/Component.pm line 134
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xa156d18)', 'Action', 'Take', 'id', 4385, 'Action', 'Take', 'id', 4385) called at /usr/local/lib/perl5/site_perl/5.8.4/HTML/Mason/Request.pm line 1074
eval {...} at /usr/local/lib/perl5/site_perl/5.8.4/HTML/Mason/Request.pm line 1068
HTML::Mason::Request::comp(undef, undef, 'Action', 'Take', 'id', 4385, 'Action', 'Take', 'id', 4385) called at /usr/local/lib/perl5/site_perl/5.8.4/HTML/Mason/Request.pm line 760
HTML::Mason::Request::call_next('HTML::Mason::Request::ApacheHandler=HASH(0xa626d6c)', 'Action', 'Take', 'id', 4385) called at /usr/local/rt3/share/html/autohandler line 196
HTML::Mason::Commands::__ANON__('Action', 'Take', 'id', 4385) called at /usr/local/lib/perl5/site_perl/5.8.4/HTML/Mason/Component.pm line 134
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xa173b68)', 'Action', 'Take', 'id', 4385) called at /usr/local/lib/perl5/site_perl/5.8.4/HTML/Mason/Request.pm line 1069
eval {...} at /usr/local/lib/perl5/site_perl/5.8.4/HTML/Mason/Request.pm line 1068
HTML::Mason::Request::comp(undef, undef, undef, 'Action', 'Take', 'id', 4385) called at /usr/local/lib/perl5/site_perl/5.8.4/HTML/Mason/Request.pm line 338
eval {...} at /usr/local/lib/perl5/site_perl/5.8.4/HTML/Mason/Request.pm line 338
eval {...} at /usr/local/lib/perl5/site_perl/5.8.4/HTML/Mason/Request.pm line 297
HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0xa626d6c)') called at /usr/local/lib/perl5/site_perl/5.8.4/HTML/Mason/ApacheHandler.pm line 134
eval {...} at /usr/local/lib/perl5/site_perl/5.8.4/HTML/Mason/ApacheHandler.pm line 134
HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandler=HASH(0xa626d6c)') called at /usr/local/lib/perl5/site_perl/5.8.4/HTML/Mason/ApacheHandler.pm line 792
HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0xa15926c)', 'Apache::RequestRec=SCALAR(0xa05b704)') called at /usr/local/rt3/bin/webmux.pl line 138
eval {...} at /usr/local/rt3/bin/webmux.pl line 138
RT::Mason::handler('Apache::RequestRec=SCALAR(0xa05b704)') called at -e line 0
eval {...} at -e line 0
#2 is that we have some with swedish characters, åäö. those does not show up as äöå in RT thou they are as åäö in my database...... How to solve this??

Thanks for any help.

./Jonas Lindvall
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20040719/e5ac75b6/attachment.htm>