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

Tag cloud stacktrace on PostgreSQL

    XMLWordPrintable

Details

    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

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              cpg Christian Pfeffer Gjengedal
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 2 hours, 45 minutes
                  2h 45m