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

Oracle : query error when creating folders

    XMLWordPrintable

    Details

      Description

      Hi

      In ezwebin I try to create folders and are given these SQL errors:

      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 ( 62 ) 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 ( 62 ) 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 ) )
      

      btw, ORA-00933: SQL command not properly ended

      The folder is however created, and seems to work...
      Also, I don't get the error when I create a folder ("vtest" ) below node 2
      If if I then create new subfolder below "vtest", I get the error

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              chen Chen Xiongjie
              Reporter:
              vl Vidar Langseid
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: