SQLSTATE[42S02]: Base table or view not found: 1146 Table 'db.notifications' doesn't exist

Created on 7 June 2023, over 1 year ago
Updated 9 June 2023, over 1 year ago

Problem/Motivation

When installing a site with drupal version: 9.5.9 and module version: 2.0.0-alpha4, getting the following error:

The website encountered an unexpected error. Please try again later.
Drupal\Core\Entity\EntityStorageException: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'db.notifications' doesn't exist: SELECT 1 AS "expression" FROM "notifications" "notifications" WHERE "id" = :db_condition_placeholder_0; Array ( [:db_condition_placeholder_0] => ) in Drupal\Core\Entity\Sql\SqlContentEntityStorage->save() (line 815 of core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php).
Drupal\Core\Entity\Sql\SqlContentEntityStorage->save(Object) (Line: 339)
Drupal\Core\Entity\EntityBase->save() (Line: 22)
demo_install()
call_user_func_array(Object, Array) (Line: 417)
Drupal\Core\Extension\ModuleHandler->invoke('demo', 'install', Array) (Line: 357)
Drupal\Core\Extension\ModuleInstaller->install(Array, ) (Line: 83)
Drupal\Core\ProxyClass\Extension\ModuleInstaller->install(Array, ) (Line: 1659)
install_install_profile(Array) (Line: 700)
install_run_task(Array, Array) (Line: 571)
install_run_tasks(Array, NULL) (Line: 119)
install_drupal(Object) (Line: 48)

Steps to reproduce

The server should be running on php 8.1 or higher.

1. Setup drupal site with having version: 9.5.9 and add the notificationswidget as a module of version: 2.0.0-alpha4.
2. Run the drupal site install process.
3. Observe the error the during the installation process.

Proposed resolution

Update from 'length' => 'big', to 'size' => 'big', in notifications_widget_schema() in notifications_widget.install file.

Remaining tasks

Validate the proposed fix.

🐛 Bug report
Status

Fixed

Version

2.0

Component

Code

Created by

🇮🇳India mrinalini9 New Delhi

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

Comments & Activities

Production build 0.71.5 2024