[rt-users] Error when adding (admin-)Cc:s

[Palle Girgensohn]

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