[rt-users] problem with creating new ticket.

[B. Ash]

I think I found the problem.  rt2 is trying to insert a unique primary 
key for a ticket that already exists.

I am working from a mysqldump that has been imported directly into 
postgresql from an earlier version of rt2.  Is there any way to tell rt 
where to start from as far as primary keys go?  This process was done on 
a seperate server not running the older version of rt2, and I did not 
perform the make upgrade, just make install.

Thanks

--bash

here is the postgresql debug:

DEBUG:  query: INSERT INTO Tickets (Subject, Status, FinalPriority, 
TimeLeft, Queue, Creator, Owner, LastUpdatedBy, Type, InitialPriority, 
Resolved, Starts, Created, TimeWorked Priority, LastUpdated, Due) VALUES 
('test', 'new', '0', '', '7', '10', '2', '10', 'ticket', '0', NULL, 
'1970-01-01 00:00:00', '2003-02-03 22:34:58', '', '0', '2003-02-03 
22:3458', '1970-01-01 00:00:00')
DEBUG:  ProcessQuery
ERROR:  Cannot insert a duplicate key into unique index tickets_pkey
DEBUG:  AbortCurrentTransaction

B. Ash wrote:
> Hi,
> 
> I receive this error when trying to create a new ticket, running 
> postgresql, perl5.8.0, and rt-2.0-15, if anyone can assist that would be 
> great..  Note I am able to call up all previous records, search etc... 
> Thanks
> 
> "System error
> error:  Can't bind a reference (Class::ReturnValue=HASH(0x91c9288)) at 
> /usr/local/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm line 
> 376, line 79.
> 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/local/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm:376
> /usr/local/lib/perl5/site_perl/5.8.0/DBIx/SearchBuilder/Handle.pm:319
> /usr/local/lib/perl5/site_perl/5.8.0/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
> raw error"
> 
> _______________________________________________
> 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