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

Error: eZPostgreSQLDB when adding a new Section

    XMLWordPrintable

    Details

      Description

      When creating a new section, while running eZ Publish with a Postgres database, the debug returns the following

      Warning: PHP: E_WARNING

      pg_query(): Query failed: ERROR: invalid input syntax for integer: ""
      LINE 2: ...ezsection WHERE identifier='find_test' AND id != '' ORDER B...
      ^ in /var/www/ezp/.run/lib/ezdb/classes/ezpostgresqldb.php on line 197

      Error: eZPostgreSQLDB

      Error: error executing query: SELECT id, name, navigation_part_identifier, locale, identifier
      FROM ezsection WHERE identifier='find_test' AND id != '' ORDER BY name ASC: ERROR: invalid input syntax for integer: ""
      LINE 2: ...ezsection WHERE identifier='find_test' AND id != '' ORDER B...
      ^

      this only happens if the first try fails.

      Steps to reproduce
      Setup - Add section
      
      1. Log in as admin in admin interface
      2. Click "Setup" in top menu
      3. Click "Sections" in left menu
      4. Click "New section" button
      Name : Find test
      
      5. Click "OK" button
      6. Verify it throws an error "Identifier can not be empty"
      7. Type the following:
      Name: Find test
      Identifier: find_test
      
      8. Press "ok" button
      

        Attachments

          Activity

            People

            • Assignee:
              ls Ɓukasz Serwatka
              Reporter:
              pedro.resende Pedro Resende
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: