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

Move transaction failing with ezurlalias_ml duplicate key error

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: High
    • Resolution: Cannot Reproduce
    • Affects Version/s: 4.7.0
    • Fix Version/s: Customer request
    • Component/s: Database related
    • Labels:
      None

      Description

      When moving one node with children into another subtree via backend interface or script, the transaction fails with an error:

      UPDATE ezurlalias_ml SET parent = 706010 WHERE parent = 706472 AND (cast(lang_mask & 2 AS SIGNED )  > 0);
      ERROR 1062 (23000): Duplicate entry '706010-965a37fc6b40431ea9aab2401d901332' for key 'PRIMARY'
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned Unassigned
              Reporter:
              nuno.oliveira-obsolete@ez.no Nuno Oliveira (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 0 minutes
                  0m
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 2 days, 6 hours, 20 minutes
                  2d 6h 20m