I'm creating a Typo3 OnePager Website with help of this Blog Post. It loads all the subpages of the root page as sections in the OnePager. This work as explained, but it only loads the content directly from tt_content and not via Fluidtemplate. I want it to load with Fuildtemplate because I have several different templates which can be selected in the backend.
So the whole TS, that loads the content and the template looks like this:
lib.sectionContent = HMENU
lib.sectionContent {
1 = TMENU
1 {
NO = 1
NO {
doNotLinkIt = 1
stdWrap >
stdWrap {
cObject = COA
cObject {
if.value = 4
if.equals.field = doktype
if.negate = 1
10 < temp.titleSectionId
10.wrap = <section id="|">
20 = CONTENT
20 < styles.content.get
20 {
table = tt_content
select.where.field = column
select.where.wrap = colPos = |
}
}
30 = TEXT
30 {
wrap = </section>
}
}
}
}
}
}
lib.mainTemplate = FLUIDTEMPLATE
lib.mainTemplate{
templateName = TEXT
templateName.stdWrap{
cObject = TEXT
cObject{
data = levelfield:-2,backend_layout_next_level,slide
override.field = backend_layout
split {
token = pagets__
1.current = 1
1.wrap = |
}
}
ifEmpty = contentPage1column
}
templateRootPaths {
10 = {$path.privat}Templates/Page/
}
layoutRootPaths {
10 = {$path.privat}Layouts/Page/
}
partialRootPaths {
10 = {$path.privat}Partials/Page/
}
}
In the template I load the content with
<f:format.raw><f:cObject typoscriptObjectPath="lib.sectionContent" data="{column:0}" /></f:format.raw>
But when I try to load the FE, then I get this Error:
An exception occurred while executing 'SELECT * FROM tt_content
WHERE (tt_content
.pid
IN (1)) AND (colPos =) AND (tt_content
.sys_language_uid
= 0) 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
<= 1546847160) AND ((tt_content
.endtime
= 0) OR (tt_content
.endtime
> 1546847160)) 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
))))) ORDER BY sorting
ASC': You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') AND (tt_content
.sys_language_uid
= 0) AND ((tt_content
.deleted
= 0) AN' at line 1
What am I doing wrong?
Thanks!