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

          Ricardo Correia (Inactive) created issue -
          Ricardo Correia (Inactive) made changes -
          Field Original Value New Value
          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)

          {noformat}
          [ 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
          {noformat}
          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)

          {noformat}
          [ 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
          {noformat}

          ----
          *Steps to reproduce:*

          # Simply apply [EZSP-015-EZP4.7|https://support.ez.no/Maintenance/Service-Packs/eZ-Publish-Enterprise-4.7/EZSP-015-EZP4.7]
          # Access the administration backend, and check the tree menu (the content is missing)
          # Check {{var/log/error.log}} to see the sql errors
          Ricardo Correia (Inactive) made changes -
          Attachment error.log [ 18908 ]
          Ricardo Correia (Inactive) made changes -
          Status Open [ 1 ] Confirmed [ 10037 ]
          Joao Inacio (Inactive) made changes -
          Link This issue relates to EZP-19158 [ EZP-19158 ]
          Paulo Lopes (Inactive) made changes -
          Status Confirmed [ 10037 ] InputQ [ 10001 ]
          Joao Inacio (Inactive) made changes -
          Status InputQ [ 10001 ] Development [ 3 ]
          Assignee Joao Inacio [ joao.inacio@ez.no ]
          Joao Inacio (Inactive) made changes -
          Status Development [ 3 ] Development review [ 10006 ]
          Joao Inacio (Inactive) made changes -
          Status Development review [ 10006 ] Development Review done [ 10028 ]
          Fix Version/s 4.7 Maintenance [ 12583 ]
          Joao Inacio (Inactive) made changes -
          Status Development Review done [ 10028 ] Documentation done [ 10011 ]
          Pedro Resende (Inactive) made changes -
          Status Documentation done [ 10011 ] QA [ 10008 ]
          Assignee Joao Inacio [ joao.inacio@ez.no ] Pedro Resende [ pedro.resende@ez.no ]
          Pedro Resende (Inactive) made changes -
          Rank Ranked higher
          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.
          Pedro Resende (Inactive) made changes -
          Assignee Pedro Resende [ pedro.resende@ez.no ]
          Status QA [ 10008 ] Closed [ 6 ]
          Resolution Fixed [ 1 ]
          Hide
          Gunnstein Lye added a comment -
          Show
          Gunnstein Lye added a comment - Introduces regression https://jira.ez.no/browse/EZP-23976
          Gunnstein Lye made changes -
          Link This issue relates to EZP-23976 [ 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
          André Rømcke made changes -
          Workflow eZ Engineering Scrumban Workflow [ 65114 ] EZ* Development Workflow [ 85506 ]
          Alex Schuster made changes -
          Workflow EZ* Development Workflow [ 85506 ] EZEE Development Workflow [ 124344 ]
          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: