Drupal 7: PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: 'autocreate' for column ...

Drupal 7Encountered an error message which I thought had something to do with upgrading the CKEditor 7.1.x module, but this wasn't the case.

Couldn't add any content and I kept seeing the error message as shown below:

The website encountered an unexpected error. Please try again later.
Error messagePDOException: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: 'autocreate' for column 'x' at row 1: INSERT INTO {field_data_field_job_title} (entity_type, entity_id, revision_id, bundle, delta, language, x) 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); Array ( [:db_insert_placeholder_0] => profile2 [:db_insert_placeholder_1] => 106 [:db_insert_placeholder_2] => 106 [:db_insert_placeholder_3] => my_work_profile [:db_insert_placeholder_4] => 0 [:db_insert_placeholder_5] => und [:db_insert_placeholder_6] => autocreate ) in field_sql_storage_field_storage_write() (line 448 of /x/modules/field/modules/field_sql_storage/field_sql_storage.module).

In my case the solution was to remove one of the two taxonomy fields present in a content type and now everything works fine again.

Izdelava spletnih strani ganesa.si

Izdelava spletnih strani ganesa.si