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

ezsurvey wizard generate SQL error on /content/browse on postgres

    Details

      Description

      During the ezsurvey wizard, at the step where you are asked to "Select the parent folder for the survey attributes" and you click "Browse" button you get this error:

      Warning: PHP: E_WARNING 	Feb 03 2012 13:13:56
      pg_query(): Query failed: ERROR:  invalid input syntax for integer: ""
      LINE 2: ...    FROM   ezcontentobject_version WHERE  version='' AND con...
                                                                   ^ in /var/www/ezp/.run/lib/ezdb/classes/ezpostgresqldb.php on line 202
       
      Error: eZPostgreSQLDB 	Feb 03 2012 13:13:56
      Error: error executing query: SELECT id, contentobject_id, creator_id, version, status, created, modified,       workflow_event_pos, user_id, language_mask, initial_language_id
                          FROM   ezcontentobject_version WHERE  version='' AND contentobject_id='' ORDER BY version ASC: ERROR:  invalid input syntax for integer: ""
      LINE 2: ...    FROM   ezcontentobject_version WHERE  version='' AND con...
                                                                   ^
      

      Despite the error, everything seems to run fine ( including submitting a survey after the wizard has completed ). And since the error occurs in /content/browse, i doubt it is actually related to ezsurvey.
      However, I am unable to reproduce the problem by for instance moving a node ( /content/browse then seems to work without any sql error )

        Issue Links

          Activity

          Hide
          Vidar Langseid added a comment -

          !issue_19108_the_wizard_step_that_causes_the_error.png|thumbnail! The wizard step that results in a SQL error

          Show
          Vidar Langseid added a comment - !issue_19108_the_wizard_step_that_causes_the_error.png|thumbnail! The wizard step that results in a SQL error
          Hide
          Vidar Langseid added a comment -

          !issue_19108_postgres_sql_error.png|thumbnail! the SQL error

          Show
          Vidar Langseid added a comment - !issue_19108_postgres_sql_error.png|thumbnail! the SQL error
          Hide
          Vidar Langseid added a comment -

          All automated ezsurey tests fail due to this problem.

          Show
          Vidar Langseid added a comment - All automated ezsurey tests fail due to this problem.
          Hide
          Andrzej Longosz added a comment -

          This issue is related to eZ Publish and/or its extension(s) which is past EOM now. Closing.

          Show
          Andrzej Longosz added a comment - This issue is related to eZ Publish and/or its extension(s) which is past EOM now. Closing.

            People

            • Assignee:
              Unassigned
              Reporter:
              Vidar Langseid
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: