Details
-
Bug
-
Resolution: Fixed
-
High
-
4.4.0
-
None
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
- is duplicated by
-
EZP-18057 Adding keyword block (in Oracle) gives DB error
- Closed