Contrib.social

Error uninstalling storage field

Open on Drupal.org →
Created on 5 August 2019, almost 6 years ago
Updated 8 August 2023, almost 2 years ago

In the hook update paragraph to remove field, for some reason when calling the uninstallFieldStorageDefinition function it assembles getTableMapping with all revision fields including.

With this, it tries to delete the revision_uid field in the paragraphs_item_field_data table that has the uid field and not revision_uid.

To play:
1- Install the paragraph module version 1.2
2- Update the paragraph module to version 1.8 ( https://www.drupal.org/project/paragraphs → )
3- Turn the updb drush.

Show this error:
Drupal\Core\Database\DatabaseExceptionWrapper: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'revision_uid' in 'where clause': SELECT 1 AS expression FROM {paragraphs_item_field_data} t WHERE revision_uid IS NOT NULL LIMIT 1 OFFSET 0; Array ( ) in Drupal\Core\Entity\Sql\SqlContentEntityStorage->countFieldData() (line 1804 of /var/www/html/web/core/lib/Drupal/Core/Entity/Sql/SqlContentEntityStorage.php).

🐛 Bug report
Status

Postponed: needs info

Version

1.0

Component
Field  →

Last updated about 11 hours ago

Created by

🇧🇷Brazil edmargomes

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.

  • Comment almost 2 years ago →
    🇺🇸United States ja09

    @larowlan Just happened to me when upgrading Drupal core from 9.3 to 9.5. The latest version of Parapgrahs (8.x-1.15) was already installed on 9.3.

    Now I have a "Mismatched entity and/or field definitions" that I can't seem to resolve as I've done in the past. Very frustrating.

  • Comment over 1 year ago →
    🇦🇺Australia larowlan 🇦🇺🏝.au GMT+10
  • Comment 8 months ago →
    🇳🇿New Zealand quietone

    @ja09, were you able to resolve this? If so, what actions did you take?

  • Status changed to Closed: cannot reproduce 2 months ago
  • Comment 2 months ago →
    🇦🇺Australia acbramley

    Closing this for now as it's been over a year with no steps to reproduce.

    Please feel free to reopen with clear steps to reproduce on the latest version of Drupal (and paragraphs if applicable).

contrib.social Blog FAQ Discussions
Production build 0.71.5 2024