Bug #83706
Error with 8.0.0 in TYPO3 8 and reference to pages
0%
Description
We have a TYPO3 8.7 installation for a customer, that runs at the moment with "gridelementsteam/gridelements": "dev-master#5661faac75d0de60c76c8b6ad27cf6aaced5be71". This seems to work more or less stable.
Now we want to update to 8.0.0 as a stable version. But using content elements of type shortcut with complete pages (not content elements) just throws an error in backend:
An exception occurred while executing 'SELECT *, FIND_IN_SET(? AS inSet, `pid`) FROM `tt_content` WHERE (`uid` <> ?) AND (`pid` IN (?)) AND (`colPos` >= ?) AND ((`tt_content`.`deleted` = 0) AND (`tt_content`.`hidden` = 0) AND (`tt_content`.`starttime` <= 1517169660) AND ((`tt_content`.`endtime` = 0) OR (`tt_content`.`endtime` > 1517169660))) ORDER BY `inSet` ASC, `colPos` ASC, `sorting` ASC' with params [2, 20, 2, 0]: Incorrect parameters in the call to native function 'find_in_set'
Going back to the old commit helps. I just tested on a fresh installation - same error.
History
#1
Updated by Jo Hasenau almost 2 years ago
- Category changed from General Bugs to Refactoring & Testing
- Status changed from New to Resolved
Has been fixed after the 8.0.0 release and is available in dev-master and with the upcoming maintenance releases.
#2
Updated by Alex Kellner almost 2 years ago
Thx, beside that, the existing TypoScript does not work any more with fluid_styled_content to render pages. If this is also fixed, everything is fine.
If this is not yet fixed, here is my workarround to render references of type pages or tt_content (no mixing possible) for everybody who has the same problem and needs an urgent fix:
# Content elements of type shortcut. Extend with pages for fluid_styled_content tt_content.shortcut =< lib.contentElement tt_content.shortcut { templateName = Shortcut /* * Original shortcuts variables from fluid_styled_content */ # variables.shortcuts = RECORDS # variables.shortcuts { # source.field = records # tables = {$styles.content.shortcut.tables} # } # Overwrite original "shortcuts" variable variables.shortcuts > variables.shortcuts = COA variables.shortcuts { # Shortcut of type tt_content 10 = RECORDS 10 { # Show only if string of tt_content.records == tt_content.records (with removed string "pages_") stdWrap.if { value.cObject = TEXT value.cObject.field = records equals.cObject = TEXT equals.cObject { field = records replacement { 10 { search = pages_ replace = } } } } source.field = records tables = {$styles.content.shortcut.tables} } # Shortcut of type pages 20 = CONTENT 20 { # Show only if string of tt_content.records != tt_content.records (with removed string "pages_") stdWrap.if { value.cObject = TEXT value.cObject.field = records equals.cObject = TEXT equals.cObject { field = records replacement { 10 { search = pages_ replace = } } } negate = 1 } table = tt_content select { pidInList.cObject = TEXT pidInList.cObject { field = records stdWrap.replacement { 10 { search = pages_ replace = } } } where = colPos = 0 languageField = sys_language_uid orderBy = sorting } } } }