Details
-
Bug
-
Resolution: Fixed
-
High
-
4.5.0alpha
-
None
-
Operating System: Fedora 14
PHP Version: PHP 5.3.3
Database and version: PostgreSQL 9.0.2
Browser (and version):
Description
Generated by ezwebin/packages/ezwebin_extension/ezextension/ezwebin/autoloads/eztagcloud.php on line 127:
Error: eZPostgreSQLDB Jan 04 2011 14:46:47
Error: error executing query: SELECT ezkeyword.keyword, count(ezkeyword.keyword) AS keyword_count
FROM ( ezkeyword, ezkeyword_attribute_link
)
LEFT JOIN ezcontentobject_attribute
ON ezkeyword_attribute_link.objectattribute_id = ezcontentobject_attribute.id
LEFT JOIN ezcontentobject
ON ezcontentobject_attribute.contentobject_id = ezcontentobject.id
LEFT JOIN ezcontentobject_tree
ON ezcontentobject_attribute.contentobject_id = ezcontentobject_tree.contentobject_id
WHERE ezkeyword.id = ezkeyword_attribute_link.keyword_id
AND ezcontentobject.status = 1
AND ezcontentobject_attribute.version = ezcontentobject.current_version
AND ezcontentobject_tree.main_node_id = ezcontentobject_tree.node_id
AND ezcontentobject_tree.path_string like '/1/2/88/%'
AND ezcontentobject_tree.node_id != 88
AND ezcontentobject_tree.is_invisible = 0
AND
ezcontentobject.language_mask & 7 > 0
AND
ezcontentobject_attribute.language_id & 7 > 0
GROUP BY ezkeyword.id, ezkeyword.keyword
ORDER BY ezkeyword.keyword ASC ERROR: syntax error at or near ","
LINE 2: ... FROM ( ezkeyword, ezkeywor...
^
Steps to reproduce
Open front page on ezflow with PostgreSQL