Uploaded image for project: 'eZ Publish / Platform'
  1. eZ Publish / Platform
  2. EZP-30014

Moving Location corrupts URLAlias database entries

Details

    Description

      Moving Location of a Content that was previously renamed results in corrupted database entries (most probably it's the root cause of https://jira.ez.no/browse/EZP-30004 )

      Steps to reproduce:
      1. Login as admin
      2. Create a folder named "folder"
      3. Rename it to "folder2"
      4. Check the entries in ezurlalias_ml table, it should look similar to:

      +-----------+-------------+-----------------+----+----------+-------------+-----------+------+--------+---------+----------------------------------+
      | action    | action_type | alias_redirects | id | is_alias | is_original | lang_mask | link | parent | text    | text_md5                         |
      +-----------+-------------+-----------------+----+----------+-------------+-----------+------+--------+---------+----------------------------------+
      | eznode:54 | eznode      |               0 | 38 |        0 |           1 |         3 |   38 |      0 | folder2 | 4d98c940d9697757a80c7ce73e09a69b |
      | eznode:54 | eznode      |               0 | 39 |        0 |           0 |         3 |   38 |      0 | folder  | 851148b4fd8fd7ae74bd9100c5c0c898 |
      +-----------+-------------+-----------------+----+----------+-------------+-----------+------+--------+---------+----------------------------------+
      

      5. Move the folder to another location (Media)
      6. Check the database entries again

      Result:

      +-----------+-------------+-----------------+----+----------+-------------+-----------+------+--------+---------+----------------------------------+
      | action    | action_type | alias_redirects | id | is_alias | is_original | lang_mask | link | parent | text    | text_md5                         |
      +-----------+-------------+-----------------+----+----------+-------------+-----------+------+--------+---------+----------------------------------+
      | eznode:54 | eznode      |               0 | 39 |        0 |           0 |         3 |   38 |      0 | folder  | 851148b4fd8fd7ae74bd9100c5c0c898 |
      | eznode:54 | eznode      |               0 | 40 |        0 |           1 |         3 |   40 |      9 | folder2 | 4d98c940d9697757a80c7ce73e09a69b |
      | eznode:54 | eznode      |               0 | 41 |        0 |           0 |         3 |   40 |      0 | folder2 | 4d98c940d9697757a80c7ce73e09a69b |
      +-----------+-------------+-----------------+----+----------+-------------+-----------+------+--------+---------+----------------------------------+
      

      The link value for in the first row is equal to 38 - there is no entry in ezurlalias_ml with that ID. The data is corrupted. Link value should be equal to 40 - ID of the ezurlalias_ml row for that Content with is_original = 1.

      Attachments

        Activity

          People

            Unassigned Unassigned
            marek.nocon@ibexa.co Marek NocoĊ„
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated: