#66561MySQL Error in Page Preview / Page View
Description
When rendering the page via backend preview or frontend, the following error appears:
SELECT * FROM pages WHERE pid IN () AND pages.deleted=0 AND pages.hidden=0 AND pages.starttime<=1429800120 AND (pages.endtime=0 OR pages.endtime>1429800120) 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)) AND pages.nav_hide=0 AND pages.doktype NOT IN (6) ORDER BY sorting
I’ve tested the MySQL query directly on the database and i identified the problem:
SELECT * FROM pages WHERE pid IN ()
should be
SELECT * FROM pages WHERE pid IN (‘’)
The error appears on the top of the page, the rest of the page is rendered as expected – see this screenshot:
https://www.dropbox.com/s/xwqr9dccb077gsj/Screenshot%202015-04-23%2016.52.53.png?dl=0
Reviews 0
No change resolves or names this issue in its commit message, and no comment links one.