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
          Pedro Resende (Inactive) made changes -
          Assignee Pedro Resende [ pedro.resende@ez.no ]
          Status QA [ 10008 ] Closed [ 6 ]
          Resolution Fixed [ 1 ]
          Gunnstein Lye made changes -
          Link This issue relates to EZP-23976 [ EZP-23976 ]
          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 ]

            People

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

              Dates

              • Created:
                Updated:
                Resolved: