Hi,
i get SQL error when clicking
Configuration → Queues → Watchers
Here’s the postgresql log. Nothing in RT’s log.
If I try to add an AdminCC or Cc to the queue, I get “Group not found” in
the web gui.
It only fails for one group, and I can create new ones, so I’m OK, but
something was apparently bad when I first installed RT and created this
queue, which has not been used yet.
/Palle
Mar 23 22:16:33 banan postgres[58019]: [560-1] LOG: statement:
Mar 23 22:16:33 banan postgres[58019]: [561-1] LOG: duration: 1.455 ms
Mar 23 22:16:33 banan postgres[58019]: [562-1] LOG: statement:
Mar 23 22:16:33 banan postgres[58019]: [563-1] LOG: duration: 0.938 ms
Mar 23 22:16:33 banan postgres[58019]: [564-1] LOG: statement: SET TIME
ZONE ‘GMT’
Mar 23 22:16:33 banan postgres[58019]: [565-1] LOG: duration: 1.321 ms
Mar 23 22:16:33 banan postgres[58019]: [566-1] LOG: statement: SET
DATESTYLE TO ‘ISO’
Mar 23 22:16:33 banan postgres[58019]: [567-1] LOG: duration: 1.150 ms
Mar 23 22:16:33 banan postgres[58019]: [568-1] LOG: statement:
Mar 23 22:16:33 banan postgres[58019]: [569-1] LOG: duration: 1.414 ms
Mar 23 22:16:33 banan postgres[58019]: [570-1] LOG: statement:
Mar 23 22:16:33 banan postgres[58019]: [570-2] SELECT
a_session FROM sessions WHERE id = ‘78cd1e90b5316b42c247fc657b88fc6b’ FOR
UPDATE
Mar 23 22:16:33 banan postgres[58019]: [571-1] LOG: duration: 2.626 ms
Mar 23 22:16:33 banan postgres[58019]: [572-1] LOG: statement: SELECT *
FROM Users WHERE id = ‘22’
Mar 23 22:16:33 banan postgres[58019]: [573-1] LOG: duration: 3.565 ms
Mar 23 22:16:33 banan postgres[58019]: [574-1] LOG: statement: SELECT *
FROM Groups WHERE Type ILIKE ‘Privileged’ AND Domain ILIKE ‘SystemInternal’
Mar 23 22:16:33 banan postgres[58019]: [575-1] LOG: duration: 27.330 ms
Mar 23 22:16:34 banan postgres[58019]: [576-1] LOG: statement: SELECT *
FROM Principals WHERE PrincipalType ILIKE ‘User’ AND ObjectId = ‘22’
Mar 23 22:16:34 banan postgres[58019]: [577-1] LOG: duration: 2.677 ms
Mar 23 22:16:34 banan postgres[58019]: [578-1] LOG: statement: SELECT *
FROM GroupMembers WHERE GroupId = ‘4’ AND MemberId = ‘22’
Mar 23 22:16:34 banan postgres[58019]: [579-1] LOG: duration: 11.007 ms
Mar 23 22:16:34 banan postgres[58019]: [580-1] LOG: statement: SELECT *
FROM Groups WHERE Type ILIKE ‘Cc’ AND Instance = ‘5’ AND Domain ILIKE
‘RT::Queue-Role’
Mar 23 22:16:34 banan postgres[58019]: [581-1] LOG: duration: 30.448 ms
Mar 23 22:16:34 banan postgres[58019]: [582-1] LOG: statement: SELECT
count(main.id) FROM GroupMembers main WHERE ((main.GroupId = ))
Mar 23 22:16:34 banan postgres[58019]: [583-1] ERROR: syntax error at or
near “)” at character 71
Mar 23 22:16:34 banan postgres[58019]: [583-2] STATEMENT: SELECT
count(main.id) FROM GroupMembers main WHERE ((main.GroupId = ))
Mar 23 22:16:34 banan postgres[58019]: [584-1] LOG: statement: SELECT *
FROM Groups WHERE Type ILIKE ‘AdminCc’ AND Instance = ‘5’ AND Domain ILIKE
‘RT::Queue-Role’
Mar 23 22:16:34 banan postgres[58019]: [585-1] LOG: duration: 31.811 ms
Mar 23 22:16:34 banan postgres[58019]: [586-1] LOG: statement: SELECT
count(main.id) FROM GroupMembers main WHERE ((main.GroupId = ))
Mar 23 22:16:34 banan postgres[58019]: [587-1] ERROR: syntax error at or
near “)” at character 71
Mar 23 22:16:34 banan postgres[58019]: [587-2] STATEMENT: SELECT
count(main.id) FROM GroupMembers main WHERE ((main.GroupId = ))