[Rt-devel] Problem with "Steal" ticket in RT 3.4.0

mike at nepotia.org mike at nepotia.org
Wed Feb 9 21:26:52 EST 2005

I posted this to rt-users last night. Any thoughs? TIA...

I've taken a base 3.4.0 install, configured my Groups, Qs, users etc. All
views and creation privs are configured and appear to work well.

I then (*not using the RT API), ripped a bunch of existing "Project like"
data into RT. Everything so far has worked like a charm. The old projects
became tickets, and line items became transactions/attachments -- custom
fields populated, all appears well. Tickets maintained their associateion
with users from the old database to RT, and got mapped into appropriate

Now, when I try to "steal" a ticket - from anyone - as anyone, I get a
system error  (See Bellow). If I create a NEW ticket though, steal works.

It should be noted, that I have successfully performed similar "imports"
into past versions of RT (3.0, 3.2). I thought I had a clean sweep, and
again, everything except for the steal feature works as expected.

Here's the URI:

Here's the Request output:

System error

error:  Can't call method "Delete" on an undefined value at
/opt/rt3/lib/RT/Ticket_Overlay.pm line 2964.

context:  ...
2961:  # Delete the owner in the owner group, then add a new one
2962:  # TODO: is this safe? it's not how we really want the API to work
2963:  # for most things, but it's fast.
2964:  my ( $del_id, $del_msg ) =
2965:  unless ($del_id) {
2966:  $RT::Handle->Rollback();
2967:  return ( 0, $self->loc("Could not change owner. ") . $del_msg );
2968:  }

code stack:  /opt/rt3/lib/RT/Ticket_Overlay.pm:2964

Here's the Raw Error:

Can't call method "Delete" on an undefined value at
/opt/rt3/lib/RT/Ticket_Overlay.pm line 2964.

Trace begun at /usr/lib/perl5/site_perl/5.8.3/HTML/Mason/Exceptions.pm
line 131
HTML::Mason::Exceptions::rethrow_exception('Can\'t call method "Delete" on
an undefined value at /opt/rt3/lib/RT/Ticket_Overlay.pm line 2964.^J')
called at /opt/rt3/lib/RT/Ticket_Overlay.pm line 2964
RT::Ticket::SetOwner('RT::Ticket=HASH(0xb2dbaa8)', 22, 'Steal') called at
/opt/rt3/lib/RT/Ticket_Overlay.pm line 3062
RT::Ticket::Steal('RT::Ticket=HASH(0xb2dbaa8)') called at
/opt/rt3/local/html/Ticket/Display.html line 122
HTML::Mason::Commands::__ANON__('Action', 'Steal', 'id', 811, 'Action',
'Steal', 'id', 811) called at
/usr/lib/perl5/site_perl/5.8.3/HTML/Mason/Component.pm line 136
'Action', 'Steal', 'id', 811, 'Action', 'Steal', 'id', 811) called at
/usr/lib/perl5/site_perl/5.8.3/HTML/Mason/Request.pm line 1074
eval {...} at /usr/lib/perl5/site_perl/5.8.3/HTML/Mason/Request.pm line
1068 HTML::Mason::Request::comp(undef, undef, 'Action', 'Steal', 'id',
811, 'Action', 'Steal', 'id', 811) called at
/usr/lib/perl5/site_perl/5.8.3/HTML/Mason/Request.pm line 760
'Action', 'Steal', 'id', 811) called at /opt/rt3/share/html/autohandler
line 215
HTML::Mason::Commands::__ANON__('Action', 'Steal', 'id', 811) called at
/usr/lib/perl5/site_perl/5.8.3/HTML/Mason/Component.pm line 136
'Action', 'Steal', 'id', 811) called at
/usr/lib/perl5/site_perl/5.8.3/HTML/Mason/Request.pm line 1069
eval {...} at /usr/lib/perl5/site_perl/5.8.3/HTML/Mason/Request.pm line
1068 HTML::Mason::Request::comp(undef, undef, undef, 'Action', 'Steal',
'id', 811) called at /usr/lib/perl5/site_perl/5.8.3/HTML/Mason/Request.pm
line 338
eval {...} at /usr/lib/perl5/site_perl/5.8.3/HTML/Mason/Request.pm line
338 eval {...} at /usr/lib/perl5/site_perl/5.8.3/HTML/Mason/Request.pm
line 297
called at /usr/lib/perl5/site_perl/5.8.3/HTML/Mason/ApacheHandler.pm line
eval {...} at /usr/lib/perl5/site_perl/5.8.3/HTML/Mason/ApacheHandler.pm
line 134
called at /usr/lib/perl5/site_perl/5.8.3/HTML/Mason/ApacheHandler.pm line
'Apache::RequestRec=SCALAR(0xa8ddf68)') called at /opt/rt3/bin/webmux.pl
line 132
eval {...} at /opt/rt3/bin/webmux.pl line 132
RT::Mason::handler('Apache::RequestRec=SCALAR(0xa8ddf68)') called at -e
line 0
eval {...} at -e line 0

And, finally output from my rt.log:

[Wed Feb  9 04:57:38 2005] [warning]: DBD::mysql::st execute failed: You
have an error in your SQL syntax; check the manual that corresponds to
your MySQL server version for the right syntax to use near '))' at line 1
at /usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle.pm line 480.
[Wed Feb  9 04:57:38 2005] [warning]: RT::Handle=HASH(0xacb5c8c) couldn't
execute the query 'SELECT main.* FROM GroupMembers main   WHERE
((main.GroupId = )) ' at
/usr/lib/perl5/site_perl/5.8.3/DBIx/SearchBuilder/Handle.pm line 494.
[Wed Feb  9 04:57:38 2005] [crit]: Transaction not committed. Usually
indicates a software fault.Data loss may have occurred

I must have missed something important during the import. Any insight? My
import code is fairly clean - should be easy to read, and I'de be happy to
share if that would help.



More information about the Rt-devel mailing list