[TYPO3-ttnews] tt_news dbal compliant?

[Uroš Kositer]

2006/9/26, Christian Welzel <gawain at camlann.de>:
> Uroš Kositer schrieb:
>
> > fine. But when I install tt_news no news are displayed and DBAL debug
> > log shows some SQL query errors. Are there any plans for making
>
> Could you post those errors to this list ?
> Its a bit hard to help you without any hints...

Hi!

Error is in query that begins with:
SELECT COUNT("DISTINCT(tt_news.uid)") FROM "tt_news" LEFT OUTER JOIN
"tt_news_cat_mm" ON "tt_news"."uid"="tt_news_cat_mm"."uid_local"

error message is: ORA-00904: "DISTINCT(tt_news.uid)": invalid identifier

As I wrote this message and looked again at the query, I realized that
this might be DBAL bug. It is obvious that "DISTINCT(tt_news.uid)"
should not be quoted and should look like this:
DISTINCT("tt_news"."uid").

I'll try to contact Karsten about DBAL.

Kind regards
Urosh