Project

General

Profile

Actions

Bug #44947

closed

t3lib_extMgm::makeCategorizable get TCA with wrong foreign_table_where

Added by Tobias Klepp about 11 years ago. Updated about 5 years ago.

Status:
Closed
Priority:
Must have
Assignee:
-
Category:
Categorization API
Target version:
-
Start date:
2013-01-30
Due date:
% Done:

0%

Estimated time:
TYPO3 Version:
6.0
PHP Version:
5.3
Tags:
Complexity:
easy
Is Regression:
No
Sprint Focus:

Description

If I want to use the system categories for my extension records, I can use the function t3lib_extMgm::makeCategorizable. For my understanding, it makes no sense to show all default language categories AND all translated categories. ONLY the default language categories should be displayed for a selection.

The TCA configuration on line 2006 in the file typo3/sysext/core/Classes/Utility/ExtensionManagementUtility.php has the following code:

'foreign_table_where' => ' ORDER BY sys_category.title ASC',

I think, better is the following code:

'foreign_table_where' => ' AND sys_category.sys_language_uid IN (-1,0) ORDER BY sys_category.title ASC',


Related issues 1 (1 open0 closed)

Related to TYPO3 Core - Bug #64163: BackendUtility::getProcessedValue does not evaluate foreign_table_whereAccepted2015-01-07

Actions
Actions #1

Updated by Wouter Wolters about 11 years ago

Does this patch solves you're problem https://review.typo3.org/#/c/12812/ ?

Actions #2

Updated by Tobias Klepp about 11 years ago

No. If I look in the file typo3/sysext/core/Classes/Category/CategoryRegistry.php on line 260 there is the same wrong WHERE clause.

Actions #3

Updated by Mathias Schreiber over 9 years ago

  • Target version changed from 6.0.2 to 7.4 (Backend)
  • Is Regression set to No
Actions #4

Updated by Susanne Moog over 8 years ago

  • Target version changed from 7.4 (Backend) to 7.5
Actions #5

Updated by Benni Mack over 8 years ago

  • Target version changed from 7.5 to 7 LTS
Actions #6

Updated by Riccardo De Contardi over 8 years ago

  • Category set to Categorization API
  • Target version changed from 7 LTS to Candidate for Major Version
Actions #7

Updated by Riccardo De Contardi over 5 years ago

  • Status changed from New to Needs Feedback

Is this issue still present?

So far, I've discovered that at least the CategoryRegistry.php mentioned on comment 2 should be ok (TYPO3 9.5.2-dev (latest master), line 408):

 'foreign_table_where' => ' AND sys_category.sys_language_uid IN (-1, 0) ORDER BY sys_category.sorting ASC'
Actions #8

Updated by Riccardo De Contardi about 5 years ago

  • Status changed from Needs Feedback to Closed
  • Target version deleted (Candidate for Major Version)

No feedback since the last 90 days => closing this issue.

If you think that this is the wrong decision or experience the issue again and have more information about how to reproduce your problem, please reopen it or open a new issue with a reference to this one.

Thank you and best regards

Actions

Also available in: Atom PDF