- π·πΊRussia znaeff
On one of my web sites, I'm getting the following error once a day:
Drupal\Core\Database\IntegrityConstraintViolationException: SQLSTATE[23502]: Not null violation: 7 ERROR: null value in column "id" of relation "cleantalk_sfw_temp" violates not-null constraint DETAIL: Failing row contains (null, 168430090, 4294967295, 0, 0).: INSERT INTO cleantalk_sfw_temp (network, mask, status, source) VALUES (168430090,4294967295,0,0),(1851333120,4294966784,0,0),(1964701696,4294966784,0,0),(463067136,4294966272,0,0),(462875648,4294966272,0,0),(532213248,4294967040,0,0),(3301187584,4294967040,0,0),(3729646592,4294966784,0,0),(2015483904,4294966784,0,0),(463458304,4294966272,0,0),(2043539456,4294966272,0,0),
... long list of other values
(1737180234,4294967295,0,0),(1737180300,4294967295,0,0),(1737180419,4294967295,0,0),(1737203382,4294967295,0,0),(1737274667,4294967295,0,0),(1737284414,4294967295,0,0),(1737284505,4294967295,0,0),(1737362361,4294967295,0,0),(1737366167,4294967295,0,0),(1737444616,4294967295,0,0),(1737444687,4294967295,0,0); Array ( ) in Drupal\Core\Database\ExceptionHandler->handleExecutionException() (line 77 of /home/accdesign/public_html/web/core/lib/Drupal/Core/Database/ExceptionHandler.php)
I note that table cleantalk_sfw_temp has a column named id (which is not a serial field), which is not written to by the INSERT statement. Note that the very first set of values is what it dies on. Note that SFW is turned off in Cleantalk configuration.
Active
9.1
Code
Not all content is available!
It's likely this issue predates Contrib.social: some issue and comment data are missing.