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

          Transition Time In Source Status Execution Times Last Executer Last Execution Date
          Open Open Closed Closed
          2690d 20h 26m 1 Andrzej Longosz 17/Jun/19 11:58 AM

            People

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

              Dates

              • Created:
                Updated:
                Resolved: