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
Updated by - 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
Updated by 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
}
}
}
}