Issue Bug Closed

#23431Error: No pages are found on the rootlevel! in Frontend when using Oracle

Xavier Perseguers 08/23/10, 22:26 updated 10/14/10, 14:28

Description

Error No pages are found on the rootlevel! is always thrown when showing frontend when using Oracle. In backend page tree is displayed properly.

After investigating, in t3lib/class.t3lib_page.php, around lines 260, query to retrieve page is following one (MySQL) :

pid=0 AND pages.deleted=0 AND pages.hidden=0 AND pages.starttime<=1281620460 AND (pages.endtime=0 OR pages.endtime>1281620460) 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) OR FIND_IN_SET(‘-1’,pages.fe_group))

after being transformed for Oracle, through DBAL, the query becomes:

“pid” = 0 AND “pages”.“deleted” = 0 AND “pages”.“hidden” = 0 AND “pages”.“starttime” <= 1281620460 AND (“pages”.“endtime” = 0 OR “pages”.“endtime” > 1281620460) AND NOT “pages”.“t3ver_state” > 0 AND “pages”.“doktype” < 200 AND (‘,’||“pages”.“fe_group”||’,’ LIKE ‘,-1,’)

It’s clear the a whole part has been lost and the condition on pages.fe_group never is true meaning no page is found!

(issue imported from #M15535)

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.