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.When Content translation: Child translation is used a SQL error is shown:
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.tnid0 IS NULL ) ))) subquery' at line 1
This seems to be the same error as #1224630: Filter by Content translation: Source translation causes an SQL error, because fix is the same (use query->add_where_expression instead query->add_where).
| Comment | File | Size | Author |
|---|---|---|---|
| #3 | sql_error.JPG | 150.24 KB | mohankirar |
| #1 | filter-node-tnid-child-1272350-1.patch | 684 bytes | tunic |
Comments
Comment #1
tunicPatch attatched. Giving same prority as mentioned bug.
Comment #2
dawehnerGreat, thanks!
The patch looked fine and worked fine, commited to 7.x-3.x
Comment #3
mohankirar CreditAttribution: mohankirar commentedGot sql error when saved view after applying filter to existing view.
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')))) subquery' at line 3
Comment #4
dawehnerCan you please try to show the full sql query to see whether it's the same bug as this one?
If it's the same bug please update to the latest version of views.
Comment #5
esmerel CreditAttribution: esmerel commented