Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'database.tmp_2d4eecgroup_r__e3b0c44298

Created on 9 October 2024, 2 months ago

Problem/Motivation

I updated the group module from 1.2 to 1.6 during the opgino upgrade from 3.1.0 to 3.2.7 and got the below error. Any idea?

>  [notice] Update started: group_post_update_make_group_revisionable
>  [error]  Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'database.tmp_2d4eecgroup_r__e3b0c44298' doesn't exist: INSERT INTO "tmp_2d4eecgroup_r__e3b0c44298" ("entity_id", "revision_id", "bundle", "delta", "langcode", "field_learning_path_duration_target_id") 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); Array
> (
>     [:db_insert_placeholder_0] => 67
>     [:db_insert_placeholder_1] => 67
>     [:db_insert_placeholder_2] => learning_path
>     [:db_insert_placeholder_3] => 0
>     [:db_insert_placeholder_4] => de
>     [:db_insert_placeholder_5] => 630
> )
>  in Drupal\Core\Entity\Sql\SqlContentEntityStorage->saveToDedicatedTables() (line 1403 of C:\xampp\htdocs\opigno-composer\web\core\lib\Drupal\Core\Entity\Sql\SqlContentEntityStorage.php).
>  [error]  The entity update process failed while processing the entity type group, ID: 67.
>  [error]  Update failed: group_post_update_make_group_revisionable

Note: Using Drupal 10.3.6

🐛 Bug report
Status

Active

Version

3.2

Component

Code

Created by

🇮🇳India kanchamk

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

Comments & Activities

  • Issue created by @kanchamk
  • 🇮🇳India kanchamk

    I was able to resolve this issue by doing the following:

    • Go to /admin/group/types/manage/learning_path/fields
    • "Edit" every field and click on "Save" to update the field
    • Run drush updb again and this error resolved.
Production build 0.71.5 2024