Project

General

Profile

Actions
Copy link

Bug #92770

closed

Database error FLUIDTEMPLATE

Added by Hans-Georg Althoff about 4 years ago. Updated over 3 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
-
Target version:
-
Start date:
2020-11-04
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
9
PHP Version:
7.4
Tags:
Complexity:
Is Regression:
Sprint Focus:

Description

I am using 9.5.20 and try to implement a FLUIDTEMPLATE.
Here the setup:


 page.shortcutIcon = fileadmin/Page/Resources/Public/Images/cowboy-hat.ico
 page = PAGE 
 page.typeNum = 0
 page.10 = FLUIDTEMPLATE 
 page.10 {
     format = html
     # Pfad zu der HTML Vorlage der Webseite 
     file = fileadmin/Page/Resources/Private/Page/Layouts/MainLayot.htmlMainLayout.html
     # Pfad zu eingebundenen Partials 
     partialRootPath = fileadmin/Page/Resources/Private/Partials/
     # Pfad zur Layout Datei 
     layoutRootPath = fileadmin/Page/Resources/Private/Layouts/
     # Pfad zur Layout Datei 
     templateRootPath = fileadmin/Resources/Private/Templates/     
     variables {
 <!--    page_title = TEXT
         page_title.field = subtitle // title -->

         # Verknüpfung der Inhalte mit dem Backend Layout 
         contentNormal < styles.content.get
         content.select.where = colPos = 10
        contentLeft < styles.content.get
        contentLeft.select.where = colPos = 11
        contentRight < styles.content.get
        contentRight.select.where = colPos = 12     }
 }
page.10.file.stdWrap.cObject = CASE
page.10.file.stdWrap.cObject {
     key.data = levelfield:-1, backend_layout_next_level, slide
     key.override.field = backend_layout

     # Einbindung des ersten HTML Templates 
     1 = TEXT
     1.value = fileadmin/Resources/Private/Templates/Layout1ColumnPage.html

     # Einbindung des zweiten HTML Templates 
     2 = TEXT
     2.value = fileadmin/Resources/Private/Templates/Layout2ColumnPage.html

     # Einbindung der Standard HTML Vorlage 
     default = TEXT
     default.value = fileadmin/Resources/Private/Templates/Layout1ColumnPage.html
  }

But I get an error from a select see attached file.
Attached you will find the tt_content.sql file

All content was save by Typo3

I think, that it is a bug

Files

Typo3_colPos.png (39.3 KB) Typo3_colPos.png Hans-Georg Althoff, 2020-11-04 17:21

Related issues 2 (0 open — 2 closed)

Has duplicate TYPO3 Core - Bug #92772: Database error FLUIDTEMPLATERejected2020-11-04

Actions
Has duplicate TYPO3 Core - Bug #92771: Database error FLUIDTEMPLATERejected2020-11-04

Actions
Actions
Copy link
 #1

Updated by Georg Ringer about 4 years ago

  • Has duplicate Bug #92772: Database error FLUIDTEMPLATE added
Actions
Copy link
 #2

Updated by Georg Ringer about 4 years ago

  • Has duplicate Bug #92771: Database error FLUIDTEMPLATE added
Actions
Copy link
 #3

Updated by Georg Ringer about 4 years ago

  • Status changed from New to Needs Feedback

Thanks for reporting the issue.

I am pretty sure this is because of the } at the end of

contentRight.select.where = colPos = 12     }

furthermore you should read up https://stackoverflow.com/questions/41410877/what-is-the-best-usage-of-typoscript-in-fluid-templates/41422148#41422148 to improve performance

Actions
Copy link
 #4

Updated by Riccardo De Contardi over 3 years ago

  • Status changed from Needs Feedback to Closed

No feedback since a very long time -> closing it

If you think that this is the wrong decision or experience the issue again on newer TYPO3 versions, please reopen it or open a new issue with a reference to this one.

Thank you.

Actions
Copy link

Also available in: Atom PDF