[rt-users] How to create a new RoleGroup?

[patrick.schoenenberg at web.de]

Hi,

I finally found the problem.
Some Upgrade-Script deleted the "AdminCc, Cc, Owner, Requestor"-entries in the column 'name' in the
table group. Column updated (the correct entries are also in the column type) and it works. 

Greetings
Patrick
 
 

Gesendet: Mittwoch, 04. Januar 2017 um 15:41 Uhr
Von: "Matt Zagrabelny" <mzagrabe at d.umn.edu>
An: patrick.schoenenberg at web.de
Cc: rt-users <rt-users at lists.bestpractical.com>
Betreff: Re: [rt-users] How to create a new RoleGroup?
On Wed, Jan 4, 2017 at 8:30 AM, <patrick.schoenenberg at web.de> wrote:

> I logged into RT as an admin:
> -> Admin -> Queues -> Select Queue -> Watchers
>
> Then:
> - New Watcher -> Find NAME -> Choose Option "AdminCc" --> Save Changes
> ERROR: Role group 'AdminCc' not found

I just ran a quick test and it works for me with 4.2.11.

> The Debug-Log says:
>
> "[7814] [Wed Jan 4 14:28:00 2017] [warning]: Use of uninitialized value in
> join or string at /usr/share/perl5/DBIx/SearchBuilder.pm line 1087, <DATA>
> line 1662. (/usr/share/perl5/DBIx/SearchBuilder.pm:1087)
> [7814] [Wed Jan 4 14:28:00 2017] [warning]: DBD::Pg::st execute failed:
> FEHLER: Syntaxfehler bei »)«
> LINE 1: ...nt(main.id) FROM GroupMembers main WHERE (main.GroupId = )
> ^ at
> /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 586, <DATA> line 1662.
> (/usr/share/perl5/DBIx/SearchBuilder/Handle.pm:586)

Looking at the above SQL error it looks lie there is no main.GroupId
in the query. The formatting of the email causes the caret (^)
indicator to not point at the right error.

What would cause the GroupId to be scrubbed?

Do you have some custom JS or any Overlays or Callbacks that would interfere?

-m