Update 9203 : 'plugin_id' not found in Drupal\Core\Entity\Query\Sql\Tables->ensureEntityTable()

Created on 29 July 2024, 4 months ago
Updated 20 August 2024, 3 months ago

Problem/Motivation

To migrate module group from 8.x-1.6 to ^2..2

Steps to reproduce

Having updated module group to version 2 and updated related following modules, on Drupal 10.3.1,
...
"drupal/ginvite": "^3.0@beta",
"drupal/grequest": "^2.2",
"drupal/group": "^2.2",
"drupal/group_content_menu": "^2.0",
"drupal/group_permissions": "^2.0-alpha",
"drupal/group_permissions_template": "^1.0@alpha"
...

Updating the database by

> drush updatedb

leads to

> [notice] Update started: group_update_9200
> [notice] Update completed: group_update_9200
> [notice] Update started: group_update_9201
> [notice] Update completed: group_update_9201
> [notice] Update started: group_update_9202
> [notice] Update completed: group_update_9202
> [notice] Update started: group_update_9203
> [error] 'plugin_id' not found
> [error] Update failed: group_update_9203
[error] Update aborted by: group_update_9203
[error] Finished performing updates.

or by /update.php

Update #9203

Failed: Drupal\Core\Entity\Query\QueryException: 'plugin_id' not found in Drupal\Core\Entity\Query\Sql\Tables->ensureEntityTable() (line 369 of /home/xd/Docks/web/core/lib/Drupal/Core/Entity/Query/Sql/Tables.php).

Drupal is complaining about the missing field "plugin_id" which must be added by the update.

Proposed resolution

Remaining tasks

User interface changes

API changes

Data model changes

🐛 Bug report
Status

Closed: duplicate

Version

2.2

Component

Code

Created by

🇧🇪Belgium xdequinze Brussels

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

Comments & Activities

  • Issue created by @xdequinze
  • 🇧🇪Belgium xdequinze Brussels
  • 🇧🇪Belgium xdequinze Brussels
  • 🇧🇪Belgium xdequinze Brussels
  • 🇵🇰Pakistan isalmanhaider

    I'm experiencing the same
    while updrading group 1.5/6 to 2.2 on drupal 9.5.11

    Drupal\Core\Entity\Query\QueryException: 'plugin_id' not found in Drupal\Core\Entity\Query\Sql\Tables->ensureEntityTable() (line 369 of /var/www/html/docroot/core/lib/Drupal/Core/Entity/Query/Sql/Tables.php)
    
    [notice] Update started: group_update_9203
    >  [error]  Drupal\Core\Database\IntegrityConstraintViolationException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'uid' cannot be null: INSERT INTO "tmp_00d0a9group_relationship_field_data" ("id", "type", "langcode", "uid", "gid", "entity_id", "label", "created", "changed", "default_langcode", "plugin_id", "group_type") 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, :db_insert_placeholder_6, :db_insert_placeholder_7, :db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10, :db_insert_placeholder_11); Array
    > (
    >     [:db_insert_placeholder_0] => 292921
    >     [:db_insert_placeholder_1] => client-group_membership
    >     [:db_insert_placeholder_2] => en
    >     [:db_insert_placeholder_3] =>
    >     [:db_insert_placeholder_4] =>
    >     [:db_insert_placeholder_5] =>
    >     [:db_insert_placeholder_6] =>
    >     [:db_insert_placeholder_7] =>
    >     [:db_insert_placeholder_8] =>
    >     [:db_insert_placeholder_9] =>
    >     [:db_insert_placeholder_10] => group_membership
    >     [:db_insert_placeholder_11] => client
    > )
    >  in Drupal\mysql\Driver\Database\mysql\ExceptionHandler->handleExecutionException() (line 50 of /var/www/html/docroot/core/modules/mysql/src/Driver/Database/mysql/ExceptionHandler.php).
    >  [error]  The entity update process failed while processing the entity type group_content, ID: 292921.
    >  [error]  Update failed: group_update_9203
     [error]  Update aborted by: group_update_9203
     [error]  Finished performing updates.
  • 🇬🇧United Kingdom unqunq

    Might be related to this: https://www.drupal.org/project/group/issues/3363130 🐛 Database update errors when upgrading from 1.5 to 2.1 pluginid not found Active

    I think this is the history of when the update has been created https://www.drupal.org/project/group/issues/3278778

  • Status changed to Closed: duplicate 3 months ago
  • 🇧🇪Belgium kristiaanvandeneynde Antwerp, Belgium

    This definitely seems like a duplicate of 🐛 Database update errors when upgrading from 1.5 to 2.1 pluginid not found Active

    Thanks @unqunq!

Production build 0.71.5 2024