Contrib.social

aggregator entry missing in database

Open on Drupal.org →
Created on 20 September 2024, about 2 months ago

I tried to install this module to replace the deprecated version in a D9 installation.

I uninstalled the deprecated core version and installed this contrib module using composer. I didn't specify a version expecting composer to install the best version for my D9 but it installed 2.2 which is not compatible with D9.

I then used composer to remove it and installed version 1.4 but then the site went down after I enabled it. I then used drush to uninstall and composer to remove it and that restored the site.

However, the problem I have now is a missing entry for Aggregator in the database but the site shows the deprecated version as being installed. The result is an error when I try to access the /modules/uninstall URL:

The website encountered an unexpected error. Please try again later.
Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'careersportal_new.aggregator_feed' doesn't exist: SELECT "base_table"."fid" AS "fid", "base_table"."fid" AS "base_table_fid" FROM "aggregator_feed" "base_table" LIMIT 1 OFFSET 0; Array ( ) in Drupal\Core\Entity\Query\Sql\Query->result() (line 272 of core/lib/Drupal/Core/Entity/Query/Sql/Query.php).

How can I add an entry for aggregator back to the database so that I can uninstall it via the UI or Drush?

💬 Support request
Status

Fixed

Version

1.1

Component

Code

Created by

🇿🇦South Africa nravens

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

Comments & Activities

  • Issue created by @nravens
  • Comment about 2 months ago →
    🇿🇦South Africa nravens

    Can I simply go to phpMyAdmin then open the database that's missing the table for "aggregator_feed"

    Then click on Operations and under "Create new table" under "Table Name" add "aggregator_feed" and create?

    Then from there, will I be able to uninstall the aggregator module (core version)?

  • Comment about 2 months ago →
    🇿🇦South Africa nravens

    I tested it and it worked for me. I created the database table for aggregator_feed and also aggregator_item

    This resulted in the modules/uninstall url to load and allowed me to uninstall the aggregator module, this time successfully.

  • Status changed to Fixed about 2 months ago
  • Comment about 2 months ago →
    🇿🇦South Africa nravens
  • Comment about 2 months ago →
    🇦🇺Australia larowlan 🇦🇺🏝.au GMT+10

    Hi, sounds like you've sorted this
    For those finding this later - do not - uninstall the module to move from core to contrib version

    Just composer require the contrib version on D9 and happy days, seamless update - Drupal is smart enough to use the contrib version over the core one

  • Comment about 1 month ago →
    System Message

    Automatically closed - issue fixed for 2 weeks with no activity.

contrib.social Blog FAQ Discussions
Production build 0.71.5 2024