Skip to content

error when importing references

 [error]  Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xC3...#5...' for column `drupal`.`node__reference_endnote_id`.`reference_endnote_id_value` at row 1: INSERT INTO "node__reference_endnote_id" ("entity_id", "revision_id", "bundle", "delta", "langcode", "reference_endnote_id_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); Array
(
    [:db_insert_placeholder_0] => 2838603
    [:db_insert_placeholder_1] => 2838829
    [:db_insert_placeholder_2] => reference
    [:db_insert_placeholder_3] => 0
    [:db_insert_placeholder_4] => en
    [:db_insert_placeholder_5] => Reference to İhsanoğlu, Ekmeleddin. 2000. Osmanlı Coğrafya Literatürü Tarihi [History of Geographical Literature During the Ottoman Period]. İlmi Tarihi Kaynaklar Ve Araştırmalar Serisi. 2 vol. Istanbul: İslâm Tarih Sanat ve Kült�...#563}
)
 in Drupal\Core\Entity\Sql\SqlContentEntityStorage->saveToDedicatedTables() (line 1393 of /var/www/docroot/core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php).

In ExceptionHandler.php line 53:

  SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xC
  3...#5...' for column `drupal`.`migrate_message_node_reference`.`message` a
  t row 1: INSERT INTO "migrate_message_node_reference" ("source_ids_hash", "
  level", "message") VALUES (:db_insert_placeholder_0, :db_insert_placeholder
  _1, :db_insert_placeholder_2); Array
  (
      [:db_insert_placeholder_0] => 1cffbada03aa3fea39222200f05902a764c464d4a
  220c4b83e91634ed17a53cd
      [:db_insert_placeholder_1] => 1
      [:db_insert_placeholder_2] => SQLSTATE[22007]: Invalid datetime format:
   1366 Incorrect string value: '\xC3...#5...' for column `drupal`.`node__ref
  erence_endnote_id`.`reference_endnote_id_value` at row 1: INSERT INTO "node
  __reference_endnote_id" ("entity_id", "revision_id", "bundle", "delta", "la
  ngcode", "reference_endnote_id_value") VALUES (:db_insert_placeholder_0, :d
  b_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3,
   :db_insert_placeholder_4, :db_insert_placeholder_5); Array
  (
      [:db_insert_placeholder_0] => 2838603
      [:db_insert_placeholder_1] => 2838829
      [:db_insert_placeholder_2] => reference
      [:db_insert_placeholder_3] => 0
      [:db_insert_placeholder_4] => en
      [:db_insert_placeholder_5] => Reference to İhsanoğlu, Ekmeleddin. 200
  0. Osmanlı Coğrafya Literatürü Tarihi [History of Geographical Literatu
  re During the Ottoman Period]. İlmi Tarihi Kaynaklar Ve Araştırmalar Ser
  isi. 2 vol. Istanbul: İslâm Tarih Sanat ve Kült�...#563}
  )
   (/var/www/docroot/core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.
  php:815)
  )


In StatementWrapper.php line 145:

  SQLSTATE[22007]: Invalid datetime format: 1366 Incorrect string value: '\xC
  3...#5...' for column `drupal`.`migrate_message_node_reference`.`message` a
  t row 1
To upload designs, you'll need to enable LFS and have an admin enable hashed storage. More information