Project

General

Profile

Actions

Bug #89474

open

Categories: Database not updated if a item is assigned

Added by Ge Rie over 4 years ago. Updated over 4 years ago.

Status:
New
Priority:
Should have
Assignee:
-
Category:
Categorization API
Target version:
-
Start date:
2019-10-22
Due date:
% Done:

0%

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

Description

Hi,
I have noticed that the database is not updated if I assign items (pages or news item) to a category. Also if a item is deleted, the database (sys_category) isn’t updated.

I have tested this with news (tx_news) and pages.

  • Let's say we have created a news entry or page and assigned it to "category 1". After saving, the field "items" of the table "sys_category" should be set to "1" - but it isn’t.
  • If I go to the category in the backend, the item is assigned correctly to "category 1" as expected. I save the category with the assigned category and now the database is updated and the field "item" for "category 1" is set to "1".
  • If I delete the news item or page in the backend I'd expect the field "item" for "category 1" to be set to "0". But it isn't, it is still on "1". So I have to go to the category in the backend again. Open and save it. Then the database is updated correctly
Environment
  • TYPO3 9.5.10
  • PHP 7.2.10

Related issues 1 (1 open0 closed)

Related to TYPO3 Core - Bug #89097: Sys_category - field "items" on database gets updated only when reordering the "items"New2019-09-05

Actions
Actions #1

Updated by Ge Rie over 4 years ago

  • Category set to Categorization API
Actions #2

Updated by Christian Kuhn over 3 years ago

  • Related to Bug #89097: Sys_category - field "items" on database gets updated only when reordering the "items" added
Actions

Also available in: Atom PDF