[TYPO3-templavoila] TV 0.5cvs and postgres

Christian Welzel gawain at camlann.de
Sat Jan 21 12:59:26 CET 2006

Hi !

I'm trying to get my typo3 4.0b2 working with postgresql 7.4.7 
using dbal from 4.0b2.
the problem is, that tv tries to use this query:

SELECT sys_language.* FROM pages_language_overlay, sys_language WHERE
pages_language_overlay.sys_language_uid = sys_language.uid AND
pages_language_overlay.pid = 67 AND 1 = 1 GROUP BY
pages_language_overlay.sys_language_uid ORDER BY sys_language.title

but postgres rejects this with the error

ERROR: column "sys_language.uid" must appear in the GROUP BY clause or be
used in an aggregate function.

can you please fix this in a portable way ?

 MfG, Christian Welzel

  GPG-Key:     http://www.camlann.de/key.asc
  Fingerprint: 4F50 19BF 3346 36A6 CFA9 DBDC C268 6D24 70A1 AD15

More information about the TYPO3-project-templavoila mailing list