[Typo3] Solution for cm_jstickernews stopped showing newsheadlines
Christoph Kammermeyer
ckammermeyer at media-puzzle.de
Fri Aug 19 18:14:58 CEST 2005
This refers to a thread posted on July 1st concerning cm_jstickernews and
newer tt_news versions. I had the same problem and found the following
solution:
Replace line 502 of pi1/class.tx_cm_jstickernews_pi1.php
by:
$cat_select = " AND cat.uid_foreign IN (".$this->conf["newsCatList"].")";
and line 520 by:
$query = "SELECT * FROM ".$table." left join `tt_news_cat_mm` cat on
(tt_news.uid=cat.uid_local)
".$news_select.$cat_select.$this->cObj->enableFields($table).$orderBy_limit;
This modified query uses the tt_news_cat_mm table to fetch the results.
More information about the TYPO3-english
mailing list