[rt-users] problem creating tickets

[Jesse Vincent]

So, this is the same problem we've been discussing elsewhere on
rt-users. Postgres 7.3 changed some underlying magic. I posted a change
to Ticket->Create that I'd like people to try. If that works, it'll be
in 2.0.16


On Tue, Dec 17, 2002 at 10:16:17AM +1000, Phil Homewood wrote:
> 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

> 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>


-- 
»|« http://www.bestpractical.com/rt  -- Trouble Ticketing. Free.