[TYPO3-ttnews] tt_news dbal compliant?

[Uroš Kositer]

Hi!

I have just realized that this beahviour is already submitted in
bugtracker (0002438). Sorry for making noise on the list:)

Kind regards
Urosh

2006/9/26, Uroš Kositer <uroshsi at gmail.com>:
> 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
> _______________________________________________
> TYPO3-project-tt-news mailing list
> TYPO3-project-tt-news at lists.netfielders.de
> http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-project-tt-news
>