I've been experiencing this problem with Deploy.

I have DEV, QA and Production stages. I keep running into the error below. When I deployed from DEV to QA I kept deploying and then removing the problem node and products. Until in the end the remaining content went across. On the source website I see this

An AJAX HTTP error occurred. HTTP Result Code: 500 Debugging information follows. Path: /batch?render=overlay&id=210&op=do StatusText: Service unavailable (with message) ResponseText: DeployServiceException: Service error: 406 Not Acceptable : exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1366 Incorrect integer value: 'cb1f2ecf-4979-405c-a280-9be9381ab339' for column 'field_mt_product_product_id' at row 1' in /includes/database/database.inc:2227Stack trace:#0 /includes/database/database.inc(2227): PDOStatement->execute(Array)#1 /includes/database/database.inc(697): DatabaseStatementBase->execute(Array, Array)#2 /includes/database/mysql/query.inc(36): DatabaseConnection->query('INSERT INTO {fi...', Array, Array)#3 /modules/field/modules/field_sql_storage/field_sql_storage.module(514): InsertQuery_mysql->execute()#4 [internal function]: field_sql_storagX-Powered-By: PHP/5.6.37 in DeployServiceRest->httpRequest() (line 78 of /sites/all/modules/contrib/deploy/includes/DeployServiceRest.inc).

Whilst on the destination website I see this:

PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: 'cb1f2ecf-4979-405c-a280-9be9381ab339' for column 'field_mt_product_product_id' at row 1: INSERT INTO {field_data_field_mt_product} (entity_type, entity_id, revision_id, bundle, delta, language, field_mt_product_product_id) 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, :db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10, :db_insert_placeholder_11, :db_insert_placeholder_12, :db_insert_placeholder_13), (:db_insert_placeholder_14, :db_insert_placeholder_15, :db_insert_placeholder_16, :db_insert_placeholder_17, :db_insert_placeholder_18, :db_insert_placeholder_19, :db_insert_placeholder_20); Array ( [:db_insert_placeholder_0] => node [:db_insert_placeholder_1] => 212 [:db_insert_placeholder_2] => 212 [:db_insert_placeholder_3] => mt_product [:db_insert_placeholder_4] => 0 [:db_insert_placeholder_5] => und [:db_insert_placeholder_6] => cb1f2ecf-4979-405c-a280-9be9381ab339 [:db_insert_placeholder_7] => node [:db_insert_placeholder_8] => 212 [:db_insert_placeholder_9] => 212 [:db_insert_placeholder_10] => mt_product [:db_insert_placeholder_11] => 1 [:db_insert_placeholder_12] => und [:db_insert_placeholder_13] => 270 [:db_insert_placeholder_14] => node [:db_insert_placeholder_15] => 212 [:db_insert_placeholder_16] => 212 [:db_insert_placeholder_17] => mt_product [:db_insert_placeholder_18] => 2 [:db_insert_placeholder_19] => und [:db_insert_placeholder_20] => 271 ) in field_sql_storage_field_storage_write() (line 514 of /modules/field/modules/field_sql_storage/field_sql_storage.module).

The JSON it errors out on is in the zipped file attached

Having deployed from DEV to QA, I thought the deployment from QA to production would be smooth. Being as the content had already been sucessfully deployed. However I've then run into the same type messages again. Just different content.

Any help would be would be greatly appreciated.

CommentFileSizeAuthor
object that errors out.zip2.84 KBgmaximus

Comments

gMaximus created an issue.