Hi,
There were reports of problems with Postgres on TYPO3 4.5. I wanted to
do some investigation this weekend and this report certainly helps!
On 23-9-2011 17:08, Boris Gulay wrote:
works fine. When I've checked PGSQL log file I found the following query:
SELECT * FROM "pages" WHERE "pid" = 0 AND "pages"."deleted" = 0 AND
"pages"."hidden" = 0 AND "pages"."starttime"<= 1316789940 AND
("pages"."endtime" = 0 OR "pages"."endtime"> 1316789940) AND NOT
"pages"."t3ver_state"> 0 AND "pages"."doktype"< 200 AND
("pages"."fe_group" = '' OR "pages"."fe_group" IS NULL OR
"pages"."fe_group" = '0' OR FIND_IN_SET('0', "pages"."fe_group") != 0
OR FIND_IN_SET('-1', "pages"."fe_group") != 0) ORDER BY "sorting"
LIMIT 1 OFFSET 0
that executes with an error:
"function find_in_set(unknown, character varying) does not exist"
You do have DBAL active I suppose? DBAL should rewrite the FIND_IN_SET()
to a Postgres compatible construction, but something goes wrong here it
seems.
If I can reproduce this the coming days, it will probably be relatively
easy to fix. Stay tuned!
--
Kind regards / met vriendelijke groet,
Jigal van Hemert.
_______________________________________________
TYPO3-english mailing list
TYPO3-english@lists.typo3.org
http://lists.typo3.org/cgi-bin/mailman/listinfo/typo3-english
