Details
-
Bug
-
Resolution: Duplicate
-
Medium
-
None
-
4.1.3, extension/ezoracle 2.0.1
-
None
Description
Hi
It is not possible to delete objects in admin when using ezoracle.
On the screen were you should be asked if you want to put the object in the trash or not you get a SQL error (Causing the "Move to trash" checkbox not to appear at all). The system will also show you "Insufficient permissions" message and disable the "OK" button
Error: eZOracleDB Jul 01 2009 11:41:57 Error (972): ORA-00972: identifier is too long Failed query at offset 400: SELECT count( DISTINCT ezcontentobject_tree.node_id ) as count FROM ezcontentobject_tree, ezcontentobject,ezcontentclass , ezcontentobject_name , ezcobj_state_link ezcobj_state_link_ez_lock_perm , ezcobj_state_group ezcobj_state_group_ez_lock_perm , ezcobj_state ezcobj_state_ez_lock_perm WHERE ezcontentobject_tree.path_string like '/1/43/59/%' and ezcontentclass.version=0 AND ezcontentobject_tree.node_id != 59 AND ezcontentobject_tree.contentobject_id = ezcontentobject.id 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 ), 2 ) < bitand( ezcontentobject_name.language_id, 1 ) + bitand( ezcontentobject_name.language_id, 2 ) ) AND ezcontentobject_tree.is_invisible = 0 AND ezcobj_state_link_ez_lock_perm.contentobject_id = ezcontentobject.id AND ezcobj_state_ez_lock_perm.id = ezcobj_state_link_ez_lock_perm.contentobject_state_id AND ezcobj_state_ez_lock_perm.group_id = ezcobj_state_group_ez_lock_perm.id AND ezcobj_state_group_ez_lock_perm.identifier='ez_lock' AND ((ezcobj_state_ez_lock_perm.id = 1)) AND bitand( ezcontentobject.language_mask, 3 ) > 0 Start of error: ezcobj_state_group_ez_lock_perm , ezcobj_state ezcobj_state_ez_lock_perm WHERE ezcontentobject_tree.path_string like '/1/43/59/%' and ezcontentclass.version=0 AND ezcontentobject_tree.node_id != 59 AND ezcontentobject_tree.contentobject_id = ezcontentobject.id 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 ), 2 ) < bitand( ezcontentobject_name.language_id, 1 ) + bitand( ezcontentobject_name.language_id, 2 ) ) AND ezcontentobject_tree.is_invisible = 0 AND ezcobj_state_link_ez_lock_perm.contentobject_id = ezcontentobject.id AND ezcobj_state_ez_lock_perm.id = ezcobj_state_link_ez_lock_perm.contentobject_state_id AND ezcobj_state_ez_lock_perm.group_id = ezcobj_state_group_ez_lock_perm.id AND ezcobj_state_group_ez_lock_perm.identifier='ez_lock' AND ((ezcobj_state_ez_lock_perm.id = 1)) AND bitand( ezcontentobject.language_mask, 3 ) > 0
Using eZ Publish 4.1.3.
Steps to reproduce
login as admin in admin interface
create article
delete it
Attachments
Issue Links
- is duplicated by
-
EZP-15062 impossible to delete content on oracle
- Closed