Uploaded image for project: 'eZ Publish / Platform'
  1. eZ Publish / Platform
  2. EZP-15114

ezoracle : Unable to delete objects

    XMLWordPrintable

Details

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Medium Medium
    • None
    • 4.1.3, extension/ezoracle 2.0.1
    • Database related
    • 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

        Activity

          People

            unknown unknown
            vl vl
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: