1. Use Postgres (in my case, I'm using 10.3)
  2. Install Simple Sitemap
  3. Generate or rebuild queue
  4. 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).
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

kdonaldson created an issue. See original summary.

kdonaldson’s picture

  • gbyte.co committed 5299978 on 8.x-3.x
    Issue #3017247 by kdonaldson: Fix Postgres Not Null Violation
    
gbyte’s picture

Status: Active » Fixed

Thanks for reporting this.

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.