Issue Bug Closed

#22116IFNULL operator cannot be parsed

Xavier Perseguers 02/13/10, 11:58 updated 02/13/10, 12:20

Description

When using tt_news and choosing to restrict the list of news with a set of news categories, FE rendering crashes with:

Could not parse where clause in /path/to/dbal/class.ux_t3lib_db.php : 1072

This is due by tt_news which issues this kind of query:

1=1 AND (IFNULL IN (21,22)) AND tt_news.sys_language_uid IN (0,-1) AND tt_news.pid > 0 AND tt_news.pid IN (61) AND tt_news.deleted=0 AND tt_news.t3ver_state<=0 AND tt_news.hidden=0 AND tt_news.starttime<=1266057900 AND (tt_news.endtime=0 OR tt_news.endtime>1266057900) 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’))

Problem is the IFNULL which cannot be parsed ATM.

(issue imported from #M13531)

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.