[rt-users] problem creating tickets

[Jesse Vincent]

in  lib/RT/Ticket.pm, there's a routine called "Create".

it contains the line:

 my ($val, $msg) = $self->__Set(Field => 'EffectiveId', Value => $id);

For debugging purposes, it would be incredibly useful if you would
insert the following lines before that line:

use Data::Dumper;
die scalar Dumper($id);

Then, stop apache, start apache and try creating a ticket over the web.
It _will_ die with an error. send the full text of that error to the
list.

There's some error condition with postgres 7.3 that we're not handling
and clearly not aware of.

As a temporary fix, try replacing that with:

 my ($val, $msg) = $self->__Set(Field => 'EffectiveId', Value => $self->id);

and tell me if the problem goes away?



On Fri, Dec 13, 2002 at 03:34:06PM -0500, John Jasen wrote:
> 
> System: Redhat Linux 6.2/alpha
> DB: Postgres 7.3
> RT version: 2.0.15
> 
> I went through, got RT up and running, created users, set permissions, and 
> a whole buncha other stuff, but, creating a test ticket, I got this 
> message after hitting submit.
> 
> http://rt.server/rt2/Ticket/Display.html
> 
> System error
> error:  Can't bind a reference (Class::ReturnValue=HASH(0x122911000)) at 
> /usr/lib/perl5/site_perl/5.005/DBIx/SearchBuilder/Handle.pm line 376.
> context: 
> ... 
> 372:  do_backtrace => undef);
> 373:  return ($ret->return_value);
> 374:  }
> 375:  }
> 376:  unless ( $sth->execute(@bind_values) ) {
> 377:  if ($DEBUG) {
> 378:  die "$self couldn't execute the query '$QueryString'"
> 379:  . $self->dbh->errstr . "\n";
> 380: 
> ... 
> code stack:  
> /usr/lib/perl5/site_perl/5.005/DBIx/SearchBuilder/Handle.pm:376
> /usr/lib/perl5/site_perl/5.005/DBIx/SearchBuilder/Handle.pm:319
> /usr/lib/perl5/site_perl/5.005/DBIx/SearchBuilder/Record.pm:636
> /usr/local/rt2/lib/RT/Ticket.pm:342
> /usr/local/rt2/WebRT/html/Ticket/Display.html:87
> /usr/local/rt2/WebRT/html/autohandler:58
> 
> _______________________________________________
> rt-users mailing list
> rt-users at lists.fsck.com
> http://lists.fsck.com/mailman/listinfo/rt-users
> 
> Have you read the FAQ? The RT FAQ Manager lives at http://fsck.com/rtfm
> 

-- 
»|« http://www.bestpractical.com/rt  -- Trouble Ticketing. Free.