Details
-
Bug
-
Resolution: Fixed
-
High
-
4.5.0, 4.6.0, 4.7.0, 5.0, 5.1, 5.2
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
- Create two object states (OK & NOK).
- Clear cache.
- Change anonymous policies to "content \ read \ Section( Standard ) , StateGroup_teste( ok )"
- 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.