Details
-
Bug
-
Resolution: Fixed
-
Medium
-
4.7.0
-
None
-
eZ Publish 4.7 EE
eZ Publish Extension for Oracle® database 2.4.0
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:
- Simply apply 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