TYPO3 Core

After an upgrade from 6.2 to 7.6 I found out that config.sys_language_mode=ignore seems to be ignored. In my installtion sys_language_mode is complety ignored for some reasons.

For further investigations I will post the same SELECT taken out from admpanel.

SELECT from 6.2 working properly

SELECT * FROM tt_content
WHERE tt_content.pid IN (129)
AND colPos = 70
AND header_layout = 120
AND tt_content.deleted=0
AND tt_content.t3ver_state<=0
AND tt_content.pid<>-1
AND tt_content.hidden=0
AND tt_content.starttime<=1449854220
AND (tt_content.endtime=0 OR tt_content.endtime>1449854220)
AND (tt_content.fe_group=''
OR tt_content.fe_group IS NULL
OR tt_content.fe_group='0'
OR FIND_IN_SET('0',tt_content.fe_group)
OR FIND_IN_SET('-1',tt_content.fe_group))

SELECT in 7.6 not working

SELECT * FROM tt_content
WHERE tt_content.pid IN (129)
AND colPos = 70
AND (tt_content.sys_language_uid = 0)
AND header_layout = 120
AND tt_content.deleted=0
AND tt_content.t3ver_state<=0
AND tt_content.pid<>-1
AND tt_content.hidden=0
AND tt_content.starttime<=1449858780
AND (tt_content.endtime=0 OR tt_content.endtime>1449858780)
AND (tt_content.fe_group=''
OR tt_content.fe_group IS NULL
OR tt_content.fe_group='0' 
OR FIND_IN_SET('0',tt_content.fe_group)
OR FIND_IN_SET('-1',tt_content.fe_group))" 

config.sys_language_mode is not working as expected because AND (tt_content.sys_language_uid = 0) appears inside the select which is not correct (imho.)

config.sys_language_mode = ignore should remove any existens of tt_content.sys_language_uid = X inside the select.