[rt-users] problem creating tickets

[Phil Homewood]

John Jasen wrote:
> LOG:  query: INSERT INTO Tickets (Starts, Type, Priority, Resolved, Status, Queue, Owner, InitialPriority, FinalPriority, Subject, Creator, LastUpdatedBy, Created, TimeLeft, TimeWorked, LastUpdated, Due) VALUES ('1970-01-01 00:00:00', 'ticket', '0', NULL, 'new', '1', '2', '0', '0', 'ifs crashes when ...', '4', '4', '2002-12-13 21:43:30', '', '', '2002-12-13 21:43:30', '1970-01-01 00:00:00')
> ERROR:  pg_atoi: zero-length string

I'm not a postgres user, so this is untested, but see if it helps.

-- 
Phil Homewood, Systems Janitor, www.SnapGear.com
pdh at snapgear.com Ph: +61 7 3435 2810 Fx: +61 7 3891 3630
SnapGear - Custom Embedded Solutions and Security Appliances
-------------- next part --------------
Index: webrt/Ticket/Create.html
===================================================================
RCS file: /cvs/local/rt/webrt/Ticket/Create.html,v
retrieving revision 1.1.1.3
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>