[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