adam at RFXTechnologies
Mar 17, 2011, 6:55 AM
Post #2 of 5
Well, I found what I was looking for ultimately, which was the incorrect information in the DB.
SELECT category.id, site.name, directory, uri, category."name", category.description, category.parent_id,
asset_grp_id, category.active,grp.id as "Group ID", grp.parent_id, grp.class__id, grp."name", grp.description, grp.secret, grp.permanent,
left outer join site on site__id = site.id
inner join grp on asset_grp_id=grp.id and category.active <> grp.active
Can anyone think of an instance when this query should return data?
> -----Original Message-----
> From: users [at] lists
> [mailto:users [at] lists] On Behalf Of Adam Wilson
> Sent: Thursday, March 17, 2011 9:22 AM
> To: users [at] lists
> Subject: Category deactive/reactive issues
> The business decided to no longer use a category, so I deactivated it.
> Then, they decided they wanted it back, so I re-active it.
> Everything works fine, except the new stories are not visible to the
> users. I can see it fine, as an administrator.
> I checked group permissions for the category, and find that the
> reactivated category is not in the list of site categories.
> Can someone point me to the SQL query that determines the list of
> categories displayed for a site group on the Group Permissions UI so
> that I can track down the missing or incorrect information in the
> database that is preventing the category from showing, and thereby not
> allowing non-admins access to the stories therein?
> Thank you,
> Adam W.