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

Invalid URL-Alias (ML) data in cleandata.sql

    XMLWordPrintable

Details

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Medium Medium
    • 3.10.1, 4.0.0rc1
    • 3.10.0, 4.0.0beta1
    • Database related
    • None

    Description

      The new table ezurlalias_ml in 3.10 and 4.0 contains an entry in cleandata.sql which lacks its parent entry.

      The cleandata.sql (and share/db_data.dba) file should be fixed by removing all entries in ezurlalias_ml, then re-importing all the old urls and remake the new ones (by using updateniceurls.php).

      Steps to reproduce

      Insert cleandata.sql in a database and do:

      SELECT * FROM ezurlalias_ml WHERE parent = 23;
      

      and then do:

      SELECT * FROM ezurlalias_ml WHERE id = 23;
      

      Alternatively run this to find all missing parents:

      select a1.*, a2.link from ezurlalias_ml a1 left join ezurlalias_ml a2 on a1.parent=a2.id where a1.parent != 0  having a2.link is null;
      

      Attachments

        Activity

          People

            dl dl
            amos amos
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: