PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'field_video_url_frameborder' cannot be null

I think before a save happens, the default settings array needs to be merged with the element from the field. I don't have time to fix it ATM, I'll try to take a look tomorrow.

fixes #2206037 - module restructured, now module uses _presave function to fill in missing (but yet pre-defined) attributes for each instance-entity of iframe, preventing the PDOException about missing frameborder-attribute

Fixed in dev

I Know this is closed, however I have installed 7.x-1.1 on 7.28 and i am getting this error when trying to save an iframe.

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'field_iframe_frameborder' cannot be null: INSERT INTO {field_data_field_iframe} (entity_type, entity_id, revision_id, bundle, delta, language, field_iframe_url, field_iframe_title, field_iframe_class, field_iframe_width, field_iframe_height, field_iframe_frameborder, field_iframe_scrolling, field_iframe_transparency) 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); Array ( [:db_insert_placeholder_0] => node [:db_insert_placeholder_1] => 3 [:db_insert_placeholder_2] => 3 [:db_insert_placeholder_3] => page [:db_insert_placeholder_4] => 0 [:db_insert_placeholder_5] => und [:db_insert_placeholder_6] => http://www.majorscreek.org.au/weather/wconsole/wconsole.html [:db_insert_placeholder_7] => [:db_insert_placeholder_8] => [:db_insert_placeholder_9] => 100% [:db_insert_placeholder_10] => 700 [:db_insert_placeholder_11] => [:db_insert_placeholder_12] => [:db_insert_placeholder_13] => ) in field_sql_storage_field_storage_write() (line 451 of /usr/home/majorscreek/www1.majorscreek.org.au/html/modules/field/modules/field_sql_storage/field_sql_storage.module).

Thanks

I received the same error gordon.waters with a 7.x-1.1 install on 7.29. I removed it and installed 7.x-1.x-dev and I no longer get the error. Maybe the fix in dev was not merged. I am using this on a small site hoping that dev is stable.

I get the same issue when using Feeds to import new content with an Iframe present (I have a default value for the IFrame set, so that it can reference the text that I import with Feeds into other fields. Separate issue that IFrame fields are not exposed to Rules or Feeds)

PDOException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'field_essay_1_gd_frameborder' cannot be null: INSERT INTO {field_data_field_essay_1_gd} (entity_type, entity_id, revision_id, bundle, delta, language, field_essay_1_gd_url, field_essay_1_gd_title, field_essay_1_gd_class, field_essay_1_gd_width, field_essay_1_gd_height, field_essay_1_gd_frameborder, field_essay_1_gd_scrolling, field_essay_1_gd_transparency, field_essay_1_gd_tokensupport) 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); Array ( [:db_insert_placeholder_0] => node [:db_insert_placeholder_1] => 52533 [:db_insert_placeholder_2] => 52533 [:db_insert_placeholder_3] => 2018_student_application_part_2_ [:db_insert_placeholder_4] => 0 [:db_insert_placeholder_5] => und [:db_insert_placeholder_6] => [node:field_essay_1_url] [: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] => ) in field_sql_storage_field_storage_write() (line 514 of /var/www/vhosts/[...]/modules/field/modules/field_sql_storage/field_sql_storage.module).

Note: Using:
Drupal 7.56
Feeds 7.x-2.0-beta4
IFrame 7.x-1.8

Confirmed error persists on Dev version of IFrame. When removing the default value from the IFrame field, upload works properly on Feeds. With default value in tact, normal save works properly.

SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'field_leadgen_frameborder' cannot be null

I also got this error when trying to use Feeds and SOAP Web Services to update a content type that uses a non-required iframe field with a default value. The import worked when I removed the default iframe. Of course this is a bummer cause now I have to figure out how to bulk re-add the default to all the imported nodes.

Thanks @graysoonecooper, I never would have thought to remove the default.

the @tboggia mentioned issue can be fixed by mapping data into the iframe field, as that functionality was added last year in august. See https://www.drupal.org/project/iframe/issues/2775109 for more info.

added "related issue" url