TYPO3 Core

Problem¶

When using a DatabaseQueryProcessor to get data with a join, the preview link leads to an exception.
I could point the issue to this class and line: typo3/cms-core/Classes/Domain/Repository/PageRepository.php:1701.
There all fields of the row (previously populated with data from the joined table) set as parameter.

Reproduce¶

1. Create a page with a category and a workspace
2. Add data by a DatabaseQueryProcessor including a join (see example)
3. Switch to workspace
4. Show page as preview

Example for category DataProcessor¶

Change pidInList in example.

10 = TYPO3\CMS\Frontend\DataProcessing\DatabaseQueryProcessor
10 {
  if.isTrue.field = categories
  table = sys_category
  join = sys_category_record_mm ON sys_category_record_mm.uid_local = sys_category.uid
  pidInList = xx
  where {
    data = field:uid
    intval = 1
    wrap = sys_category_record_mm.tablenames = "pages" AND sys_category_record_mm.uid_foreign=|
  }
  orderBy = sys_category_record_mm.sorting_foreign
  languageField = 0

  as = categories
}