Base table or view not found: 1146 Table 'db.message' doesn't exist: SELECT "base_table"."mid" AS "mid", "base_table"."mid" AS "base_table_mid" FROM "message" "base_table" GROUP BY base_table.mid LIMIT 1 OFFSET 0; Array ( ) in Drupal\Core\Entity\Query\Sql

Created on 25 October 2021, over 2 years ago
Updated 16 January 2024, 5 months ago

Problem/Motivation

Base table or view not found: 1146 Table 'db.message' doesn't exist: SELECT "base_table"."mid" AS "mid", "base_table"."mid" AS "base_table_mid" FROM "message" "base_table" GROUP BY base_table.mid LIMIT 1 OFFSET 0; Array ( ) in Drupal\Core\Entity\Query\Sql\Query->result() (line 271 of core/lib/Drupal/Core/Entity/Query/Sql/Query.php)

Steps to reproduce

Proposed resolution

Remaining tasks

User interface changes

API changes

Data model changes

💬 Support request
Status

Closed: cannot reproduce

Version

1.0

Component

Code

Created by

🇮🇳India heni_deepak Jaipur, Rajasthan, India

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

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

  • 🇺🇸United States jhedstrom Portland, OR

    Need more details on how this error is triggered...

  • 🇬🇧United Kingdom Problue Solutions Northern Ireland

    Im also getting this error when visiting the Drupal Uninstall page.

    In addition to that, when visiting the Message configuration page I get the following error:

    TypeError: Drupal\message\MessagePurgePluginManager::purgeSettingsForm(): Argument #3 ($purge_settings) must be of type array, null given, called in /web/modules/contrib/message/src/Form/MessageSettingsForm.php on line 104 in Drupal\message\MessagePurgePluginManager->purgeSettingsForm() (line 48 of modules/contrib/message/src/MessagePurgePluginManager.php)

  • 🇫🇷France GuillaumeDuveau Toulouse

    Had to rename Message.php to Message.php.old or something else then clear caches and uninstall this site.

  • 🇮🇳India shashank5563 New Delhi

    Hi Deepak,

    I was facing the same issue after installing message module. This issue was caused by the module not being installed correctly.

    I was added message table in database. After that, I was able to uninstall the module.

    Also, first install the message module and then install the message notify module. You have to install modules one by one.

    --
    -- Table structure for table `message`
    --
    
    CREATE TABLE `message` (
      `mid` int(10) UNSIGNED NOT NULL,
      `template` varchar(32) CHARACTER SET ascii NOT NULL COMMENT 'The ID of the target entity.',
      `uuid` varchar(128) CHARACTER SET ascii NOT NULL,
      `langcode` varchar(12) CHARACTER SET ascii NOT NULL
    ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='The base table for message entities.';
  • Status changed to Closed: cannot reproduce 5 months ago
  • 🇺🇸United States bluegeek9

    I think this was an issue with Message Notify.

Production build 0.69.0 2024