Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
- Use Postgres (in my case, I'm using 10.3)
- Install Simple Sitemap
- Generate or rebuild queue
- You get a "Not Null Violation"
Drupal\Core\Database\IntegrityConstraintViolationException: SQLSTATE[23502]: Not null violation: 7 ERROR: null value in column "created" violates not-null constraint DETAIL: Failing row contains (43, simple_sitemap_elements, a:4:{s:4:"data";a:3:{s:4:"path";s:1:"/";s:8:"priority";s:3:"1.0"..., 0, null).: INSERT INTO queue (name, data, created) VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2); Array ( ) in Drupal\Core\Database\Connection->handleQueryException() (line 683 of /app/drupal-8.6.3/core/lib/Drupal/Core/Database/Connection.php).
Comment | File | Size | Author |
---|---|---|---|
#2 | 3017247-fix-postgres-not-null-violation.patch | 396 bytes | kdonaldson |
Comments
Comment #2
kdonaldson CreditAttribution: kdonaldson as a volunteer commentedComment #4
gbyte CreditAttribution: gbyte as a volunteer and at gbyte commentedThanks for reporting this.