Project

General

Profile

Actions

Bug #86605

closed

Error when trying to display categories through a backend module

Added by Christopher Kaster over 5 years ago. Updated over 5 years ago.

Status:
Closed
Priority:
Should have
Assignee:
-
Category:
Extbase + l10n
Target version:
-
Start date:
2018-10-09
Due date:
% Done:

0%

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

Description

When trying to render objects with categories in a backend module, TYPO3 v9 (9.5.0 to be exact) throws this error:

An exception occurred while executing 'SELECT `uid_local`, `uid_foreign`, `tablenames`, `fieldname`, `sorting`, `sorting_foreign`, `uid`, `pid`, `tstamp`, `crdate`, `cruser_id`, `deleted`, `hidden`, `starttime`, `endtime`, `t3ver_oid`, `t3ver_id`, `t3ver_wsid`, `t3ver_label`, `t3ver_state`, `t3ver_stage`, `t3ver_count`, `t3ver_tstamp`, `t3ver_move_id`, `t3_origuid`, `sys_language_uid`, `l10n_parent`, `l10n_diffsource`, `title`, `description`, `parent`, `items`, `l10n_state`, `fe_group`, `images`, `single_pid`, `shortcut`, `import_id`, `import_source`, `seo_title`, `seo_description`, `seo_headline`, `seo_text`, `content` FROM `sys_category` WHERE (`pid` = ?) AND (`t3ver_oid` = ?) AND (`t3ver_wsid` = ?) AND (`sys_category`.`deleted` = 0) LIMIT 1' with params [-1, 95, -99]: Unknown column 'uid_local' in 'field list'

I made a small extension to showcase/reproduce this error and we've tested this on multiple instances: https://github.com/atomicptr/categories_error (Note the readme)

This could possibly be my fault for using something wrong that has potentially changed, but I was unable to find any cause for this.


Files

screenshot_2018-10-09_17_12_49.png (182 KB) screenshot_2018-10-09_17_12_49.png Christopher Kaster, 2018-10-09 17:17

Related issues 1 (0 open1 closed)

Related to TYPO3 Core - Bug #86574: PageRepository misses check for $versioningWorkspaceId > 0Closed2018-10-04

Actions
Actions #1

Updated by Georg Ringer over 5 years ago

  • Category changed from Categorization API to Extbase

just some more hints. Debugging Typo3DbBackend shows that in getObjectDataByQuery there is a select for the categories but $selectParts is

Array
(
    [0] => `sys_category_record_mm`.*
    [1] => `sys_category`.*
)

so this will join the sys_category record with the mm table and this leads to a $row as result which is can't be overlayed later.

Actions #2

Updated by Georg Ringer over 5 years ago

  • Status changed from New to Accepted
Actions #3

Updated by Markus Klein over 5 years ago

Thanks for the excellent bug report. We are looking into this.

Actions #4

Updated by Tymoteusz Motylewski over 5 years ago

  • Category changed from Extbase to Extbase + l10n
Actions #5

Updated by Tymoteusz Motylewski over 5 years ago

  • Status changed from Accepted to Needs Feedback

Hi
I couldn't reproduce the issue.
I have current master debf38e8d5a89fc69ed05ce4ba0badcaeab000a9, cloned the repo and created 3 records
1) with one category
2) with multiple categories
3) with no category attached

The list is rendered correctly.

Actions #6

Updated by Georg Ringer over 5 years ago

this has been fixed with #86574 but I am not sure if not accidently ...

Actions #7

Updated by Georg Ringer over 5 years ago

  • Related to Bug #86574: PageRepository misses check for $versioningWorkspaceId > 0 added
Actions #8

Updated by Tymoteusz Motylewski over 5 years ago

  • Status changed from Needs Feedback to Resolved

Alresdy fixed

Actions #9

Updated by Tymoteusz Motylewski over 5 years ago

  • Status changed from Resolved to Closed
Actions

Also available in: Atom PDF