Community

PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: ''.../modules/field/modules/field_sql_storage/field_

Drupal Commons error after registration submit
involves file : /modules/field/modules/field_sql_storage/field_sql_storage.module

this one has been driving me batty, so I decided to do a free site for a business association I have belonged to in the past, their memberships were dwindling and they needed a good online presense. So drupal commons fit the bill perfectly and I have to say, I love it... well except for this glitch.

I searched the forums as best as I could, for a N00b. I kenna find nutin on it, so does this mean I found a new bug :P
probably not

I am running the proper version of PHP for redhen

this problem happens on Register. Here is the error log

Thanks

Heinz :<)

PDOException: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'field_published_value' at row 1: INSERT INTO {field_data_field_published} (entity_type, entity_id, revision_id, bundle, delta, language, field_published_value) 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] => message [:db_insert_placeholder_1] => 31 [:db_insert_placeholder_2] => 31 [:db_insert_placeholder_3] => example_user_register [:db_insert_placeholder_4] => 0 [:db_insert_placeholder_5] => und [:db_insert_placeholder_6] => ) in field_sql_storage_field_storage_write() (line 448 of .../modules/field/modules/field_sql_storage/field_sql_storage.module).

Comments

Known issue, but not in Drupal Commons

I'm pretty sure your issue comes from issue #1807532. That was it for me at least. See there for the fix, which is for now simply disabling the message_example module.