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

Applying Service Pack EZSP-015-EZP4.7 on eZ with oracle will crash displaying content nodes - sql error

    Details

      Description

      After applying the latest service Pack:
      https://support.ez.no/Maintenance/Service-Packs/eZ-Publish-Enterprise-4.7/EZSP-015-EZP4.7

      eZ Publish installation on oracle will not work correctly.

      After applying the patch the site will not show any content nodes in the backend.
      The following sql error is shown. (see attached error.log for more)

      [ Nov 10 2014 16:00:01 ] [192.168.2.98] eZOracleDB:
      Error (905): ORA-00905: missing keyword
      Failed query at offset 648:
      SELECT ezcontentobject.*,
                                   ezcontentobject_tree.*,
                                   ezcontentclass.serialized_name_list as class_serialized_name_list,
                                   ezcontentclass.identifier as class_identifier,
                                   ezcontentclass.is_container as is_container
                                   , ezcontentobject_name.name as name,  ezcontentobject_name.real_translation 
                            FROM ezcontentobject_tree,
                                 ezcontentobject,
                                 ezcontentclass
                                  INNER JOIN ezcontentobject_name 
                            WHERE  node_id = 1 and 
                                  ezcontentobject_tree.contentobject_id=ezcontentobject.id  AND
                                  ezcontentclass.version=0 AND
                                  ezcontentclass.id = ezcontentobject.contentclass_id
                                   AND  ezcontentobject_tree.contentobject_id = ezcontentobject_name.contentobject_id and
                                         ezcontentobject_tree.contentobject_version = ezcontentobject_name.content_version and 
       ( bitand( ezcontentobject_name.language_id, ezcontentobject.language_mask ) > 0 AND
       bitand( ezcontentobject.language_mask - bitand( ezcontentobject.language_mask, ezcontentobject_name.language_id ), 1 )
         + bitand( ezcontentobject.language_mask - bitand( ezcontentobject.language_mask, ezcontentobject_name.language_id ), 16 ) / 8   + bitand( ezcontentobject.language_mask - bitand( ezcontentobject.language_mask, ezcontentobject_name.language_id ), 8 ) / 2   + bitand( ezcontentobject.language_mask - bitand( ezcontentobject.language_mask, ezcontentobject_name.language_id ), 4 ) * 2   + bitand( ezcontentobject.language_mask - bitand( ezcontentobject.language_mask, ezcontentobject_name.language_id ), 2 ) * 8   <
         bitand( ezcontentobject_name.language_id, 1 )
         + bitand( ezcontentobject_name.language_id, 16 ) / 8   + bitand( ezcontentobject_name.language_id, 8 ) / 2   + bitand( ezcontentobject_name.language_id, 4 ) * 2   + bitand( ezcontentobject_name.language_id, 2 ) * 8 ) 
       
                            ORDER BY path_string
      


      Steps to reproduce:

      1. Simply apply EZSP-015-EZP4.7
      2. Access the administration backend, and check the tree menu (the content is missing)
      3. Check var/log/error.log to see the sql errors
      1. error.log
        32 kB
        Ricardo Correia

        Issue Links

          Activity

          Hide
          Pedro Resende (Inactive) added a comment -

          Tested and approved by Q.A.

          Show
          Pedro Resende (Inactive) added a comment - Tested and approved by Q.A.
          Hide
          Gunnstein Lye added a comment -
          Show
          Gunnstein Lye added a comment - Introduces regression https://jira.ez.no/browse/EZP-23976
          Hide
          Gunnstein Lye added a comment -
          Show
          Gunnstein Lye added a comment - EZP-23976 is a duplicate of https://jira.ez.no/browse/EZP-19512

            People

            • Assignee:
              Unassigned
              Reporter:
              Ricardo Correia (Inactive)
            • Votes:
              1 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: