Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.Hi,
Not sure if this is the right queue to post this issue, it could also be related to the entity_translation module.
case:
I have a multilingual drupal commerce set-up, using the entity_translation module with 3 languages(fr, nl, en).
When I create a product, i want this product to show up for the correct language if there is a translation for the correct language otherwise I don't want the product to be displayed at all.
issue:
I created a view that lists all products with 2 relations:
- Content: Referenced product (works fine)
- Commerce Product: Entity translation: translations (throws a mysql syntax error)
I added a picture of the view I created together with the error.
Sincerely,
Dimitri
| Comment | File | Size | Author |
|---|---|---|---|
| #4 | entity-translation-left-table-4.patch | 646 bytes | fabsor |
| drupal_issue.PNG | 113.45 KB | dimitrileonidas | |
Comments
Comment #1
rszrama CreditAttribution: rszrama commentedYeah, that isn't something we have the expertise to address in here. If you haven't already cross-posted to the Entity Translation queue, please reopen this issue and move it to that queue.
Comment #2
dimitrileonidas CreditAttribution: dimitrileonidas commentedComment #3
fabsor CreditAttribution: fabsor commentedI can confirm this bug, and it only occurs when you add an entity translation relationship to an entity that is not the base entity type for a view.
Comment #4
fabsor CreditAttribution: fabsor commentedIt seems like we must use the table alias for the left table in order for the relationship to work with more complex queries. This patch should do the trick.
Comment #5
plachComment #6
dimitrileonidas CreditAttribution: dimitrileonidas commentedThis worked just fine! Thanks a lot!
Comment #7
dimitrileonidas CreditAttribution: dimitrileonidas commentedComment #8
plachCommitted and pushed, thanks!