Bug #33220

Empty content object when select.pidInList=0 set in TS

Added by Alain over 9 years ago. Updated over 9 years ago.

Should have
Target version:
Start date:
Due date:
% Done:


Estimated time:
TYPO3 Version:
PHP Version:
Is Regression:
Sprint Focus:



I get an empty return value while rendering dropdown list for countries from the static_info_tables extension. I use following TS:

  lib.country = CONTENT
  lib.country {
   table = static_countries
      select {
        pidInList = 0
        orderBy = cn_short_en
        selectFields = uid,cn_iso_3


While tracking the SELECT query in tslib_content, I found out in tslib_content::getQuery() that the logical operator NOT (!) is used to check all select proporties if they exist. This operator does not differ between 0 and empty.

  foreach($properties as $property) {

    if(!$conf[$property]) {


Even select.pidInList = 0 is set in TS, the condition is fulfilled and $conf['pidInList'] is removed.

In next step, $conf['pidInList'] will be compared with ''

  if(!strcmp($conf['pidInList'], '')) {
    $conf['pidInList'] = 'this';

and afterwards 'this' will be replaced with


This leads to a wrong SQL-query because the ID of current page (4) is taken instead of the pid value (0) set in TS.

  SELECT cn_iso_3, cn_short_en FROM static_countries WHERE static_countries.pid IN (4) AND static_countries.deleted=0

In my view, it would be more accurate if to use !isset() instead of NOT in the foreach loop. This will exclude the 0 value in TS.

  foreach($properties as $property) {

-   if(!$conf[$property]) {
+   if(!isset($conf[$property])) {


Many thanks and best regards,


Related issues

Related to TYPO3 Core - Task #57168: Enable queries using "root" and "-1" for pidInListClosedOliver Hader2014-03-21

Is duplicate of TYPO3 Core - Bug #31209: CONTENT still can't select records from rootpageClosed2011-10-24

Is duplicate of TYPO3 Core - Bug #32374: MENU special = updated not working in 4.6ClosedXavier Perseguers2011-12-07


Updated by Markus Klein over 9 years ago

    if(!isset($conf[$property])) {

seems to be a bit useless?!


Updated by Jigal van Hemert over 9 years ago

  • Status changed from New to Needs Feedback

I think it has been fixed with https://review.typo3.org/#change,7839
It should have worked because of a special exception for static_* tables, and in current master (4.7-dev) it already works correctly. In 4.6.3 it didn't work for me.

Can you test if the mentioned change solves the problem for you?


Updated by Alain over 9 years ago

Hello Jigal,

thanks for feedback.

I apply this patch in 4.6.3 and it works great for me.
The same patch is also available at https://review.typo3.org/#change,7826 but it is under review.

Best regards,



Updated by Ernesto Baschny over 9 years ago

  • Category set to TypoScript
  • Status changed from Needs Feedback to Closed
  • Target version set to 4.6.4

Solution is already merged in #32374, so it will be available in 4.6.4 to be released soon. Thanks for your report and feedback!

Also available in: Atom PDF