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

Deleting a draft blocks the content type update

    XMLWordPrintable

Details

    Description

      Steps to reproduce

      1. Install clean Ibexa DXP 3.3
      2. Create Article and exit using a cross on the left corner
      3. Go to User -> drafts from the menu on the right corner
      4. Remove draft
      5. Go do Content Type -> Article
      6. Add a new  field
      7. Save CT

       

      Result

      Got popup with "Database error" message and in logs, you can find:

      [2021-08-31T12:36:44.657160+00:00] app.ERROR: An error has occurred while handling form submission: Database error {"exception":"[object] (Doctrine\\DBAL\\Exception\\SyntaxErrorException(code: 0): An exception occurred while executing 'SELECT contentobject_id AS ezcontentobject_name_contentobject_id, content_version AS ezcontentobject_name_content_version, name AS ezcontentobject_name_name, content_translation AS ezcontentobject_name_content_translation FROM ezcontentobject_name WHERE ()':\n\nSQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near \")\"\nLINE 1: ..._name_content_translation FROM ezcontentobject_name WHERE ()\n ^ at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractPostgreSQLDriver.php:73)\n[previous exception] [object] (Doctrine\\DBAL\\Driver\\PDO\\Exception(code: 42601): SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near \")\"\nLINE 1: ..._name_content_translation FROM ezcontentobject_name WHERE ()\n ^ at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDO/Exception.php:18)\n[previous exception] [object] (PDOException(code: 42601): SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near \")\"\nLINE 1: ..._name_content_translation FROM ezcontentobject_name WHERE ()\n ^ at /var/www/html/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:132)"} []
      

       

      Expected result

      After delete the draft should be can update the Content Type without an error

      Designs

        Attachments

          Activity

            People

              Unassigned Unassigned
              mateusz.debinski@ibexa.co Mateusz Dębiński
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: