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

    XMLWordPrintable

    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
      

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                Created:
                Updated:
                Resolved: