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

          Transition Time In Source Status Execution Times Last Executer Last Execution Date
          Open Open Confirmed Confirmed
          10m 31s 1 ricardo.correia@ez.no 10/Nov/14 6:21 PM
          Confirmed Confirmed InputQ InputQ
          15h 16m 1 Paulo Lopes (Inactive) 11/Nov/14 9:38 AM
          InputQ InputQ Development Development
          6h 36m 1 joao.inacio@ez.no 11/Nov/14 4:15 PM
          Development Development Development Review Development Review
          24s 1 joao.inacio@ez.no 11/Nov/14 4:15 PM
          Development Review Development Review Development Review done Development Review done
          53s 1 joao.inacio@ez.no 11/Nov/14 4:16 PM
          Development Review done Development Review done Documentation Review done Documentation Review done
          8s 1 joao.inacio@ez.no 11/Nov/14 4:16 PM
          Documentation Review done Documentation Review done QA QA
          1h 50m 1 pedro.resende@ez.no 11/Nov/14 6:07 PM
          QA QA Closed Closed
          1d 18h 2m 1 pedro.resende@ez.no 13/Nov/14 12:09 PM

            People

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

              Dates

              • Created:
                Updated:
                Resolved: