Project

General

Profile

Actions

Bug #66561

closed

MySQL Error in Page Preview / Page View

Added by Elmar Putz over 9 years ago. Updated over 8 years ago.

Status:
Closed
Priority:
Must have
Assignee:
-
Category:
Content Rendering
Target version:
-
Start date:
2015-04-23
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
7
PHP Version:
5.5
Tags:
Complexity:
medium
Is Regression:
No
Sprint Focus:

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


Files

Actions

Also available in: Atom PDF