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

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

    XMLWordPrintable

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 )

      Attachments

        Activity

          People

            Unassigned Unassigned
            vl vl
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: