Frontend Crash When Loading News with Main Category and Sub-Categories in TYPO3 V13 [news_pi1]

[HimanshuRamavat07]

Bug Report

Current Behavior
I've encountered an issue with the news listing on my site (Plugin -> News article list (incl. detail view) [news_pi1]).

The problem arises when I try to load a main category that contains numerous sub-categories. The frontend is crashing and fails to load. Here's a screenshot for the reference: https://i.imgur.com/4AbPVH9.png.

Below is the current configuration of the plugin:
categoryConjunction: or
includeSubCategories: true
All other settings are at their default values.

You can find the plugin settings screenshot here: https://i.imgur.com/WCVkYwm.png.

Environment

• TYPO3 version: 13.4.2
• news version: 12.2.0
• Is your TYPO3 installation set up with Composer (Composer Mode): yes
• OS: OSX 15.1.1

Additional context
With the same database and same news extension listing news is working fine In TYPO3 V12 .

[georgringer]

what if you start limitting the catagories - either by changing it directly in the repository or by limiting in the plugin or e.g. deleting for testing categories?

i am pretty sure this is sadly a core issue and not a news issue

[HimanshuRamavat07]

If I select all categories (parent and child) and disable the includeSubCategories option (screenshot: https://i.imgur.com/vgOoS78.png), it works. I could reconfigure the plugin by manually selecting categories, but unfortunately, it’s used in 95 places.

PS: I have not extended the news extension.

[georgringer]

thanks for your feedback. there needs to be kind of an error or maybe just a slowlog entry of the DB if logging is enabled but I fear I can't really do anything within the extension. A possible solution could be to use additional custom queries doing the heavy queries before and modify the original query to avoid the tons of joins

[lexwebmaker]

Hello

I have the same problem. I only have 1 main category with 31 subcategories

I debugged a little bit and found out that when you have more than 30 subcategories, it creates a constraint object (NewsRepository lines 73) that make it loops indefinitely in vendor/typo3/cms-extbase/Classes/Persistence/Generic/Storage/Typo3DbQueryParser.php line 219

My solution for now is to select each category and subcategory, and to unselect the option includeSubCategories in the plugin. But, of course, it's not a viable solution.