Hi I was wondering if anyone could help me on this one.
We have upgraded our RT to a new database, and wanting to carry on the numbering from where we left off, created a load of blank tickets to fill the table row IDs. Now when we are trying to change the owner (currently Nobody) on any of the old tickets, we are getting the error listed below (regardless of whether it is using "Take", "Steal" or Assignment via "Jumbo" update). Is there anything obvious within this dump that would suggest any database columns that aren't populated and should be (or that are and shouldn't). New tickets created normally are OK. Regards Neil Turner ------------------------------------- System error error: Can't call method "Delete" on an undefined value at /usr/local/rt3/lib/RT/Ticket_Overlay.pm line 3045. context: ... 3041: 3042: # Delete the owner in the owner group, then add a new one 3043: # TODO: is this safe? it's not how we really want the API to work 3044: # for most things, but it's fast. 3045: my ( $del_id, $del_msg ) = $self->OwnerGroup->MembersObj->First->Delete(); 3046: unless ($del_id) { 3047: $RT::Handle->Rollback(); 3048: return ( 0, $self->loc("Could not change owner. ") . $del_msg ); 3049: } ... code stack: /usr/local/rt3/lib/RT/Ticket_Overlay.pm:3045 /usr/local/rt3/lib/RT/Ticket_Overlay.pm:3107 /usr/local/rt3/share/html/Ticket/Display.html:129 /usr/local/rt3/share/html/autohandler:292 [raw error] Can't call method "Delete" on an undefined value at /usr/local/rt3/lib/RT/Ticket_Overlay.pm line 3045. Trace begun at /usr/local/share/perl/5.8.7/HTML/Mason/Exceptions.pm line 129 HTML::Mason::Exceptions::rethrow_exception('Can\'t call method "Delete" on an undefined value at /usr/local/rt3/lib/RT/Ticket_Overlay.pm line 3045.^J') called at /usr/local/rt3/lib/RT/Ticket_Overlay.pm line 3045 RT::Ticket::SetOwner('RT::Ticket=HASH(0xa7da29c)', 154, 'Take') called at /usr/local/rt3/lib/RT/Ticket_Overlay.pm line 3107 RT::Ticket::Take('RT::Ticket=HASH(0xa7da29c)') called at /usr/local/rt3/share/html/Ticket/Display.html line 129 HTML::Mason::Commands::__ANON__('Action', 'Take', 'id', 22828) called at /usr/local/share/perl/5.8.7/HTML/Mason/Component.pm line 135 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0xa10f50 0)', 'Action', 'Take', 'id', 22828) called at /usr/local/share/perl/5.8.7/HTML/Mason/Request.pm line 1256 eval {...} at /usr/local/share/perl/5.8.7/HTML/Mason/Request.pm line 1246 HTML::Mason::Request::comp(undef, undef, undef, 'Action', 'Take', 'id', 22828) called at /usr/local/rt3/share/html/autohandler line 292 HTML::Mason::Commands::__ANON__('Action', 'Take', 'id', 22828) called at /usr/local/share/perl/5.8.7/HTML/Mason/Component.pm line 135 HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x9e3743 c)', 'Action', 'Take', 'id', 22828) called at /usr/local/share/perl/5.8.7/HTML/Mason/Request.pm line 1251 eval {...} at /usr/local/share/perl/5.8.7/HTML/Mason/Request.pm line 1246 HTML::Mason::Request::comp(undef, undef, undef, 'Action', 'Take', 'id', 22828) called at /usr/local/share/perl/5.8.7/HTML/Mason/Request.pm line 460 eval {...} at /usr/local/share/perl/5.8.7/HTML/Mason/Request.pm line 460 eval {...} at /usr/local/share/perl/5.8.7/HTML/Mason/Request.pm line 412 HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0xa7ec3 78)') called at /usr/local/share/perl/5.8.7/HTML/Mason/ApacheHandler.pm line 168 HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandl er=HASH(0xa7ec378)') called at /usr/local/share/perl/5.8.7/HTML/Mason/ApacheHandler.pm line 826 HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH( 0x9415fe4)', 'Apache2::RequestRec=SCALAR(0xa7b8fb8)') called at /usr/local/rt3/bin/webmux.pl line 123 eval {...} at /usr/local/rt3/bin/webmux.pl line 123 RT::Mason::handler('Apache2::RequestRec=SCALAR(0xa7b8fb8)') called at -e line 0 eval {...} at -e line 0 _______________________________________________ http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users Community help: http://wiki.bestpractical.com Commercial support: [EMAIL PROTECTED] Discover RT's hidden secrets with RT Essentials from O'Reilly Media. Buy a copy at http://rtbook.bestpractical.com