Rebuilding checksums broken with Integrity constraint violation: 1048 Column 'default_langcode' cannot be null

Created on 4 April 2023, about 2 years ago
Updated 26 February 2024, about 1 year ago

Problem/Motivation

Rebuilding checksums leads to:
Drupal\Core\Entity\EntityStorageException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'default_langcode' cannot be null: INSERT INTO "wd_media_field_data" ("mid", "vid", "bundle", "langcode", "status", "uid", "name", "thumbnail__target_id", "thumbnail__alt", "thumbnail__title", "thumbnail__width", "thumbnail__height", "created", "changed", "default_langcode", "revision_translation_affected", "content_translation_source", "content_translation_outdated", "duplicates_checksum") 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, :db_insert_placeholder_15, :db_insert_placeholder_16, :db_insert_placeholder_17, :db_insert_placeholder_18); Array ( [:db_insert_placeholder_0] => 489 [:db_insert_placeholder_1] => 489 [:db_insert_placeholder_2] => slide [:db_insert_placeholder_3] => en [:db_insert_placeholder_4] => [:db_insert_placeholder_5] => 0 [:db_insert_placeholder_6] => generateImage_AhcIzb.gif [:db_insert_placeholder_7] => 702 [:db_insert_placeholder_8] => Comis luctus nutus occuro quibus suscipere tamen veniam vindico. [:db_insert_placeholder_9] => [:db_insert_placeholder_10] => 3287 [:db_insert_placeholder_11] => 1280 [:db_insert_placeholder_12] => [:db_insert_placeholder_13] => [:db_insert_placeholder_14] => [:db_insert_placeholder_15] => 1 [:db_insert_placeholder_16] => [:db_insert_placeholder_17] => [:db_insert_placeholder_18] => iqWeEOmxAds5g1fbJ9vZzoZW44bNYLWddukt6Sol-lE ) in Drupal\Core\Entity\Sql\SqlContentEntityStorage->save() (Zeile 815 in /web/core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php).

I guess the reason is within one of the media files, but that shouldn't break rebuilding checksums.
Instead the iteration should be skipped and an error should be logged.

Steps to reproduce

Proposed resolution

Remaining tasks

User interface changes

API changes

Data model changes

🐛 Bug report
Status

Active

Version

2.0

Component

Code

Created by

🇩🇪Germany Anybody Porta Westfalica

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Production build 0.71.5 2024