[rt-users] Can't create ticket from web interface! ("Can't bind a reference")

[Robin Lee Powell]

On Wed, Mar 05, 2003 at 11:32:47AM -0800, Robin Lee Powell wrote:
> On Wed, Mar 05, 2003 at 02:27:08PM -0500, Jesse Vincent wrote:
> > On Wed, Mar 05, 2003 at 11:22:55AM -0800, Robin Lee Powell wrote:
> > > 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?
> 
> <blush>  Sorry.
> 
> Latest Debian package.
> 
> rt --version gives:
> 
> RT 2.0.14 for lojban.org. Copyright 1996-2001 Jesse Vincent
> <jesse at 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 @@
 <TABLE BORDER=0>
 <TR><TD ALIGN=RIGHT>Priority:</TD><TD><input size=3 name="InitialPriority" value="<%$QueueObj->InitialPriority%>"></TD></TR>
 <TR><TD ALIGN=RIGHT>Final Priority:</TD><TD><input size=3 name="FinalPriority" value="<%$QueueObj->FinalPriority%>"></TD></TR>
-<TR><TD ALIGN=RIGHT>Time Worked:</TD><TD><input size=3 name="TimeWorked"></TD></TR>
-<TR><TD ALIGN=RIGHT>Time Left:</TD><TD><input size=3 name="TimeLeft"></TD></TR>
+<TR><TD ALIGN=RIGHT>Time Worked:</TD><TD><input size=3 name="TimeWorked" value="0"></TD></TR>
+<TR><TD ALIGN=RIGHT>Time Left:</TD><TD><input size=3 name="TimeLeft" value="0"></TD></TR>
 </TABLE>
 <& /Elements/TitleBoxEnd &>
 <BR>

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