Details
-
Bug
-
Resolution: Fixed
-
Medium
-
4.0.4, 4.1.1
-
None
-
Operating System: Ubuntu 9.04
PHP Version: (please be specific, like '4.4.3' or '5.1.5') 5.2.6
Database and version: MySQL (ezmysqli)
Browser (and version):
Description
When "keyword" is in ClearCacheMethod[] array (in viewcache.ini), the content cache of the objects with one keyword in common with the published one is not cleared if there are two or more keywords. This is due to a wrong escaping in SQL query used to retrieve the "keyword related" objects.
Steps to reproduce
1. add a keyword attribute to the article content class
2. add the following lines to settings/override/viewcache.ini.append.php
[ViewCacheSettings]
SmartCacheClear=enabled
[article]
DependentClassIdentifier[]=article
ClearCacheMethod[]=keyword
2. create an article content object with "aa" as a keyword
3. generate the view cache for this object
4. create an article content object with "aa" and "bb" as keywords
the view cache of the first article is not cleared.