Issue in updating url alias after upgrading Drupal version from 8.7.7 to 8.8.5

Created on 30 April 2020, about 4 years ago
Updated 21 February 2024, 4 months ago

We have upgraded our Drupal application from 8.7.7 to 8.8.5 using composer. After upgrading the application to 8.8.5 we are facing some issues while updating/adding URL alias for taxonamy and contents.

While adding/updating URL alias field we are getting the below error.

Drupal\Core\Entity\EntityStorageException: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'revision_id' cannot be null: INSERT INTO {path_alias} (revision_id, uuid, langcode, path, alias, status) 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)

Also we tried applying the following patch. Still facing the same issue.
https://www.drupal.org/files/issues/2020-02-13/path-alias.patch →

Do we have any other patches available for this issue or How it can be handled?

Any guidance will be grateful!

💬 Support request
Status

Active

Version

1.0

Component

User interface

Created by

🇮🇳India Priya Sundharam Tamilnadu,Chennai

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.

  • 🇧🇷Brazil varod-br São Paulo

    Hi guys!

    I know the issue is old, but recently we upgraded one of our clients from D8.5 to D10.1 and we discovered this problem yesterday.

    One thing I noticed, this is not a Pathauto module issue. This is a path_alias (core) problem.

    I tried to assign a custom path manually, with Pathauto disabled, but the error remains. The only way we can "bypass" this error is not assigning a custom path.

    The solution is really to alter the tables (path_alias and path_alias_revision), directly or with hook update, but I guess that new Drupal installations already have the tables created correctly.

    So, for those that are upgrading their Drupal installations from <8.7, this is a useful issue/thread, even being unrelated to pathauto.

    Thank you all!

Production build 0.69.0 2024