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

Also available in: Atom PDF