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

Tag cloud + object state limitations generate a fatal SQL error

    XMLWordPrintable

    Details

      Description

      When an object states related limitation is in place, the eztagcloud operator will generate a fatal SQL error:

      Query error (1054): Unknown column 'ezkeyword_attribute_link.objectattribute_id' in 'on clause'.
      Query: SELECT ezkeyword.keyword, count(ezkeyword.keyword) AS keyword_count 
      FROM ezkeyword, ezkeyword_attribute_link , ezcobj_state_link ezcobj_state_lnk_0_perm , ezcobj_state_group ezcobj_state_grp_0_perm , ezcobj_state ezcobj_state_0_perm 
      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 ezco
      in /media/www/htdocs/3rdLine/issue5829/lib/ezdb/classes/ezmysqlidb.php on line 426
      

      This problem was fixed in EZP-17601, but seems to have been reintroduced by EZP-17804.

      STEPS TO REPRODUCE

      1. Create two object states (OK & NOK).
      2. Clear cache.
      3. Change anonymous policies to "content \ read \ Section( Standard ) , StateGroup_teste( ok )"
      4. In frontend, open http://your_site/content/view/tagcloud/2

      There will be no content displayed and the error will be displayed in log files.

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              eduardo.fernandes-obsolete@ez.no Eduardo Fernandes (Inactive)
              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 - 6 hours, 45 minutes
                  6h 45m