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

(tc-247)(Oracle) removing main node after adding new locations raises a eZOracleDB error

    XMLWordPrintable

    Details

      Description

      Gi,

      When we remove the main node of an article, after adding a new location, a dba error is raised:

      Fatal error: Call to a member function attribute() on a non-object in /data1/www/apache2php52/ezporacle/.run/kernel/classes/ezcontentobjecttreenode.php on line 2824
      Fatal error: eZ Publish did not finish its request
      
      The execution of eZ Publish was abruptly ended, the debug output is present below.
      

      And the information on the debug is:

      Error: eZOracleDB 	Feb 23 2011 11:42:22
      
      Error (933): ORA-00933: SQL-kommandoen er ikke avsluttet riktig
      Failed query at offset 99:
      SELECT co.*, con.name as name, con.real_translation, cot.node_id
                   FROM ezcontentobject AS co
                   JOIN ezcontentobject_tree AS cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
                   JOIN ezcontentobject_name AS con ON co.id = con.contentobject_id AND co.current_version = con.content_version
                   WHERE cot.node_id IN ( 2 ) AND 
       ( bitand( con.language_id, co.language_mask ) > 0 AND
       bitand( co.language_mask - bitand( co.language_mask, con.language_id ), 1 )
         + bitand( co.language_mask - bitand( co.language_mask, con.language_id ), 2 )   <
         bitand( con.language_id, 1 )
         + bitand( con.language_id, 2 ) ) 
      
      
      Start of error:
      AS co
                   JOIN ezcontentobject_tree AS cot ON co.id = cot.contentobject_id AND co.current_version = cot.contentobject_version
                   JOIN ezcontentobject_name AS con ON co.id = con.contentobject_id AND co.current_version = con.content_version
                   WHERE cot.node_id IN ( 2 ) AND 
       ( bitand( con.language_id, co.language_mask ) > 0 AND
       bitand( co.language_mask - bitand( co.language_mask, con.language_id ), 1 )
         + bitand( co.language_mask - bitand( co.language_mask, con.language_id ), 2 )   <
         bitand( con.language_id, 1 )
         + bitand( con.language_id, 2 ) ) 
      
      Error: eZContentObject::fetchByNodeID 	Feb 23 2011 11:42:22
      
      A problem occured while fetching objects with following NodeIDs : 2
      
      Steps to reproduce
      - Create a "news" folder
      - Access the "news" folder
      - Create an article "article1"
      - Add a new location (might be home folder) for the "article1"
      - Delete "article1" (uncheck the send to trash)
      

      The error is raised after deleting "article1"

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              unknown unknown
              Reporter:
              pcardiga Paulo Cardiga
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: