Can't create ticket from web interface! ("Can't bind a reference")

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

rterror (8.79 KB)

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.

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

So. this tells us that you’re running Postgres 7.3. What RT are you
running?

-Robin

http://www.bestpractical.com/rt – Trouble Ticketing. Free.

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.

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

So. this tells us that you’re running Postgres 7.3. What RT are you
running?

Sorry.

Latest Debian package.

rt --version gives:

RT 2.0.14 for lojban.org. Copyright 1996-2001 Jesse Vincent
jesse@fsck.com

-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

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.

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

So. this tells us that you’re running Postgres 7.3. What RT are you
running?

Sorry.

Latest Debian package.

rt --version gives:

RT 2.0.14 for lojban.org. Copyright 1996-2001 Jesse Vincent
jesse@fsck.com

Ahem.

Jesse pointed out privately that this has been discussed before. I said
I had downloaded and grep’d the whole archive looking for it. Turns out
the file I was grep’ing was incomplete. Ooops. ht://dig kept trying to
do synonyms for the string I entered that caused me to be unable to find
what I was looking for as well.

Anyways, I grep’d the real archive file, and found the following patch
from Jesse, which does work to solve this problem for me, for the
record.

diff -u -r1.1.1.3 Create.html
— webrt/Ticket/Create.html 23 Jan 2002 00:47:58 -0000 1.1.1.3
+++ webrt/Ticket/Create.html 17 Dec 2002 00:13:51 -0000
@@ -104,8 +104,8 @@

- - + +
Priority:
Final Priority:
Time Worked:
Time Left:
Time Worked:
Time Left:
<& /Elements/TitleBoxEnd &>

Sorry for my stupidity! And thanks for the patch.

-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