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

invalid input syntax for integer: "" - postgresql 8

    XMLWordPrintable

Details

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Medium Medium
    • None
    • 3.10.1, 4.0.1
    • Database related
    • None
    • Operating System: RHEL5
      PHP Version: (please be specific, like '4.4.3' or '5.1.5') 4.4.8
      Database and version: postgresql 8.3
      Browser (and version):

    Description

      Error: error executing query: SELECT DISTINCT ot.node_id, ot.path_identification_string, oname.name, ca.contentclass_id
      FROM ezcontentobject_tree as ot, ezcontentclass_attribute as ca,
      ezcontentobject_attribute as oa, ezcontentobject_name as oname
      WHERE ot.parent_node_id='' AND ot.contentobject_is_published='1'
      AND oa.language_code='eng-GB' AND oa.sort_key_string='2'
      AND ( ( ca.contentclass_id='25' AND ca.identifier='type' )
      OR ( ca.contentclass_id='6' AND ca.identifier='type' ) ) AND ca.version=0
      AND oname.contentobject_id=ot.contentobject_id AND oname.contentobject_id=ot.contentobject_id
      AND oname.content_version=ot.contentobject_version AND oname.content_translation=oa.language_code
      AND ot.contentobject_id=oa.contentobject_id AND ot.contentobject_version=oa.version
      AND ca.id=oa.contentclassattribute_id
      ORDER BY ot.priority ERROR: invalid input syntax for integer: ""

      Steps to reproduce

      when creating new pages

      Attachments

        Activity

          People

            unknown unknown
            tofik tofik
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: