[rt-users] Can't create ticket from web interface! ("Can't bind a reference")

Robin Lee Powell rlpowell at digitalkingdom.org
Wed Mar 5 14:22:55 EST 2003


Attempting to create a ticket from the web interface on my setup creates
an error:

error:
Can't bind a reference (Class::ReturnValue=HASH(0x8f2d378)) at
/usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 376.

Note from the attached error log that the ID of the generated ticket
appears to be 0, and this is never tested for.  Why the ID is bad, I
have no idea.

Note that rt-mailgate works fine.

Here are some manual Data::Dumper() results from Ticket.pm just before
line 342:

print MYTMP Dumper( $QueueObj->Id );
print MYTMP Dumper( $Owner->Id );
print MYTMP Dumper( $args{'Subject'} );
print MYTMP Dumper( $args{'InitialPriority'} );
print MYTMP Dumper( $args{'FinalPriority'} );
print MYTMP Dumper( $args{'InitialPriority'} );
print MYTMP Dumper( $args{'Status'} );
print MYTMP Dumper( $args{'TimeWorked'} );
print MYTMP Dumper( $args{'TimeLeft'} );
print MYTMP Dumper( $args{'Type'}       );
print MYTMP Dumper( $starts->ISO );
print MYTMP Dumper( $resolved );
print MYTMP Dumper( $due->ISO );

gives

$VAR1 = '2';
$VAR1 = '2';
$VAR1 = 'test';
$VAR1 = '0';
$VAR1 = '0';
$VAR1 = '0';
$VAR1 = 'new';
$VAR1 = '';
$VAR1 = '';
$VAR1 = 'ticket';
$VAR1 = '1970-01-01 00:00:00';
$VAR1 = undef;
$VAR1 = '1970-01-01 00:00:00';

Also, I get the following in syslog when this happens:

Mar  4 08:18:02 digitalkingdom postgres[26048]: [3] ERROR:  pg_atoi:
zero-length string

-Robin


-- 
http://www.digitalkingdom.org/~rlpowell/    ***    I'm a *male* Robin.
.i le pamoi velru'e zo'u crepu le plibu taxfu
.i le remoi velru'e zo'u mo .i le cimoi velru'e zo'u ba'e prali .uisai
http://www.lojban.org/   ***   to sa'a cu'u lei pibyta'u cridrnoma toi
-------------- next part --------------
System error

error: 
Can't bind a reference (Class::ReturnValue=HASH(0x8f2d378)) at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 376.

context: 
... 

277: }
278: 
279: # All errors returned from this routine will be in exception form.
280: local $SIG{'__DIE__'} = sub {
281: rethrow_exception( $_[0] );
282: };
283: 
284: #
285: # $m is a dynamically scoped global containing this
... 


code stack: 
/usr/share/perl5/HTML/Mason/Request.pm:281
/usr/share/perl5/DBIx/SearchBuilder/Handle.pm:376
/usr/share/perl5/DBIx/SearchBuilder/Handle.pm:319
/usr/share/perl5/DBIx/SearchBuilder/Record.pm:666
/usr/share/request-tracker/lib/RT/Ticket.pm:342
/usr/share/request-tracker/WebRT/html/Ticket/Display.html:87
/usr/share/request-tracker/WebRT/html/autohandler:58

raw error

Can't bind a reference (Class::ReturnValue=HASH(0x8f2d378)) at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 376.


Trace begun at /usr/share/perl5/HTML/Mason/Exceptions.pm line 123
HTML::Mason::Exceptions::rethrow_exception('Can\'t bind a reference (Class::ReturnValue=HASH(0x8f2d378)) at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 376.^J') called at /usr/share/perl5/HTML/Mason/Request.pm line 281
HTML::Mason::Request::__ANON__('Can\'t bind a reference (Class::ReturnValue=HASH(0x8f2d378)) at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 376.^J') called at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 376
DBIx::SearchBuilder::Handle::SimpleQuery('RT::Handle=HASH(0x8e45c58)', 'UPDATE Tickets SET EffectiveId=? WHERE id=? ', 0, undef) called at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 319
DBIx::SearchBuilder::Handle::UpdateRecordValue('RT::Handle=HASH(0x8e45c58)', 'Table', 'Tickets', 'IsSQLFunction', undef, 'Column', 'EffectiveId', 'PrimaryKeys', 'HASH(0x8f2ad18)', 'Value', 0) called at /usr/share/perl5/DBIx/SearchBuilder/Record.pm line 666
DBIx::SearchBuilder::Record::__Set('RT::Ticket=HASH(0x8f14090)', 'Field', 'EffectiveId', 'Value', 0) called at /usr/share/request-tracker/lib/RT/Ticket.pm line 342
RT::Ticket::Create('RT::Ticket=HASH(0x8f14090)', 'Requestor', 'ARRAY(0x8efbc44)', 'Cc', 'ARRAY(0x8efbca4)', 'Subject', 'test', 'Status', 'new', 'FinalPriority', 0, 'TimeLeft', '', 'Queue', 'jbovlaste', 'AdminCc', 'ARRAY(0x8efbd04)', 'Owner', '', 'MIMEObj', 'MIME::Entity=HASH(0x838f960)', 'InitialPriority', 0, 'Starts', '1970-01-01 00:00:00', 'TimeWorked', '', 'Due', '1970-01-01 00:00:00') called at /usr/share/request-tracker/WebRT/html/Ticket/Display.html line 87
HTML::Mason::Commands::__ANON__('Status', 'new', 'new-DependsOn', '', 'ValueOfOwner', '', 'Queue', 'jbovlaste', 'AdminCc', '', 'Requestors', 'rlpowell at lojban.org', 'InitialPriority', 0, 'Starts', '', 'Attach', '', 'TimeWorked', '', 'id', 'new', 'Cc', '', 'Subject', 'test', 'new-RefersTo', '', 'FinalPriority', 0, 'RefersTo-new', '', 'TimeLeft', '', 'DependsOn-new', '', 'new-MemberOf', '', 'MemberOf-new', '', 'Content', 'test', 'Due', '') called at /usr/share/perl5/HTML/Mason/Component.pm line 133
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x8f039b0)', 'Status', 'new', 'new-DependsOn', '', 'ValueOfOwner', '', 'Queue', 'jbovlaste', 'AdminCc', '', 'Requestors', 'rlpowell at lojban.org', 'InitialPriority', 0, 'Starts', '', 'Attach', '', 'TimeWorked', '', 'id', 'new', 'Cc', '', 'Subject', 'test', 'new-RefersTo', '', 'FinalPriority', 0, 'RefersTo-new', '', 'TimeLeft', '', 'DependsOn-new', '', 'new-MemberOf', '', 'MemberOf-new', '', 'Content', 'test', 'Due', '') called at /usr/share/perl5/HTML/Mason/Request.pm line 1045
eval {...}('HTML::Mason::Component::FileBased=HASH(0x8f039b0)', 'Status', 'new', 'new-DependsOn', '', 'ValueOfOwner', '', 'Queue', 'jbovlaste', 'AdminCc', '', 'Requestors', 'rlpowell at lojban.org', 'InitialPriority', 0, 'Starts', '', 'Attach', '', 'TimeWorked', '', 'id', 'new', 'Cc', '', 'Subject', 'test', 'new-RefersTo', '', 'FinalPriority', 0, 'RefersTo-new', '', 'TimeLeft', '', 'DependsOn-new', '', 'new-MemberOf', '', 'MemberOf-new', '', 'Content', 'test', 'Due', '') called at /usr/share/perl5/HTML/Mason/Request.pm line 1039
HTML::Mason::Request::comp('HTML::Mason::Request::ApacheHandler=HASH(0x837e3b8)', 'HTML::Mason::Component::FileBased=HASH(0x8f039b0)', 'Status', 'new', 'new-DependsOn', '', 'ValueOfOwner', '', 'Queue', 'jbovlaste', 'AdminCc', '', 'Requestors', 'rlpowell at lojban.org', 'InitialPriority', 0, 'Starts', '', 'Attach', '', 'TimeWorked', '', 'id', 'new', 'Cc', '', 'Subject', 'test', 'new-RefersTo', '', 'FinalPriority', 0, 'RefersTo-new', '', 'TimeLeft', '', 'DependsOn-new', '', 'new-MemberOf', '', 'MemberOf-new', '', 'Content', 'test', 'Due', '') called at /usr/share/perl5/HTML/Mason/Request.pm line 735
HTML::Mason::Request::call_next('HTML::Mason::Request::ApacheHandler=HASH(0x837e3b8)') called at /usr/share/request-tracker/WebRT/html/autohandler line 58
HTML::Mason::Commands::__ANON__('Status', 'new', 'new-DependsOn', '', 'ValueOfOwner', '', 'Queue', 'jbovlaste', 'AdminCc', '', 'Requestors', 'rlpowell at lojban.org', 'InitialPriority', 0, 'Starts', '', 'Attach', '', 'TimeWorked', '', 'id', 'new', 'Cc', '', 'Subject', 'test', 'new-RefersTo', '', 'FinalPriority', 0, 'RefersTo-new', '', 'TimeLeft', '', 'DependsOn-new', '', 'new-MemberOf', '', 'MemberOf-new', '', 'Content', 'test', 'Due', '') called at /usr/share/perl5/HTML/Mason/Component.pm line 133
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x8f08e28)', 'Status', 'new', 'new-DependsOn', '', 'ValueOfOwner', '', 'Queue', 'jbovlaste', 'AdminCc', '', 'Requestors', 'rlpowell at lojban.org', 'InitialPriority', 0, 'Starts', '', 'Attach', '', 'TimeWorked', '', 'id', 'new', 'Cc', '', 'Subject', 'test', 'new-RefersTo', '', 'FinalPriority', 0, 'RefersTo-new', '', 'TimeLeft', '', 'DependsOn-new', '', 'new-MemberOf', '', 'MemberOf-new', '', 'Content', 'test', 'Due', '') called at /usr/share/perl5/HTML/Mason/Request.pm line 1040
eval {...}('HTML::Mason::Component::FileBased=HASH(0x8f08e28)', 'Status', 'new', 'new-DependsOn', '', 'ValueOfOwner', '', 'Queue', 'jbovlaste', 'AdminCc', '', 'Requestors', 'rlpowell at lojban.org', 'InitialPriority', 0, 'Starts', '', 'Attach', '', 'TimeWorked', '', 'id', 'new', 'Cc', '', 'Subject', 'test', 'new-RefersTo', '', 'FinalPriority', 0, 'RefersTo-new', '', 'TimeLeft', '', 'DependsOn-new', '', 'new-MemberOf', '', 'MemberOf-new', '', 'Content', 'test', 'Due', '') called at /usr/share/perl5/HTML/Mason/Request.pm line 1039
HTML::Mason::Request::comp('HTML::Mason::Request::ApacheHandler=HASH(0x837e3b8)', 'HASH(0x8f03974)', 'HTML::Mason::Component::FileBased=HASH(0x8f08e28)', 'Status', 'new', 'new-DependsOn', '', 'ValueOfOwner', '', 'Queue', 'jbovlaste', 'AdminCc', '', 'Requestors', 'rlpowell at lojban.org', 'InitialPriority', 0, 'Starts', '', 'Attach', '', 'TimeWorked', '', 'id', 'new', 'Cc', '', 'Subject', 'test', 'new-RefersTo', '', 'FinalPriority', 0, 'RefersTo-new', '', 'TimeLeft', '', 'DependsOn-new', '', 'new-MemberOf', '', 'MemberOf-new', '', 'Content', 'test', 'Due', '') called at /usr/share/perl5/HTML/Mason/Request.pm line 336
eval {...}('HTML::Mason::Request::ApacheHandler=HASH(0x837e3b8)', 'HASH(0x8f03974)', 'HTML::Mason::Component::FileBased=HASH(0x8f08e28)', 'Status', 'new', 'new-DependsOn', '', 'ValueOfOwner', '', 'Queue', 'jbovlaste', 'AdminCc', '', 'Requestors', 'rlpowell at lojban.org', 'InitialPriority', 0, 'Starts', '', 'Attach', '', 'TimeWorked', '', 'id', 'new', 'Cc', '', 'Subject', 'test', 'new-RefersTo', '', 'FinalPriority', 0, 'RefersTo-new', '', 'TimeLeft', '', 'DependsOn-new', '', 'new-MemberOf', '', 'MemberOf-new', '', 'Content', 'test', 'Due', '') called at /usr/share/perl5/HTML/Mason/Request.pm line 336
eval {...}('HTML::Mason::Request::ApacheHandler=HASH(0x837e3b8)', 'HASH(0x8f03974)', 'HTML::Mason::Component::FileBased=HASH(0x8f08e28)', 'Status', 'new', 'new-DependsOn', '', 'ValueOfOwner', '', 'Queue', 'jbovlaste', 'AdminCc', '', 'Requestors', 'rlpowell at lojban.org', 'InitialPriority', 0, 'Starts', '', 'Attach', '', 'TimeWorked', '', 'id', 'new', 'Cc', '', 'Subject', 'test', 'new-RefersTo', '', 'FinalPriority', 0, 'RefersTo-new', '', 'TimeLeft', '', 'DependsOn-new', '', 'new-MemberOf', '', 'MemberOf-new', '', 'Content', 'test', 'Due', '') called at /usr/share/perl5/HTML/Mason/Request.pm line 296
HTML::Mason::Request::exec('HTML::Mason::Request::ApacheHandler=HASH(0x837e3b8)') called at /usr/share/perl5/HTML/Mason/ApacheHandler.pm line 134
eval {...}('HTML::Mason::Request::ApacheHandler=HASH(0x837e3b8)') called at /usr/share/perl5/HTML/Mason/ApacheHandler.pm line 134
HTML::Mason::Request::ApacheHandler::exec('HTML::Mason::Request::ApacheHandler=HASH(0x837e3b8)') called at /usr/share/perl5/HTML/Mason/ApacheHandler.pm line 783
HTML::Mason::ApacheHandler::handle_request('HTML::Mason::ApacheHandler=HASH(0x82c62f0)', 'Apache=SCALAR(0x8cd17e0)') called at /usr/share/request-tracker/bin/webmux.pl line 172
RT::Mason::handler('Apache=SCALAR(0x8cd17e0)') called at /dev/null line 0
eval {...}('Apache=SCALAR(0x8cd17e0)') called at /dev/null line 0



More information about the rt-users mailing list