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

Public API: updating existing contents generates a "SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry (...)" SQL error

    XMLWordPrintable

    Details

      Description

      If a content in eng-GB is updated using the public API, the following SQL error occurs:

      [PDOException]
      SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1544-3' for key 'PRIMARY'
      

      Steps to reproduce:

      Please adapt the test command attached and run it:

      php ezpublish/console silversolutions:translation --env=dev
      

      It creates content and adds a translation. After this it tries to update the eng-GB object and it leads to the exception.

        Attachments

          Activity

            People

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

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0 minutes
                0m
                Logged:
                Time Spent - 2 hours, 30 minutes
                2h 30m