Column 'lastmod' cannot be null

Created on 12 August 2024, 8 months ago
Updated 19 September 2024, 7 months ago

Problem/Motivation

Rebuilging sitemap results in

Drupal\Core\Database\IntegrityConstraintViolationException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'lastmod' cannot be null: INSERT INTO "xmlsitemap" ("type", "id", "language", "loc", "subtype", "access", "status", "status_override", "lastmod", "priority", "priority_override", "changefreq", "changecount") 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); Array ( [:db_insert_placeholder_0] => commerce_store [:db_insert_placeholder_1] => 1 [:db_insert_placeholder_2] => de [:db_insert_placeholder_3] => /store/1 [:db_insert_placeholder_4] => online [:db_insert_placeholder_5] => 0 [:db_insert_placeholder_6] => 1 [:db_insert_placeholder_7] => 0 [:db_insert_placeholder_8] => [:db_insert_placeholder_9] => 0.9 [:db_insert_placeholder_10] => 0 [:db_insert_placeholder_11] => 86400 [:db_insert_placeholder_12] => 0 ) in Drupal\mysql\Driver\Database\mysql\ExceptionHandler->handleExecutionException() (Zeile 45 in /var/www/vhosts/sedumsprossen.com/httpdocs/sedumsprossen.com/www10/core/modules/mysql/src/Driver/Database/mysql/ExceptionHandler.php).

Steps to reproduce

Drupal 10.3.1
xmlsitemap 8.x-1.5+4-dev or 8.x-1.5
php 8.3.10

It is an Upgrade of a commerce site from drupal 9.5

Any advice to find the error?

πŸ› Bug report
Status

Needs review

Version

1.0

Component

xmlsitemap.module

Created by

πŸ‡©πŸ‡ͺGermany umac_de

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

Comments & Activities

Production build 0.71.5 2024