[rt-users] problem creating tickets

[Jesse Vincent]

Hm, that looks like the basic insert is totally failing. Can you turn on
postgres query logging and seeing exactly what's being sent over the
wire to the database?a

'ERROR: pg_atoi: zero-length string' doesn't really clue me in.

	-j


On Fri, Dec 13, 2002 at 03:47:05PM -0500, John Jasen wrote:
> 
> changes made with Data::Dumper
> 
> new error is:
> 
> System error
> error:  $VAR1 = bless( {
> 'error_message' => 'Couldn\'t execute the query \'INSERT INTO Tickets 
> (Starts, Type, Priority, Resolved, Status, Queue, Owner, InitialPriority, 
> FinalPriority, Subject, Creator, LastUpdatedBy, Created, TimeLeft, 
> TimeWorked, LastUpdated, Due) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 
> ?, ?, ?, ?, ?)\'ERROR: pg_atoi: zero-length string', 'errno' => -1 }, 
> 'Class::ReturnValue' );
> context: 
> ... 
> 339:  Due => $due->ISO
> 340:  );
> 341:  #Set the ticket's effective ID now that we've created it.
> 342:  use Data::Dumper;
> 343:  die scalar Dumper($id);
> 344:  my ($val, $msg) = $self->__Set(Field => 'EffectiveId', Value => 
> $id);
> 345: 
> 346:  unless ($val) {
> 347:  $RT::Logger->err("$self ->Create couldn't set EffectiveId: $msg\n");
> ... 
> code stack:  /usr/local/rt2/lib/RT/Ticket.pm:343
> /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.