Issue Bug Closed

#66561MySQL Error in Page Preview / Page View

Elmar Putz 04/23/15, 16:54 updated 03/01/16, 07:08

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.