Blog Post Categories Display Incorrectly After Upgrading from TYPO3 v11 to v12

[HimanshuRamavat07]

After upgrading from TYPO3 v11 to v12, blog post categories are not assigned correctly based on language.

In TYPO3 v12, German-language posts (language ID: 0) are showing English categories (language ID: 1).

V11 : sys_category_record_mm table (https://i.imgur.com/XPDJJZC.png)

V12 : sys_category_record_mm table (https://i.imgur.com/goJ5lnw.png)

Description

• In TYPO3 v12, when viewing a German-language blog post, the assigned categories appear to be from the English language instead of German in the frontend.
• However, if I manually edit the post, deselect the category, and reselect it, and save it the correct category is assigned to the blog post.

Steps to Reproduce

• After upgrading to TYPO3 v11 to v12
• In v11 blog is v12.0.2 and in v12 blog is 13.0.0

Expected behaviour: [What you expected to happen]

• English category should be visible in English language and German in the German language

Actual behaviour: [What actually happened]

• English category is visible in both English and German posts

Versions

TYPO3 V12

• TYPO3: 12.4.26
• Blog: 13.0.0

TYPO3 V11

• TYPO3: 11.5.41
• Blog: 12.0.2

P.S: If there is something wrong with our configuration, please let me know.

Best Regards Himanshu Ramavat