General error: 1366 Incorrect integer value

Interestingly, when I remove the "http://" (from the iframe url string) the 1366 error is no longer thrown -- however -- the new content type is not published and instead reports the error condition "The value should be of the correct primitive type" as shown in the link to the screenshot below...

http://www.stonetonwestllc.com/sites/default/files/iframe-screenshot01.jpg

However: add the "http://" back in and clicking on the "Preview" button shows the specified iframe embedded as desired in the new content type. But executing "Submit" still fails with the 1366 error.

My apologies. I reset this to active. I've installed the 8.x-1.3 2016-Mar-15 release and it appears that I'm having the same issue as I described in #1.

1) Created new content
2) Assigned a title and a Lorem Ipsum body
3) Enter a url in the iframe field
4) Entered a height and width
5) Pressed "Save and Publish" and the 1366 error was thrown...

The website encountered an unexpected error. Please try again later.

Drupal\Core\Entity\EntityStorageException: SQLSTATE[HY000]: General error: 1366 Incorrect integer value: '' for column 'field_iframe_frameborder' at row 1: INSERT INTO {node__field_iframe} (entity_id, revision_id, bundle, delta, langcode, field_iframe_url, field_iframe_title, field_iframe_class, field_iframe_width, field_iframe_height, field_iframe_frameborder, field_iframe_scrolling, field_iframe_transparency, field_iframe_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); Array ( [:db_insert_placeholder_0] => 168 [:db_insert_placeholder_1] => 168 [:db_insert_placeholder_2] => page [:db_insert_placeholder_3] => 0 [:db_insert_placeholder_4] => en [:db_insert_placeholder_5] => http://www.avatar-moving.com/rmtestimate.asp [:db_insert_placeholder_6] => [:db_insert_placeholder_7] => [:db_insert_placeholder_8] => 800 [:db_insert_placeholder_9] => 800 [:db_insert_placeholder_10] => [:db_insert_placeholder_11] => [:db_insert_placeholder_12] => [:db_insert_placeholder_13] => ) in Drupal\Core\Entity\Sql\SqlContentEntityStorage->save() (line 757 of core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php).

Drupal\Core\Database\Statement->execute(Array, Array) (Line: 615)
Drupal\Core\Database\Connection->query('INSERT INTO {node__field_iframe} (entity_id, revision_id, bundle, delta, langcode, field_iframe_url, field_iframe_title, field_iframe_class, field_iframe_width, field_iframe_height, field_iframe_frameborder, field_iframe_scrolling, field_iframe_transparency, field_iframe_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)', Array, Array) (Line: 86)
Drupal\Core\Database\Driver\mysql\Connection->query('INSERT INTO {node__field_iframe} (entity_id, revision_id, bundle, delta, langcode, field_iframe_url, field_iframe_title, field_iframe_class, field_iframe_width, field_iframe_height, field_iframe_frameborder, field_iframe_scrolling, field_iframe_transparency, field_iframe_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)', Array, Array) (Line: 37)
Drupal\Core\Database\Driver\mysql\Insert->execute() (Line: 1265)
Drupal\Core\Entity\Sql\SqlContentEntityStorage->saveToDedicatedTables(Object, , Array) (Line: 853)
Drupal\Core\Entity\Sql\SqlContentEntityStorage->doSaveFieldItems(Object) (Line: 268)
Drupal\Core\Entity\ContentEntityStorageBase->doSave(NULL, Object) (Line: 397)
Drupal\Core\Entity\EntityStorageBase->save(Object) (Line: 748)
Drupal\Core\Entity\Sql\SqlContentEntityStorage->save(Object) (Line: 363)
Drupal\Core\Entity\Entity->save() (Line: 361)
Drupal\node\NodeForm->save(Array, Object)
call_user_func_array(Array, Array) (Line: 116)
Drupal\Core\Form\FormSubmitter->executeSubmitHandlers(Array, Object) (Line: 56)
Drupal\Core\Form\FormSubmitter->doSubmitForm(Array, Object) (Line: 588)
Drupal\Core\Form\FormBuilder->processForm('node_page_form', Array, Object) (Line: 319)
Drupal\Core\Form\FormBuilder->buildForm(Object, Object) (Line: 53)
Drupal\Core\Entity\EntityFormBuilder->getForm(Object) (Line: 118)
Drupal\node\Controller\NodeController->add(Object)
call_user_func_array(Array, Array) (Line: 128)
Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->Drupal\Core\EventSubscriber\{closure}() (Line: 577)
Drupal\Core\Render\Renderer->executeInRenderContext(Object, Object) (Line: 129)
Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->wrapControllerExecutionInRenderContext(Array, Array) (Line: 102)
Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->Drupal\Core\EventSubscriber\{closure}()
call_user_func_array(Object, Array) (Line: 139)
Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object, 1) (Line: 62)
Symfony\Component\HttpKernel\HttpKernel->handle(Object, 1, 1) (Line: 62)
Drupal\Core\StackMiddleware\Session->handle(Object, 1, 1) (Line: 53)
Drupal\Core\StackMiddleware\KernelPreHandle->handle(Object, 1, 1) (Line: 103)
Drupal\page_cache\StackMiddleware\PageCache->pass(Object, 1, 1) (Line: 82)
Drupal\page_cache\StackMiddleware\PageCache->handle(Object, 1, 1) (Line: 51)
Drupal\Core\StackMiddleware\ReverseProxyMiddleware->handle(Object, 1, 1) (Line: 55)
Drupal\Core\StackMiddleware\NegotiationMiddleware->handle(Object, 1, 1) (Line: 23)
Stack\StackedHttpKernel->handle(Object, 1, 1) (Line: 637)
Drupal\Core\DrupalKernel->handle(Object) (Line: 19)

As reported in #2, alternatively pressing the "Preview" button results in my content (with the correct URL in the iframe) displaying correctly.

For me, it appears that the 1.3 release exhibits the same 1366 issue as was originally reported.

And by the way, thank you very much for your work. I really need this module to work.

Here's an update: I have managed to get the new content (with the specified iframe URL) to save successfully.

However, it is difficult for me to pinpoint the exact steps I took to make this happen because I changed many of the settings in Home > Administration > Structure > Content types > Page ("Manage fields", "Manage form display" and "Manage display").

I BELIEVE that what may have allowed the new content to be saved was editing the "Manage Form Display" Cog and setting 800px values for both the "width of an iframe" and the "height of an iframe."

I notice now that both of these fields are marked with a red "*" which means they are required (?). Previously I had not set a value for the fields (I had left each field empty).

I really hope this helps. Sorry I can provide more explicit steps to reproduce.

Thanks again neffets.