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