[TYPO3-english] vge_tagcloud and tt_news

[Francois Suter]

Hi,

> $whereClause = pid IN(***SEE_BELOW***) AND tt_news.deleted=0 AND 
> tt_news.t3ver_state<=0 AND tt_news.hidden=0 AND 
> (tt_news.starttime<=1240321260) AND (tt_news.endtime=0 OR 
> tt_news.endtime>1240321260) AND (tt_news.fe_group='' OR tt_news.fe_group 
> IS NULL OR tt_news.fe_group='0' OR (tt_news.fe_group LIKE '%,0,%' OR 
> tt_news.fe_group LIKE '0,%' OR tt_news.fe_group LIKE '%,0' OR 
> tt_news.fe_group='0') OR (tt_news.fe_group LIKE '%,-1,%' OR 
> tt_news.fe_group LIKE '-1,%' OR tt_news.fe_group LIKE '%,-1' OR 
> tt_news.fe_group='-1')) AND (sys_language_uid = '0') AND t3ver_wsid = '0'

Try to print out the whole query and execute it manually via phpMyAdmin, 
for example.

> Instead of ***SEE_BELOW***, a very long list of page ids is included: I 
> guess they must be all the pages in my site. This looks somehow strange to 
> me: why are the news searched in relation with the page ids, although they 
> are in the tt_news table?

tt_news records are stored relative to a page. So they *do* have a pid. 
The tag cloud can be limited to work only on part of the page tree, but 
in your case it was configured to work on all pages starting from the 
root. So it's normal that you get this long list of PIDs.

Cheers

-- 

Francois Suter
Cobweb Development Sarl - http://www.cobweb.ch