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
