Web Content: Numbers of duplicate structure/template matched the number of role view permissions

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: No Longer Reproducible
• Affects Version/s: 6.1.1 CE GA2, 6.1.20 EE GA2, 6.2.0 CE M2
• Fix Version/s: --Sprint 11/12, 6.2.0 CE M2
• Component/s: Administration, Administration > Roles & Permissions, WCM > Web Content Administration
• Labels: None
• Environment: Tomcat 7.0.23 + MySQL 5.1. 6.1.1 CE GA2. ; Tomcat 7.0 + MySQL 5. EE 6.1.x GIT ID: 9c0d3e1cda05c312352bd1efdfbab946090e802c. ; Tomcat 7.0 + MySQL 5. 6.2.x GIT ID: 35a7cd4209c7e7100c6ad8798050932d0fe15451.
• Fix Priority: 2
• Similar Issues: Show 5 results ; ;

  LPS-15160	Results number not correct when defining permissions in roles.
  LPS-30938	Structures/templates should not have guest & site member view permission by default
  LPS-29326	Web Content: Duplicate structures when using custom Site role
  LPS-28550	Able to view any journal structure/template's source
  LPS-32084	Web Content Translations Don't Work With a Structure/Template

Here are steps on how to reproduce this issues:
1. Add a user.
2. Add a site, assign user to this site.
3. Add a role with attached defined permissions.
4. Assign the role to the user.
5. Add web content structure to this site. Pay attention how many roles have view permission.
6. Log in as the user in another browser.
7. Go to control panel -> web Content -> Structure.
You will see the duplicate structures. This also affect template.
If you change role view permissions, the numbers of structure matches the one of view permissions.

[Sophia Zhang]

It also affects 610EE.

[Oliver Bayer]

Hi Sophia,

I've faced the same issue and after some debugging I've found a working solution (at least in my usecase).

The problem is inside the journal/template_search_results.jspf. In this file JournalTemplateServiceUtil is used to call the search and searchCount method. Somewhere in the method chain JournalTemplateFinderImpl.doFindByC_G_T_S_N_D(....,boolean inlineSQLHelper) is called. If the variable inlineSQLHelper is set to true as it's the case when using JournalTemplateServiceUtil the roles are checked.

My bugfix/ proposal is to use the JournalTemplateLocalServiceUtil instead in the mentioned jspf file so that the variable inlineSQLHelper is false so the roles aren't checked. After this little bugfix which can be applied with a hook the journal templates are only shown once.

Hope this helps in your usecase too.

Greets Oli

[Sophia Zhang]

Hi Oli,
Thank you so much for your comment. Maybe it will be helpful to our developer.
Sophia

[rizwan]

Thanks OLI,
It's working

Rizwan.

[Sophia Zhang]

No longer reproducible on:
Tomcat 7.0 + MySQL 5. Portal 6.1.x EE GIT ID: 332ba8c2d833ebf997cdc790816ad3dbbc78cd1f.
Tomcat 7.0 + MySQL 5. Portal 6.2.x GIT ID: d3f751308f18d606074219d1d86dd32e2fb33542.
I will close it.