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:
:SetOwner(‘RT::Ticket=HASH(0xa7da29c)’, 154, ‘Take’) called at
/usr/local/rt3/lib/RT/Ticket_Overlay.pm line 3107
RT::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