Duplicated rows on admin/content if author is translated

Created on 7 October 2015, about 9 years ago
Updated 30 April 2024, 7 months ago

Problem/Motivation

- Install with Standard profile in English.
- Turn on the 4 multilingual modules.
- Add Spanish language.
- Make Node translatable (both content types), and User.
- Add an English Article node translated to Spanish, and a Spanish Page node
translated to English.
- Translate User 1 into Spanish

Now go to admin/content. You will see 2 copies of each translation in the table. This is really pretty horrible.

The reason, I think, is that there is probably a join between node and user in this view, which multiplies the number of rows because both node and user have 2 entries per item in the field data tables.

Proposed resolution

Fix it so that there is only one copy of each translation in the table. I have no idea how to do this.

Remaining tasks

Make a patch. See #15
Add tests
Review
Commit

User interface changes

TBA - before and after screenshots

API changes

Probably not.

Data model changes

Shouldn't be.

🐛 Bug report
Status

Active

Version

11.0 🔥

Component
Views 

Last updated about 5 hours ago

Created by

🇺🇸United States jhodgdon Spokane, WA, USA

Live updates comments and jobs are added and updated live.
  • Usability

    Makes Drupal easier to use. Preferred over UX, D7UX, etc.

  • VDC

    Related to the Views in Drupal Core initiative.

  • Needs manual testing

    The change/bugfix cannot be fully demonstrated by automated testing, and thus requires manual testing in a variety of environments.

  • Triaged core major

    There is consensus among core maintainers that this is a major issue. Only core committers should add this tag.

Sign in to follow issues

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

  • 🇳🇿New Zealand quietone

    @ravi.shankar, thanks for rerolling.

    I don't that #13 should have been rerolled. In #15, a maintainer explains why that patch is not the desired approach. I don't understand why #34 needs to be addressed, in that comment @jhodgdon was explaining why the suggestion in the previous comment was already discussed and is not the solution.

    I would think that patch needs to follow the direction in #15. And since there isn't a patch for that I am setting this to active.

  • 🇫🇮Finland heikkiy Oulu

    I can also confirm that #30 solves the issue. We had a confusing list of duplicated content in the admin/content listing when we added an exposed filter for the Author to be able to find the content for certain user more easily.

  • 🇺🇸United States Greg Boggs Portland Oregon

    This has been marked major for 8 years. So, maybe not major?

    I fixed this is a couple of minutes by adding a filter to the author for the current interface language. I get no duplicates. I am not really sure about the joins and filters mentioned in 15, but adding this filter works for me.

Production build 0.71.5 2024