{"reqId":"jNiz3jh6ShDfGaSx7cAX","level":3,"time":"2025-08-03T23:02:06-04:00","remoteAddr":"163.123.168.69","user":"solonovamax","app":"no app in context","method":"GET","url":"/ocs/v2.php/search/providers/audioplayer/search?term=test&from=%2Fsettings%2Fadmin%2Flogging","message":"An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'name`)` LIKE '%test%') AND (`user_id` = 'solonovamax')' at line 1","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:142.0) Gecko/20100101 Firefox/142.0","version":"31.0.7.1","exception":{"Exception":"Doctrine\\DBAL\\Exception\\SyntaxErrorException","Message":"An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'name`)` LIKE '%test%') AND (`user_id` = 'solonovamax')' at line 1","Code":1064,"Trace":[{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1976,"function":"convert","class":"Doctrine\\DBAL\\Driver\\API\\MySQL\\ExceptionConverter","type":"->"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1918,"function":"handleDriverException","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1111,"function":"convertExceptionDuringQuery","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/Connection.php","line":419,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":289,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":266,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/apps/audioplayer/lib/Db/DbMapper.php","line":77,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/apps/audioplayer/lib/Search/Provider.php","line":52,"function":"search","class":"OCA\\audioplayer\\Db\\DbMapper","type":"->"},{"file":"/var/www/nextcloud/lib/private/Search/SearchComposer.php","line":352,"function":"search","class":"OCA\\audioplayer\\Search\\Provider","type":"->"},{"file":"/var/www/nextcloud/core/Controller/UnifiedSearchController.php","line":105,"function":"search","class":"OC\\Search\\SearchComposer","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":200,"function":"search","class":"OC\\Core\\Controller\\UnifiedSearchController","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":114,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/App.php","line":161,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/Route/Router.php","line":315,"function":"main","class":"OC\\AppFramework\\App","type":"::"},{"file":"/var/www/nextcloud/ocs/v1.php","line":49,"function":"match","class":"OC\\Route\\Router","type":"->"},{"file":"/var/www/nextcloud/ocs/v2.php","line":7,"args":["/var/www/nextcloud/ocs/v1.php"],"function":"require_once"}],"File":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/API/MySQL/ExceptionConverter.php","Line":86,"Previous":{"Exception":"Doctrine\\DBAL\\Driver\\PDO\\Exception","Message":"SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'name`)` LIKE '%test%') AND (`user_id` = 'solonovamax')' at line 1","Code":1064,"Trace":[{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":132,"function":"new","class":"Doctrine\\DBAL\\Driver\\PDO\\Exception","type":"::"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1104,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/Connection.php","line":419,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":289,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":266,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/apps/audioplayer/lib/Db/DbMapper.php","line":77,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/apps/audioplayer/lib/Search/Provider.php","line":52,"function":"search","class":"OCA\\audioplayer\\Db\\DbMapper","type":"->"},{"file":"/var/www/nextcloud/lib/private/Search/SearchComposer.php","line":352,"function":"search","class":"OCA\\audioplayer\\Search\\Provider","type":"->"},{"file":"/var/www/nextcloud/core/Controller/UnifiedSearchController.php","line":105,"function":"search","class":"OC\\Search\\SearchComposer","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":200,"function":"search","class":"OC\\Core\\Controller\\UnifiedSearchController","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":114,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/App.php","line":161,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/Route/Router.php","line":315,"function":"main","class":"OC\\AppFramework\\App","type":"::"},{"file":"/var/www/nextcloud/ocs/v1.php","line":49,"function":"match","class":"OC\\Route\\Router","type":"->"},{"file":"/var/www/nextcloud/ocs/v2.php","line":7,"args":["/var/www/nextcloud/ocs/v1.php"],"function":"require_once"}],"File":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php","Line":24,"Previous":{"Exception":"PDOException","Message":"SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'name`)` LIKE '%test%') AND (`user_id` = 'solonovamax')' at line 1","Code":"42000","Trace":[{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","line":130,"function":"execute","class":"PDOStatement","type":"->"},{"file":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Connection.php","line":1104,"function":"execute","class":"Doctrine\\DBAL\\Driver\\PDO\\Statement","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/Connection.php","line":419,"function":"executeQuery","class":"Doctrine\\DBAL\\Connection","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/ConnectionAdapter.php","line":50,"function":"executeQuery","class":"OC\\DB\\Connection","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":289,"function":"executeQuery","class":"OC\\DB\\ConnectionAdapter","type":"->"},{"file":"/var/www/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php","line":266,"function":"executeQuery","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/apps/audioplayer/lib/Db/DbMapper.php","line":77,"function":"execute","class":"OC\\DB\\QueryBuilder\\QueryBuilder","type":"->"},{"file":"/var/www/nextcloud/apps/audioplayer/lib/Search/Provider.php","line":52,"function":"search","class":"OCA\\audioplayer\\Db\\DbMapper","type":"->"},{"file":"/var/www/nextcloud/lib/private/Search/SearchComposer.php","line":352,"function":"search","class":"OCA\\audioplayer\\Search\\Provider","type":"->"},{"file":"/var/www/nextcloud/core/Controller/UnifiedSearchController.php","line":105,"function":"search","class":"OC\\Search\\SearchComposer","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":200,"function":"search","class":"OC\\Core\\Controller\\UnifiedSearchController","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":114,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/App.php","line":161,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/Route/Router.php","line":315,"function":"main","class":"OC\\AppFramework\\App","type":"::"},{"file":"/var/www/nextcloud/ocs/v1.php","line":49,"function":"match","class":"OC\\Route\\Router","type":"->"},{"file":"/var/www/nextcloud/ocs/v2.php","line":7,"args":["/var/www/nextcloud/ocs/v1.php"],"function":"require_once"}],"File":"/var/www/nextcloud/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php","Line":130}},"message":"An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'name`)` LIKE '%test%') AND (`user_id` = 'solonovamax')' at line 1","exception":[],"CustomMessage":"An exception occurred while executing a query: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'name`)` LIKE '%test%') AND (`user_id` = 'solonovamax')' at line 1"},"id":"689022b2a06a6"}
{"reqId":"md5j2n1N4bBe9n48q8mF","level":2,"time":"2025-08-03T23:02:06-04:00","remoteAddr":"163.123.168.69","user":"solonovamax","app":"files_fulltextsearch","method":"GET","url":"/ocs/v2.php/search/providers/fulltextsearch/search?term=test&from=%2Fsettings%2Fadmin%2Flogging","message":"Exception while improving searchresult","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:142.0) Gecko/20100101 Firefox/142.0","version":"31.0.7.1","exception":{"Exception":"OCA\\Files_FullTextSearch\\Exceptions\\FilesNotFoundException","Message":"","Code":0,"Trace":[{"file":"/var/www/nextcloud/apps/files_fulltextsearch/lib/Service/SearchService.php","line":211,"function":"getFileFromId","class":"OCA\\Files_FullTextSearch\\Service\\FilesService","type":"->"},{"file":"/var/www/nextcloud/apps/files_fulltextsearch/lib/Service/SearchService.php","line":174,"function":"setDocumentInfo","class":"OCA\\Files_FullTextSearch\\Service\\SearchService","type":"->"},{"file":"/var/www/nextcloud/apps/files_fulltextsearch/lib/Provider/FilesProvider.php","line":299,"function":"improveSearchResult","class":"OCA\\Files_FullTextSearch\\Service\\SearchService","type":"->"},{"file":"/var/www/nextcloud/apps/fulltextsearch/lib/Service/SearchService.php","line":123,"function":"improveSearchResult","class":"OCA\\Files_FullTextSearch\\Provider\\FilesProvider","type":"->"},{"file":"/var/www/nextcloud/apps/fulltextsearch/lib/Service/SearchService.php","line":84,"function":"searchFromProviders","class":"OCA\\FullTextSearch\\Service\\SearchService","type":"->"},{"file":"/var/www/nextcloud/apps/fulltextsearch/lib/Search/UnifiedSearchProvider.php","line":84,"function":"search","class":"OCA\\FullTextSearch\\Service\\SearchService","type":"->"},{"file":"/var/www/nextcloud/lib/private/Search/SearchComposer.php","line":352,"function":"search","class":"OCA\\FullTextSearch\\Search\\UnifiedSearchProvider","type":"->"},{"file":"/var/www/nextcloud/core/Controller/UnifiedSearchController.php","line":105,"function":"search","class":"OC\\Search\\SearchComposer","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":200,"function":"search","class":"OC\\Core\\Controller\\UnifiedSearchController","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":114,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/App.php","line":161,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/Route/Router.php","line":315,"function":"main","class":"OC\\AppFramework\\App","type":"::"},{"file":"/var/www/nextcloud/ocs/v1.php","line":49,"function":"match","class":"OC\\Route\\Router","type":"->"},{"file":"/var/www/nextcloud/ocs/v2.php","line":7,"args":["/var/www/nextcloud/ocs/v1.php"],"function":"require_once"}],"File":"/var/www/nextcloud/apps/files_fulltextsearch/lib/Service/FilesService.php","Line":450,"message":"Exception while improving searchresult","exception":[],"CustomMessage":"Exception while improving searchresult"},"id":"689022b2a0637"}
{"reqId":"md5j2n1N4bBe9n48q8mF","level":2,"time":"2025-08-03T23:02:06-04:00","remoteAddr":"163.123.168.69","user":"solonovamax","app":"files_fulltextsearch","method":"GET","url":"/ocs/v2.php/search/providers/fulltextsearch/search?term=test&from=%2Fsettings%2Fadmin%2Flogging","message":"Exception while improving searchresult","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:142.0) Gecko/20100101 Firefox/142.0","version":"31.0.7.1","exception":{"Exception":"OCA\\Files_FullTextSearch\\Exceptions\\FilesNotFoundException","Message":"","Code":0,"Trace":[{"file":"/var/www/nextcloud/apps/files_fulltextsearch/lib/Service/SearchService.php","line":211,"function":"getFileFromId","class":"OCA\\Files_FullTextSearch\\Service\\FilesService","type":"->"},{"file":"/var/www/nextcloud/apps/files_fulltextsearch/lib/Service/SearchService.php","line":174,"function":"setDocumentInfo","class":"OCA\\Files_FullTextSearch\\Service\\SearchService","type":"->"},{"file":"/var/www/nextcloud/apps/files_fulltextsearch/lib/Provider/FilesProvider.php","line":299,"function":"improveSearchResult","class":"OCA\\Files_FullTextSearch\\Service\\SearchService","type":"->"},{"file":"/var/www/nextcloud/apps/fulltextsearch/lib/Service/SearchService.php","line":123,"function":"improveSearchResult","class":"OCA\\Files_FullTextSearch\\Provider\\FilesProvider","type":"->"},{"file":"/var/www/nextcloud/apps/fulltextsearch/lib/Service/SearchService.php","line":84,"function":"searchFromProviders","class":"OCA\\FullTextSearch\\Service\\SearchService","type":"->"},{"file":"/var/www/nextcloud/apps/fulltextsearch/lib/Search/UnifiedSearchProvider.php","line":84,"function":"search","class":"OCA\\FullTextSearch\\Service\\SearchService","type":"->"},{"file":"/var/www/nextcloud/lib/private/Search/SearchComposer.php","line":352,"function":"search","class":"OCA\\FullTextSearch\\Search\\UnifiedSearchProvider","type":"->"},{"file":"/var/www/nextcloud/core/Controller/UnifiedSearchController.php","line":105,"function":"search","class":"OC\\Search\\SearchComposer","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":200,"function":"search","class":"OC\\Core\\Controller\\UnifiedSearchController","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":114,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/App.php","line":161,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/Route/Router.php","line":315,"function":"main","class":"OC\\AppFramework\\App","type":"::"},{"file":"/var/www/nextcloud/ocs/v1.php","line":49,"function":"match","class":"OC\\Route\\Router","type":"->"},{"file":"/var/www/nextcloud/ocs/v2.php","line":7,"args":["/var/www/nextcloud/ocs/v1.php"],"function":"require_once"}],"File":"/var/www/nextcloud/apps/files_fulltextsearch/lib/Service/FilesService.php","Line":450,"message":"Exception while improving searchresult","exception":[],"CustomMessage":"Exception while improving searchresult"},"id":"689022b2a0611"}
{"reqId":"md5j2n1N4bBe9n48q8mF","level":2,"time":"2025-08-03T23:02:06-04:00","remoteAddr":"163.123.168.69","user":"solonovamax","app":"files_fulltextsearch","method":"GET","url":"/ocs/v2.php/search/providers/fulltextsearch/search?term=test&from=%2Fsettings%2Fadmin%2Flogging","message":"Exception while improving searchresult","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:142.0) Gecko/20100101 Firefox/142.0","version":"31.0.7.1","exception":{"Exception":"OCA\\Files_FullTextSearch\\Exceptions\\FilesNotFoundException","Message":"","Code":0,"Trace":[{"file":"/var/www/nextcloud/apps/files_fulltextsearch/lib/Service/SearchService.php","line":211,"function":"getFileFromId","class":"OCA\\Files_FullTextSearch\\Service\\FilesService","type":"->"},{"file":"/var/www/nextcloud/apps/files_fulltextsearch/lib/Service/SearchService.php","line":174,"function":"setDocumentInfo","class":"OCA\\Files_FullTextSearch\\Service\\SearchService","type":"->"},{"file":"/var/www/nextcloud/apps/files_fulltextsearch/lib/Provider/FilesProvider.php","line":299,"function":"improveSearchResult","class":"OCA\\Files_FullTextSearch\\Service\\SearchService","type":"->"},{"file":"/var/www/nextcloud/apps/fulltextsearch/lib/Service/SearchService.php","line":123,"function":"improveSearchResult","class":"OCA\\Files_FullTextSearch\\Provider\\FilesProvider","type":"->"},{"file":"/var/www/nextcloud/apps/fulltextsearch/lib/Service/SearchService.php","line":84,"function":"searchFromProviders","class":"OCA\\FullTextSearch\\Service\\SearchService","type":"->"},{"file":"/var/www/nextcloud/apps/fulltextsearch/lib/Search/UnifiedSearchProvider.php","line":84,"function":"search","class":"OCA\\FullTextSearch\\Service\\SearchService","type":"->"},{"file":"/var/www/nextcloud/lib/private/Search/SearchComposer.php","line":352,"function":"search","class":"OCA\\FullTextSearch\\Search\\UnifiedSearchProvider","type":"->"},{"file":"/var/www/nextcloud/core/Controller/UnifiedSearchController.php","line":105,"function":"search","class":"OC\\Search\\SearchComposer","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":200,"function":"search","class":"OC\\Core\\Controller\\UnifiedSearchController","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":114,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/App.php","line":161,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/Route/Router.php","line":315,"function":"main","class":"OC\\AppFramework\\App","type":"::"},{"file":"/var/www/nextcloud/ocs/v1.php","line":49,"function":"match","class":"OC\\Route\\Router","type":"->"},{"file":"/var/www/nextcloud/ocs/v2.php","line":7,"args":["/var/www/nextcloud/ocs/v1.php"],"function":"require_once"}],"File":"/var/www/nextcloud/apps/files_fulltextsearch/lib/Service/FilesService.php","Line":450,"message":"Exception while improving searchresult","exception":[],"CustomMessage":"Exception while improving searchresult"},"id":"689022b2a05ea"}
{"reqId":"md5j2n1N4bBe9n48q8mF","level":2,"time":"2025-08-03T23:02:06-04:00","remoteAddr":"163.123.168.69","user":"solonovamax","app":"files_fulltextsearch","method":"GET","url":"/ocs/v2.php/search/providers/fulltextsearch/search?term=test&from=%2Fsettings%2Fadmin%2Flogging","message":"Exception while improving searchresult","userAgent":"Mozilla/5.0 (X11; Linux x86_64; rv:142.0) Gecko/20100101 Firefox/142.0","version":"31.0.7.1","exception":{"Exception":"OCA\\Files_FullTextSearch\\Exceptions\\FilesNotFoundException","Message":"","Code":0,"Trace":[{"file":"/var/www/nextcloud/apps/files_fulltextsearch/lib/Service/SearchService.php","line":211,"function":"getFileFromId","class":"OCA\\Files_FullTextSearch\\Service\\FilesService","type":"->"},{"file":"/var/www/nextcloud/apps/files_fulltextsearch/lib/Service/SearchService.php","line":174,"function":"setDocumentInfo","class":"OCA\\Files_FullTextSearch\\Service\\SearchService","type":"->"},{"file":"/var/www/nextcloud/apps/files_fulltextsearch/lib/Provider/FilesProvider.php","line":299,"function":"improveSearchResult","class":"OCA\\Files_FullTextSearch\\Service\\SearchService","type":"->"},{"file":"/var/www/nextcloud/apps/fulltextsearch/lib/Service/SearchService.php","line":123,"function":"improveSearchResult","class":"OCA\\Files_FullTextSearch\\Provider\\FilesProvider","type":"->"},{"file":"/var/www/nextcloud/apps/fulltextsearch/lib/Service/SearchService.php","line":84,"function":"searchFromProviders","class":"OCA\\FullTextSearch\\Service\\SearchService","type":"->"},{"file":"/var/www/nextcloud/apps/fulltextsearch/lib/Search/UnifiedSearchProvider.php","line":84,"function":"search","class":"OCA\\FullTextSearch\\Service\\SearchService","type":"->"},{"file":"/var/www/nextcloud/lib/private/Search/SearchComposer.php","line":352,"function":"search","class":"OCA\\FullTextSearch\\Search\\UnifiedSearchProvider","type":"->"},{"file":"/var/www/nextcloud/core/Controller/UnifiedSearchController.php","line":105,"function":"search","class":"OC\\Search\\SearchComposer","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":200,"function":"search","class":"OC\\Core\\Controller\\UnifiedSearchController","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php","line":114,"function":"executeController","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/AppFramework/App.php","line":161,"function":"dispatch","class":"OC\\AppFramework\\Http\\Dispatcher","type":"->"},{"file":"/var/www/nextcloud/lib/private/Route/Router.php","line":315,"function":"main","class":"OC\\AppFramework\\App","type":"::"},{"file":"/var/www/nextcloud/ocs/v1.php","line":49,"function":"match","class":"OC\\Route\\Router","type":"->"},{"file":"/var/www/nextcloud/ocs/v2.php","line":7,"args":["/var/www/nextcloud/ocs/v1.php"],"function":"require_once"}],"File":"/var/www/nextcloud/apps/files_fulltextsearch/lib/Service/FilesService.php","Line":450,"message":"Exception while improving searchresult","exception":[],"CustomMessage":"Exception while improving searchresult"},"id":"689022b2a05b3"}
How to use GitHub
Steps to reproduce
Expected behaviour
Search works.
Actual behaviour
Search does not work, errors are present in logs.
Server configuration
Web server: Apache
Database: MariaDB
PHP version: 8.3.11
Nextcloud version: 31.0.7.1
for my search backend, I'm using elasticsearch 8.19.0.
List of activated apps
Enabled:
Disabled:
Nextcloud configuration
{ "system": { "instanceid": "***REMOVED SENSITIVE VALUE***", "passwordsalt": "***REMOVED SENSITIVE VALUE***", "trusted_domains": [ "nextcloud.solonovamax.gay", "nextcloud.solonovamax.ca", "86.48.27.44" ], "datadirectory": "***REMOVED SENSITIVE VALUE***", "version": "31.0.7.1", "dbtype": "mysql", "dbhost": "***REMOVED SENSITIVE VALUE***", "dbname": "***REMOVED SENSITIVE VALUE***", "dbuser": "***REMOVED SENSITIVE VALUE***", "dbpassword": "***REMOVED SENSITIVE VALUE***", "dbtableprefix": "oc_", "installed": true, "default_language": "en", "force_language": false, "default_locale": "en_US", "default_phone_region": "CA", "force_locale": false, "defaultapp": "dashboard,files", "knowledgebaseenabled": true, "allow_user_to_change_display_name": true, "remember_login_cookie_lifetime": 1296000, "session_lifetime": 86400, "session_relaxed_expiry": true, "session_keepalive": true, "auto_logout": false, "token_auth_enforced": false, "token_auth_activity_update": 300, "auth.bruteforce.protection.enabled": true, "auth.webauthn.enabled": true, "twofactor_enforced": false, "twofactor_enforced_groups": [ "admin" ], "twofactor_enforced_excluded_groups": [], "auth.storeCryptedPassword": true, "hide_login_form": false, "skeletondirectory": "\/var\/www\/nextcloud\/data\/skeleton", "overwriteprotocol": "https", "overwritehost": "nextcloud.solonovamax.gay", "overwritewebroot": "\/", "overwrite.cli.url": "https:\/\/nextcloud.solonovamax.gay\/", "htaccess.RewriteBase": "\/", "htaccess.IgnoreFrontController": false, "trashbin_retention_obligation": "auto", "versions_retention_obligation": "auto", "appcodechecker": true, "updatechecker": true, "updater.server.url": "***REMOVED SENSITIVE VALUE***", "updater.release.channel": "stable", "has_internet_connection": true, "connectivity_check_domains": [ "www.nextcloud.com", "www.startpage.com", "www.eff.org", "www.edri.org" ], "check_for_working_wellknown_setup": true, "check_for_working_htaccess": true, "check_data_directory_permissions": true, "config_is_read_only": false, "log_type": "file", "log_type_audit": "file", "logfile": "\/var\/log\/nextcloud\/nextcloud.log", "logfile_audit": "\/var\/log\/nextcloud\/audit.log", "logfilemode": 416, "loglevel": 2, "loglevel_frontend": 2, "syslog_tag": "Nextcloud", "syslog_tag_audit": "Nextcloud", "logdateformat": "F d, Y H:i:s", "logtimezone": "America\/Toronto", "log_query": true, "log_rotate_size": 104857600, "profiler": false, "customclient_desktop": "https:\/\/nextcloud.com\/install\/#install-clients", "customclient_android": "https:\/\/play.google.com\/store\/apps\/details?id=com.nextcloud.client", "customclient_ios": "https:\/\/itunes.apple.com\/us\/app\/nextcloud\/id1125420102?mt=8", "customclient_ios_appid": "1125420102", "appstoreenabled": true, "appstoreurl": "https:\/\/apps.nextcloud.com\/api\/v1", "apps_paths": [ { "path": "\/var\/www\/nextcloud\/apps", "url": "\/apps", "writable": true } ], "enable_previews": true, "preview_format": "webp", "preview_concurrency_all": 4, "preview_concurrency_new": 2, "preview_max_x": 4096, "preview_max_y": 4096, "preview_max_filesize_image": 128, "preview_max_memory": 512, "preview_libreoffice_path": "\/usr\/bin\/libreoffice", "preview_imaginary_url": "***REMOVED SENSITIVE VALUE***", "preview_ffmpeg_path": "\/usr\/bin\/ffmpeg", "enabledPreviewProviders": [ "OC\\Preview\\Imaginary", "OC\\Preview\\ImaginaryPDF", "OC\\Preview\\Movie", "OC\\Preview\\MP4", "OC\\Preview\\TXT", "OC\\Preview\\MarkDown", "OC\\Preview\\PDF", "OC\\Preview\\OpenDocument", "OC\\Preview\\Office", "OC\\Preview\\MSOffice2007", "OC\\Preview\\MSOffice2003", "OC\\Preview\\MSOfficeDoc", "OC\\Preview\\EMF", "OC\\Preview\\StarOffice", "OC\\Preview\\Illustrator", "OC\\Preview\\Photoshop", "OC\\Preview\\Postscript", "OC\\Preview\\Krita", "OC\\Preview\\Font", "OC\\Preview\\TIFF", "OC\\Preview\\HEIC", "OC\\Preview\\WebP", "OC\\Preview\\JPEG", "OC\\Preview\\PNG", "OC\\Preview\\GIF", "OC\\Preview\\SVG", "OC\\Preview\\BMP", "OC\\Preview\\XBitmap", "OC\\Preview\\TGA", "OC\\Preview\\SGI", "OC\\Preview\\Image" ], "maintenance": false, "maintenance_window_start": 1, "memcache.local": "\\OC\\Memcache\\APCu", "memcache.locking": "\\OC\\Memcache\\Redis", "redis": { "host": "***REMOVED SENSITIVE VALUE***", "port": 0, "timeout": 0, "read_timeout": 100 }, "memcached_options": { "14": 50, "15": 50, "19": 50, "20": 50, "8": 50, "-1001": true, "16": true, "18": true }, "cache_chunk_gc_ttl": 86400, "sharing.enable_share_accept": true, "mysql.utf8mb4": true, "share_folder": "\/Share\/", "theme": "", "cipher": "AES-256-CTR", "secret": "***REMOVED SENSITIVE VALUE***", "trusted_proxies": "***REMOVED SENSITIVE VALUE***", "forwarded_for_headers": [ "HTTP_X_FORWARDED", "HTTP_FORWARDED_FOR", "HTTP_X_FORWARDED_FOR", "HTTP_X_REAL_IP" ], "max_filesize_animated_gifs_public_sharing": 10, "filelocking.enabled": true, "filelocking.ttl": 7200, "filelocking.debug": false, "enable_file_metadata": true, "app_install_overwrite": [ "files_trackdownloads", "epubreader", "mindmap_app", "pdfdraw", "ocsms", "occweb", "files_markdown", "impersonate", "files_readmemd", "duplicatefinder", "apporder", "breezedark", "files_downloadactivity", "carnet", "workflow_media_converter", "google_synchronization", "libresign", "messagevault", "timetracker", "weather", "files_fulltextsearch_tesseract", "files_texteditor", "files_rightclick", "sharingpath", "richdocuments", "integration_moodle", "health" ], "mail_smtpmode": "smtp", "mail_sendmailmode": "smtp", "mail_smtpauthtype": "PLAIN", "mail_smtphost": "***REMOVED SENSITIVE VALUE***", "mail_smtpport": "1025", "mail_smtpauth": 1, "mail_smtpname": "***REMOVED SENSITIVE VALUE***", "mail_smtppassword": "***REMOVED SENSITIVE VALUE***", "mail_domain": "***REMOVED SENSITIVE VALUE***", "mail_from_address": "***REMOVED SENSITIVE VALUE***", "memories.exiftool": "\/usr\/bin\/exiftool", "has_rebuilt_cache": true, "memories.vod.path": "\/var\/www\/nextcloud\/apps\/memories\/bin-ext\/go-vod-amd64", "memories.vod.ffmpeg": "\/usr\/bin\/ffmpeg", "memories.vod.ffprobe": "\/usr\/bin\/ffprobe", "activity_expire_days": 90, "debug": false, "allow_local_remote_servers": true, "memories.vod.disable": false, "memories.db.triggers.fcu": true, "memories.gis_type": 1, "memories.timeline.default_path": "_empty_", "memories.viewer.high_res_cond_default": "zoom", "memories.vod.vaapi": false, "memories.vod.vaapi.low_power": false, "memories.exiftool_no_local": true } }Browser
Browser name: Firefox
Browser version: 142.0b5
Operating system: Arch Linux 6.15.8-arch1-2 x86_64
Browser log
In the network requests, you can see that a request to
https://nextcloud.solonovamax.gay/ocs/v2.php/search/providers/fulltextsearch/search?term=test&from=/settings/admin/overviewis made when searching.the result of this request is:
{ "ocs": { "meta": { "status": "ok", "statuscode": 200, "message": "OK" }, "data": { "name": "Full Text Search", "isPaginated": true, "entries": [], "cursor": 5 } } }even though there are definitely results which match this query.
Server log (data/nextcloud.log)
Details