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

TC-17 - (EzFlow on Oracle) - Publishing a "Keyword" block raises an error

    Details

      Description

      Hi,

      On Oracle, ezflow, when we add a "keyword" block and publish the page, we get the following error:

      Error (1791): ORA-01791: ikke et valgt (med SELECT) uttrykk
      Failed query at offset 1219:
      SELECT DISTINCT substr( ezkeyword.keyword, 1, 10 ) AS keyword ,ezcontentobject_tree.node_id
      FROM ezkeyword, ezkeyword_attribute_link,ezcontentobject_tree,ezcontentobject,ezcontentclass
      , ezcontentobject_attribute a1

      WHERE
      a1.version=ezcontentobject.current_version
      AND a1.contentobject_id=ezcontentobject.id AND
      ezkeyword.keyword LIKE 'testsystem%'
      AND ezcontentobject_tree.is_invisible = 0

      AND ezkeyword.class_id IN ( 16 )

      AND ezcontentobject_tree.parent_node_id = '72'
      AND ezcontentclass.version=0
      AND ezcontentobject.status=1
      AND ezcontentobject_tree.main_node_id=ezcontentobject_tree.node_id
      AND ezcontentobject_tree.contentobject_id = ezcontentobject.id
      AND ezcontentclass.id = ezcontentobject.contentclass_id
      AND a1.id=ezkeyword_attribute_link.objectattribute_id
      AND ezkeyword_attribute_link.keyword_id = ezkeyword.id ORDER BY ezcontentobject.published DESC

      Start of error:
      ezcontentobject.published DESC

      ---------

      Invalid argument supplied for foreach() in /data1/www/apache2php52/ezporacle/.run/kernel/content/ezcontentfunctioncollection.php on line 1040

      Steps to reproduce

      -Log in as admin in ezflow
      -Create new folder "News"
      -Click "News" in top menu
      -Create new article "Article1"
      Summary : body1
      Tags : testsystem, systemtest
      -Create new article "Article2"
      Summary : body2
      Tags : testsystem, failure
      -Create new article "Article3"
      Summary : body3
      Tags : systemtest
      -Create new article "Article4"
      Summary : body4
      Tags : failure
       
      Test the keyword block
      -Go to frontpage
      -Edit fronpage
      -In "Block type", select "Keyword"
      -Click "Add block" button
      -Move the new "Keyword" block to the top using drag&drop
      -Edit the new block:
        Name : keyword test
        Source : "News" subtree
        Keywords : failure 
        Classes : article
      -Publish the frontpage
      

        Issue Links

          Activity

          Hide
          Gaetano Giunta added a comment -

          A direct consequence of #015719: error in fetch content/keyword with oracle

          Show
          Gaetano Giunta added a comment - A direct consequence of #015719: error in fetch content/keyword with oracle
          Hide
          Vidar Langseid added a comment -

          reopening, not a dupe after all

          Show
          Vidar Langseid added a comment - reopening, not a dupe after all
          Show
          Chen Xiongjie added a comment - - edited Fixed in 4.5.0 beta2 https://github.com/ezsystems/ezpublish/commit/70106d2bcffdaf212336751688e4f8a57386bcf7
          Hide
          Geir Arne Waaler added a comment -

          The issue is fixed. I move it to Closed.

          Show
          Geir Arne Waaler added a comment - The issue is fixed. I move it to Closed.

            People

            • Assignee:
              Chen Xiongjie
              Reporter:
              Paulo Cardiga
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: