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 using the widget with MySQL 5.7 or later in strict mode, the following exception is raised:
General error: 3065 Expression #1 of ORDER BY clause is not in SELECT list
This is because in the function _term_reference_tree_get_children() there is an SQL query created with order by t.weight, but t.weight is not present in the list of fields.
Comment | File | Size | Author |
---|---|---|---|
#2 | mysql_exception-3145685-1.patch | 569 bytes | alfaguru |
Comments
Comment #2
alfaguru CreditAttribution: alfaguru commentedPatch attached.
Comment #3
jaydub CreditAttribution: jaydub commented