Uploaded image for project: 'Ibexa IBX'
  1. Ibexa IBX
  2. IBX-1201

Database error on subtree copy

    XMLWordPrintable

Details

    Description

      Steps to reproduce

      • Create a Tree content with at least 3 items: Landing Page > Folder > Content (like Article)
      • Add translations on contents (at least the folder) with a different name from the original language
      • Try to copy the subtree from the landing page to another place

      Result

      The back-office will display an error: Database error and the log will provide:

      An error has occurred while handling form submission: Database error {"exception":"[object] (Doctrine\\DBAL\\Exception\\UniqueConstraintViolationException(code: 0): An exception occurred while executing 'INSERT INTO `ezurlalias_ml` (parent, text_md5, action, action_type, alias_redirects, id, is_alias, is_original, lang_mask, link, text) VALUES(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' with params [1206, \"2ea2cc83065b83f6136512893ad259b5\", \"eznode:1189\", \"eznode\", \"1\", 1217, \"0\", \"1\", \"11\", 1217, \"larry-parker\"]:\n\nSQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1206-2ea2cc83065b83f6136512893ad259b5' for key 'PRIMARY' at /Users/ibexa/Developer/poc/site-factory/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:74)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1206-2ea2cc83065b83f6136512893ad259b5' for key 'PRIMARY' at /Users/ibexa/Developer/poc/site-factory/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18)\n[previous exception] [object] (PDOException(code: 23000): SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1206-2ea2cc83065b83f6136512893ad259b5' for key 'PRIMARY' at /Users/ibexa/Developer/poc/site-factory/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:117)"

       

      Additional information about steps to reprodue:

      root >landing page > folder (42)> landing page > article
      root > landing page(74)
      bin/console ezplatform:copy-subtree 42 74 => error

      Designs

        Attachments

          Activity

            People

              Unassigned Unassigned
              xavier.dubreuil-obsolete@ibexa.co Xavier Dubreuil (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: