I am trying to merge some terms but getting this error. Tried both modules, Merge Terms and Taxanomy Manager.
An AJAX HTTP error occurred. HTTP Result Code: 500 Debugging information follows. Path: /batch?id=656&op=do StatusText: Service unavailable (with message) ResponseText: 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 1: INSERT INTO {field_data_field_source} (entity_type, entity_id, revision_id, bundle, delta, language, field_source_url, field_source_title, field_source_attributes) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, ); Array ( [:db_insert_placeholder_0] => node [:db_insert_placeholder_1] => 3408 [:db_insert_placeholder_2] => 3705 [:db_insert_placeholder_3] => news [:db_insert_placeholder_4] => 0 [:db_insert_placeholder_5] => und [:db_insert_placeholder_6] => http://aseigo.blogspot.com/2012/03/spark-becomes-vivaldi.html [:db_insert_placeholder_7] => Aaron Seigo ) in field_sql_storage_field_storage_write() (line 448 of /home/example.com/modules/field/modules/field_sql_storage/field_sql_storage.module).
On Tue, Mar 27, 2012 at 7:02 AM, Swapnil Bhartiya swapnil.bhartiya@gmail.com wrote:
I am trying to merge some terms but getting this error. Tried both modules, Merge Terms and Taxanomy Manager.
An AJAX HTTP error occurred. HTTP Result Code: 500 Debugging information follows. Path: /batch?id=656&op=do StatusText: Service unavailable (with message) ResponseText: 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 1: INSERT INTO {field_data_field_source} (entity_type, entity_id, revision_id, bundle, delta, language, field_source_url, field_source_title, field_source_attributes) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7, ); Array ( [:db_insert_placeholder_0] => node [:db_insert_placeholder_1] => 3408 [:db_insert_placeholder_2] => 3705 [:db_insert_placeholder_3] => news [:db_insert_placeholder_4] => 0 [:db_insert_placeholder_5] => und [:db_insert_placeholder_6] => http://aseigo.blogspot.com/2012/03/spark-becomes-vivaldi.html [:db_insert_placeholder_7] => Aaron Seigo ) in field_sql_storage_field_storage_write() (line 448 of /home/example.com/modules/field/modules/field_sql_storage/field_sql_storage.module).
The INSERT VALUES has 9 fields but only 7 placeholder values given. You'll need to go to the issue queue for the module(s) at drupal.org/project/issues/MODULE. Replace MODULE with the module name as seen in the directory.