[TYPO3-english] Upgrading from 4.4 to 4.5 with Postgres
Boris Gulay
boris at boressoft.ru
Fri Sep 23 17:08:20 CEST 2011
During upgrade procedure I've received some errors but, as it seems to
me, they are not so important. After upgrading I can login to BE and all
seems to work.
But when I navigate to any of my sites I see an error message:
"No pages are found on the rootlevel!"
Of course pages on root level are present because before upgrading all
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"
How can I fix this? Something went wrong during upgrade or TYPO3 4.5
just does not run with Postgres?
More information about the TYPO3-english
mailing list