Hey.
I’m trying to keep future entries from displaying in my tag cloud, which they currently do. I tried setting a dynamic stop_before variable with the current date and time, but it returned a SQL error on the page. I thought it might be something with the php parsing, so I tried just inputting a static date variable:
stop_before="2007-06-1 5:00 PM"
to see if was working and I got the same error.
MySQL ERROR:
Error Number: 1054
Description: Unknown column ‘e.entry_date’ in ‘where clause’
Query: SELECT t.tag_name, COUNT(e.tag_id) AS count FROM exp_tag_tags AS t LEFT JOIN exp_tag_entries e ON t.tag_id = e.tag_id INNER JOIN exp_weblogs w ON w.weblog_id = e.weblog_id WHERE t.site_id IN (‘1’) AND t.tag_id != ‘’ AND e.type = ‘weblog’ AND w.is_user_blog = ‘n’ AND (e.weblog_id = ‘2’ OR e.weblog_id = ‘3’ ) AND e.entry_date < ‘1195993800’ GROUP BY e.tag_id ORDER BY count DESC LIMIT 20
I tried using start_on and different dates but all returned the same error.
Any clue why this might be happening? I couldn’t find anyone with a similar problem in the solspace or ee forums.
Also, closed entry tags display in all the clouds. Is this normal tag module behavior?
I’m running the latest tag module, upgraded right before I tried messing with the tag cloud, and here is the code I’m using for the cloud.
{exp:tag:cloud weblog="regular|lede" groups="4" start="8" step="4" stop_before="2008-11-25 12:00 PM"}
<a href="{path="tags/tag"}{websafe_tag}" title="{tag_name} ({count})" style="font-size:{step}px;">{tag}</a>
{/exp:tag:cloud}
Thanks.
