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

          Vidar Langseid created issue -
          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.
          André Rømcke made changes -
          Field Original Value New Value
          Workflow eZ Community Workflow [ 21291 ] eZ Engineering Scrumban Workflow [ 35355 ]
          André Rømcke made changes -
          Workflow eZ Engineering Scrumban Workflow [ 35355 ] EZ* Development Workflow [ 68604 ]
          Alex Schuster made changes -
          Workflow EZ* Development Workflow [ 68604 ] EZEE Development Workflow [ 106772 ]

            People

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

              Dates

              • Created:
                Updated: