[BUG] More than 1000 expressions in a list are not allowed on Oracle.

[marcelklehr]

Describe the bug When displaying the tag list, nothing is displayed and the logs show

"More than 1000 expressions in a list are not allowed on Oracle."

Expected behavior Tags are displayed.

Screenshots None.

Versions:

• Nextcloud: 22.2.x
• Audioplayer 3.2.4

Nextcloud log

[core] Error: More than 1000 expressions in a list are not allowed on Oracle.

GET /apps/audioplayer/getcategoryitems?category=Tags

{"reqId":"xGsOOiNELIuLfOh2fDrV","level":3,"time":"2022-02-14T09:59:53+00:00","remoteAddr":"xx.xx.xxx.xxx","user":"marcel","app":"core","method":"GET","url":"/apps/audioplayer/getcategoryitems?category=Tags","message":"More than 1000 expressions in a list are not allowed on Oracle.","userAgent":"xxx","version":"22.2.3.0","exception":{"Exception":"Doctrine\\DBAL\\Query\\QueryException","Message":"More than 1000 expressions in a list are not allowed on Oracle.","Code":0,"Trace":[{"file":"/var/www/html/custom_apps/audioplayer/lib/Categories/Tag.php","line":75,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->","args":[]},{"file":"/var/www/html/custom_apps/audioplayer/lib/Categories/Tag.php","line":50,"function":"getTrackCount","class":"OCA\\audioplayer\\Categories\\Tag","type":"->","args":["19"]},{"file":"/var/www/html/custom_apps/audioplayer/lib/Controller/CategoryController.php","line":160,"function":"getCategoryItems","class":"OCA\\audioplayer\\Categories\\Tag","type":"->","args":[]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":217,"function":"getCategoryItems","class":"OCA\\audioplayer\\Controller\\CategoryController","type":"->","args":["Tags"]},{"file":"/var/www/html/lib/private/AppFramework/Http/Dispatcher.php","line":126,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\audioplayer\\Controller\\CategoryController"},"getCategoryItems"]},{"file":"/var/www/html/lib/private/AppFramework/App.php","line":156,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->","args":[{"__class__":"OCA\\audioplayer\\Controller\\CategoryController"},"getCategoryItems"]},{"file":"/var/www/html/lib/private/Route/Router.php","line":302,"function":"main","class":"OC\\AppFramework\\App","type":"::","args":["OCA\\audioplayer\\Controller\\CategoryController","getCategoryItems",{"__class__":"OC\\AppFramework\\DependencyInjection\\DIContainer"},{"_route":"audioplayer.category.getCategoryItems"}]},{"file":"/var/www/html/lib/base.php","line":1006,"function":"match","class":"OC\\Route\\Router","type":"->","args":["/apps/audioplayer/getcategoryitems"]},{"file":"/var/www/html/index.php","line":36,"function":"handleRequest","class":"OC","type":"::","args":[]}],"File":"/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php","Line":268,"CustomMessage":"More than 1000 expressions in a list are not allowed on Oracle."},"id":"620a2ea8aaf04"}

[Rello]

3.3.0 released