Assigning a role via SQL query works but doesn't work
I have setup an automated SQL query to assign members a role that allows them to see a private forum. This is done via GDN_UserRole table.
On the surface it appears to work - looking at dashboard/users it shows the role assigned to the member. However, the member doesn't see the private forum unless the role is manually assigned via the dashboard by an admin.
Is there another modification needed in the database other than GDN_UserRole for a role to be fully assigned?