[rt-users] problem creating tickets

John Jasen jjasen at datafoundation.com
Mon Dec 16 11:13:30 EST 2002


here's some logs from trying to create a ticket.


postmaster successfully started
LOG:  database system was shut down at 2002-12-13 16:42:43 EST
LOG:  checkpoint record is at 0/B3F790
LOG:  redo record is at 0/B3F790; undo record is at 0/0; shutdown TRUE
LOG:  next transaction id: 11788; next oid: 17654
LOG:  database system is ready
LOG:  connection received: host=127.0.0.1 port=3798
LOG:  connection authorized: user=rt_user database=rt2
LOG:  query: begin; select getdatabaseencoding(); commit
LOG:  query: SET TIME ZONE 'GMT'
LOG:  query: SET DATESTYLE TO 'ISO'
LOG:  query: SELECT  * FROM Users WHERE lower(Name) = 'rt_system'
LOG:  query: SELECT  * FROM Users WHERE lower(Name) = 'nobody'
LOG:  query: SELECT  * FROM Queues WHERE lower(Name) = 'ifs'
LOG:  query: SELECT COUNT(ACL.id) FROM ACL, Groups WHERE  (((RightScope = 'Queue') AND (RightAppliesTo = 1))) AND ((RightName = 'CreateTicket')) AND (((Groups.Name = 'Everyone') AND 
                                       (PrincipalType = 'Group') AND 
                                       (Groups.Id = PrincipalId)))
LOG:  query: SELECT COUNT(ACL.id) FROM ACL, GroupMembers, Groups WHERE  ((((((RightScope = 'Queue') AND (RightAppliesTo = 1))) AND ((RightName = 'CreateTicket'))) OR ((RightName = 'SuperUser') AND (RightScope = 'System') AND (RightAppliesTo = 0)))  AND (((ACL.PrincipalType = 'Group') AND (ACL.PrincipalId = Groups.Id) AND (GroupMembers.GroupId = Groups.Id)  AND (GroupMembers.UserId = 4))))
LOG:  query: SELECT COUNT(ACL.id) FROM ACL WHERE  (((((RightScope = 'Queue') AND (RightAppliesTo = 1))) AND ((RightName = 'CreateTicket'))) OR ((RightName = 'SuperUser') AND (RightScope = 'System') AND (RightAppliesTo = 0)))  AND (((PrincipalType = 'User') AND (PrincipalId = 4)))
LOG:  query: SELECT  * FROM Users WHERE id = '2'
LOG:  query: SELECT  * FROM Queues WHERE id = '1'
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
LOG:  statement: 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')
LOG:  query: SELECT  * FROM Users WHERE lower(EmailAddress) = 'jjasen at datafoundation.com'
LOG:  query: SELECT  * FROM Watchers WHERE Email is null AND Owner = '4' AND lower(Scope) = 'ticket' AND lower(Type) = 'requestor' AND Value is null
LOG:  query: UPDATE Tickets SET LastUpdated='2002-12-13 21:43:30' WHERE id=NULL 
LOG:  query: UPDATE Tickets SET LastUpdatedBy='4' WHERE id=NULL 
LOG:  query: UPDATE Tickets SET TimeWorked=0 WHERE id=NULL 
LOG:  query: SELECT DISTINCT main.* FROM Queues main   WHERE ((main.Disabled = '0'))  ORDER BY main.Name ASC
LOG:  connection received: host=127.0.0.1 port=3799
LOG:  connection authorized: user=rt_user database=rt2
LOG:  query: begin; select getdatabaseencoding(); commit
LOG:  query: SET TIME ZONE 'GMT'
LOG:  query: SET DATESTYLE TO 'ISO'
LOG:  connection received: host=127.0.0.1 port=3800
LOG:  connection authorized: user=rt_user database=rt2
LOG:  query: begin; select getdatabaseencoding(); commit
LOG:  query: SET TIME ZONE 'GMT'
LOG:  query: SET DATESTYLE TO 'ISO'
LOG:  connection received: host=127.0.0.1 port=3801
LOG:  connection authorized: user=rt_user database=rt2
LOG:  query: begin; select getdatabaseencoding(); commit
LOG:  query: SET TIME ZONE 'GMT'
LOG:  query: SET DATESTYLE TO 'ISO'
LOG:  query: SELECT  * FROM Users WHERE lower(Name) = 'rt_system'
LOG:  query: SELECT  * FROM Users WHERE lower(Name) = 'nobody'




More information about the rt-users mailing list