Problem with creating new ticket

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”

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:

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”

I also have this problem. The problem seems to occur whenever anyone
creates or modifies the text field (comments). Changing statii or owners,
etc. doesn’t cause the problem.

I’m using Perl5.6.1 under NetBSD. Here are all the versions of the Perl
modules on the system. Does anyone see any glaring incompatabilities
between any of these versions and RT?

p5-Apache-Session-1.54/
p5-Attribute-Handlers-0.77/
p5-BSD-Resource-1.15/
p5-CGI-2.79/
p5-Class-ReturnValue-0.40/
p5-Compress-Zlib-1.16/
p5-DBD-mysql-2.1017/
p5-DBD-postgresql-1.21/
p5-DBI-1.30/
p5-DBIx-DataSource-0.02/
p5-DBIx-SearchBuilder-0.76/
p5-Data-ShowTable-3.3/
p5-Devel-StackTrace-1.02/
p5-Digest-MD5-2.22/
p5-FCGI-0.58/
p5-FreezeThaw-0.41/
p5-GD-1.32nb1/
p5-HTML-Mason-1.04/
p5-HTML-Parser-3.26/
p5-HTML-Tagset-3.03/
p5-HTML-Template-2.6/
p5-IO-Socket-SSL-0.91/
p5-IO-stringy-2.108/
p5-Image-Size-2.980/
p5-Log-Dispatch-1.79/
p5-MIME-Base64-2.16/
p5-MIME-tools-5.411.1/
p5-MLDBM-2.00/
p5-MailTools-1.49/
p5-Net-1.12/
p5-Net-SSLeay-1.21/
p5-Params-Validate-0.15/
p5-PerlMagick-5.5.3.2/
p5-Storable-2.04/
p5-Test-Harness-2.26/
p5-Test-Inline-0.15/
p5-Test-Simple-0.47/
p5-Text-Template-1.43/
p5-Text-Wrapper-1.0/
p5-Tie-IxHash-1.21/
p5-TimeDate-1.10/
p5-URI-1.22/
p5-gdbm-1.05nb1/
p5-libapreq-0.33/
p5-libwww-5.67/

  • Julian

| Julian C. Dunn jdunn@aquezada.com |
| WWW: Julian Dunn's Blog - Commentary on media, technology, and everything in between. |
| “I’ve got love and anger, they come as a pair” – Aimee Mann |