#23431Error: No pages are found on the rootlevel! in Frontend when using Oracle
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.