[TYPO3-dev] no rows returned in getPageOverlay (pages_language_overlay, pageOverlayFields)

[Krystian Szymukowicz]

hi

I have strange issue here. I hope someone can put an light on it.


There is a function getPageOverlay($pageInput,$lUid=-1) in file 
t3lib/class.t3lib_page.php

There is a database query inside this function which puts comma 
separated fields from $TYPO3_CONF_VARS['FE']['pageOverlayFields'] 
database query.

So the query looks like:
SELECT uid,title,nav_title,media,keywords,description FROM 
pages_language_overlay WHERE pid=4.....


I think I must have strange configuration of my mysql server because if 
query look like the above I have no rows returned.

But if the fields are within quotes everything is working as expected.

So this works:
SELECT "uid,title,nav_title,media,keywords,description" FROM 
pages_language_overlay WHERE pid=4.....



So:
1) maybe you know what switch in mysql is responsible for this? I 
googled but found nothing :(

2) should not this fields be within quotes anyway so strange 
configuration as mine could also works?



Thanks on any clarification in this subject.


PHP Version 5.2.12
Suhosin Patch 0.9.7
PDO Driver for MySQL 5.1.47



--
grtz
Krystian Szymukowicz