Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.
Just a note for anyone troubleshooting this - if your schema is missing this update (which I encountered updating from 7-alpha6 to 7.0), you'll see the following message when saving a node with term references:
PDOException: 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 '))' at line 2: SELECT base.tid AS tid, base.vid AS vid, base.name AS name, base.description AS description, base.format AS format, base.weight AS weight, v.machine_name AS vocabulary_machine_name FROM {taxonomy_term_data} base INNER JOIN {taxonomy_vocabulary} v ON base.vid = v.vid WHERE (base.name LIKE :db_condition_placeholder_0 ESCAPE '\\') AND (base.vid IN ()) ; Array ( [:db_condition_placeholder_0] => performance ) in DrupalDefaultEntityController->load() (line 196 of drupal/includes/entity.inc).
Comments
Comment #1
yhahn commentedPatch attached, contingent upon issue above.
Comment #2
catchPatch looks good, tested on ex2 database and confirmed the field settings are updated correctly. Committed - http://drupal.org/cvs?commit=431642
Comment #4
grendzy commentedJust a note for anyone troubleshooting this - if your schema is missing this update (which I encountered updating from 7-alpha6 to 7.0), you'll see the following message when saving a node with term references:
PDOException: 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 '))' at line 2: SELECT base.tid AS tid, base.vid AS vid, base.name AS name, base.description AS description, base.format AS format, base.weight AS weight, v.machine_name AS vocabulary_machine_name FROM {taxonomy_term_data} base INNER JOIN {taxonomy_vocabulary} v ON base.vid = v.vid WHERE (base.name LIKE :db_condition_placeholder_0 ESCAPE '\\') AND (base.vid IN ()) ; Array ( [:db_condition_placeholder_0] => performance ) in DrupalDefaultEntityController->load() (line 196 of drupal/includes/entity.inc).To fix it, just run head2head_881530 manually.