IntegrityConstraintViolationException

Created on 22 July 2023, over 1 year ago
Updated 5 April 2024, 8 months ago

Hi There,

After upgrading to 4.1.6 I get error when generating the xml file
I get this error message in my logfile

Drupal\Core\Database\IntegrityConstraintViolationException: SQLSTATE[HY000]: General error: 1364 Field 'id' doesn't have a default value: INSERT INTO "mfzp_simple_sitemap" ("delta", "type", "sitemap_string", "sitemap_created", "status", "link_count") 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] => 1 [:db_insert_placeholder_1] => default [:db_insert_placeholder_2] => <?xml version="1.0" encoding="UTF-8"?> <?xml-stylesheet type="text/xsl" href="/sitemap_generator/default/sitemap.xsl"?>

<!--Generated by the Simple XML Sitemap Drupal module: https://drupal.org/project/simple_sitemap.-->

https://mysite.be/default/sitemap.xml 2023-07-22T13:42:18+02:00 [:db_insert_placeholder_3] => 1690066047 [:db_insert_placeholder_4] => 0 [:db_insert_placeholder_5] => 1 ) in Drupal\mysql\Driver\Database\mysql\ExceptionHandler->handleExecutionException() (line 50 of /data/sites/web/mysite/www/core/modules/mysql/src/Driver/Database/mysql/ExceptionHandler.php).

Please advise

💬 Support request
Status

Fixed

Version

4.1

Component

Code

Created by

🇧🇪Belgium youlikeit

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

Comments & Activities

Production build 0.71.5 2024