I am experiencing an error when Webform Content Creator attempts to create a node. This error does not happen every time, and I have not determined what causes it.
When the error occurs, the following errors are logged. No new node is created.
Webform Content Creator error 1:
A problem occurred when creating a new node.
Webform Content Creator error 2:
SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: '' for column 'tid' at row 1: INSERT INTO @taxonomy_index (nid, tid, status, sticky, created) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4); Array ( [:db_insert_placeholder_0] => 1414 [:db_insert_placeholder_1] => [:db_insert_placeholder_2] => 1 [:db_insert_placeholder_3] => 0 [:db_insert_placeholder_4] => 1582651421 )
Node error:
Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect integer value: '' for column 'tid' at row 1: INSERT INTO {taxonomy_index} (nid, tid, status, sticky, created) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4); Array ( [:db_insert_placeholder_0] => 1393 [:db_insert_placeholder_1] => [:db_insert_placeholder_2] => 1 [:db_insert_placeholder_3] => 0 [:db_insert_placeholder_4] => 1582594562 ) in taxonomy_build_node_index() (line 567 of /srv/bindings/f070a73c19334ad5a1df0d12ec765377/code/core/modules/taxonomy/taxonomy.module).
The transfer of submission data to the datetime field in my content type normally works fine, so If this is the source of the problem, can you advise on the correct configuration to map date fields from submission to node?
I do not know what the "incorrect integer value" refers to.
Thank you for any help you can provide.
Dwight
Fixed
1.5
Code
Not all content is available!
It's likely this issue predates Contrib.social: some issue and comment data are missing.
I was still getting that error while field was not configured well. Fields was reference to some taxonomy, but in WCC settings mapping was configured as "Default". After changing mapping to "Entity reference" it started working well. For the record, issue was appearing inside taxonomy_build_node_index($node) of taxonomy.module. Index entries for all node's terms are created there, but with bad mapping tids are null, so SQL fails.