Integrity constraint violation: 1048 Column 'library_name' cannot be null: INSERT INTO "h5p_counters"

Created on 14 March 2023, over 2 years ago

Problem/Motivation

Unable to delete one content which has h5p field
when deleting it, gives wsod and this:

Drupal\Core\Database\IntegrityConstraintViolationException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'library_name' cannot be null: INSERT INTO "h5p_counters" ("type", "library_name", "library_version", "num") VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3); Array ( [:db_insert_placeholder_0] => content delete [:db_insert_placeholder_1] => [:db_insert_placeholder_2] => . [:db_insert_placeholder_3] => 1 ) in Drupal\mysql\Driver\Database\mysql\ExceptionHandler->handleExecutionException() (line 50 of /var/www/html/site/web/core/modules/mysql/src/Driver/Database/mysql/ExceptionHandler.php).

Steps to reproduce

Proposed resolution

Remaining tasks

User interface changes

API changes

Data model changes

💬 Support request
Status

Active

Version

2.0

Component

Code

Created by

🇫🇮Finland anaconda777

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

Comments & Activities

  • Issue created by @anaconda777
  • 🇺🇸United States illeace

    I did some light testing using Drupal 11 and the 2.0.0-alpha6 release and I couldn't reproduce the issue. From the error, I expect the problem to have occurred in src/H5PDrupal/H5PEvent.php in the saveStats() function. If this is still happening to you, I'd love to hear more. Maybe there is an extra step or particular interactive type that is required to trigger this?

Production build 0.71.5 2024