nextcloud / nextcloud/files_fulltextsearch

Search completely broken

Open
#327 1 comment 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

0. Needs triage bug
Dominant language
PHP
Stars
72
Forks
41
Avg merge
1d 3h
Merged PRs (30d)
9

Description

How to use GitHub
  • Please use the 👍 reaction to show that you are affected by the same issue.
  • Please don't comment if you have no relevant information to add. It's just extra noise for everyone subscribed to this issue.
  • Subscribe to receive notifications on status change and new comments.
Steps to reproduce
  1. Search for something
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:

  • activity: 4.0.0
  • admin_audit: 1.21.0
  • analytics: 5.8.0
  • announcementcenter: 7.1.4
  • app_api: 5.0.2
  • apporder: 0.15.0
  • audioplayer: 3.5.1
  • breezedark: 29.0.0
  • bruteforcesettings: 4.0.0
  • calendar: 5.3.8
  • camerarawpreviews: 0.8.7
  • cfg_share_links: 7.0.1
  • checksum: 1.2.6
  • circles: 31.0.0
  • cloud_federation_api: 1.14.0
  • comments: 1.21.0
  • contacts: 7.2.3
  • contactsinteraction: 1.12.0
  • cookbook: 0.11.3
  • dashboard: 7.11.0
  • dav: 1.33.0
  • dav_push: 0.0.3
  • deck: 1.15.2
  • external: 6.0.2
  • facerecognition: 0.9.70
  • federatedfilesharing: 1.21.0
  • files: 2.3.1
  • files_automatedtagging: 2.0.0
  • files_downloadactivity: 1.18.1
  • files_downloadlimit: 4.0.0
  • files_external: 1.23.0
  • files_fulltextsearch: 31.0.0
  • files_fulltextsearch_tesseract: 27.0.1
  • files_markdown: 2.4.1
  • files_pdfviewer: 4.0.0
  • files_readmemd: 3.0.2
  • files_reminders: 1.4.0
  • files_sharing: 1.23.1
  • files_texteditor: 2.15.1
  • files_trashbin: 1.21.0
  • files_versions: 1.24.0
  • fileslibreofficeedit: 2.0.1
  • firstrunwizard: 4.0.0
  • flow_notifications: 2.0.1
  • fulltextsearch: 31.0.0
  • fulltextsearch_elasticsearch: 31.0.0
  • group_default_quota: 0.1.11
  • group_everyone: 0.1.17
  • groupfolders: 19.1.3
  • groupquota: 0.2.2
  • guests: 4.3.0
  • health: 2.2.2
  • imageconverter: 2.0.5
  • impersonate: 2.0.0
  • integration_github: 3.2.1
  • integration_gitlab: 3.2.0
  • integration_google: 4.1.0
  • integration_mastodon: 3.1.1
  • integration_moodle: 1.0.2
  • logreader: 4.0.0
  • lookup_server_connector: 1.19.0
  • maps: 1.6.0
  • memories: 7.6.1
  • messagevault: 1.0.3
  • metadata: 0.22.0
  • music: 2.2.0
  • news: 26.1.0
  • nextcloud_announcements: 3.0.0
  • notes: 4.12.2
  • notifications: 4.0.0
  • notify_push: 1.1.0
  • oauth2: 1.19.1
  • occweb: 0.2.3
  • onlyoffice: 9.9.0
  • password_policy: 3.0.0
  • phonetrack: 0.8.2
  • photos: 4.0.0
  • previewgenerator: 5.9.0
  • privacy: 3.0.0
  • profile: 1.0.0
  • provisioning_api: 1.21.0
  • quota_warning: 1.21.0
  • recognize: 9.0.3
  • recommendations: 4.0.0
  • related_resources: 2.0.0
  • secrets: 2.1.2
  • serverinfo: 3.0.0
  • settings: 1.14.0
  • sharingpath: 0.4.4
  • side_menu: 5.1.1
  • spreed: 21.1.2
  • suspicious_login: 9.0.1
  • systemtags: 1.21.1
  • tables: 0.9.5
  • tasks: 0.16.1
  • text: 5.0.0
  • theming: 2.6.1
  • theming_customcss: 1.18.0
  • thesearchpage: 1.2.12
  • timemanager: 0.3.18
  • timetracker: 0.0.85
  • twofactor_admin: 4.8.0
  • twofactor_backupcodes: 1.20.0
  • twofactor_nextcloud_notification: 5.0.0
  • twofactor_totp: 13.0.0-dev.0
  • updatenotification: 1.21.0
  • uppush: 2.3.0
  • user_status: 1.11.0
  • user_usage_report: 2.0.0
  • viewer: 4.0.0
  • weather: 1.7.7
  • weather_status: 1.11.0
  • webhook_listeners: 1.2.0
  • welcome: 1.3.0
  • workflow_media_converter: 1.15.1
  • workflow_ocr: 1.31.2
  • workflow_pdf_converter: 2.0.0
  • workflow_script: 2.0.0
  • workflowengine: 2.13.0
    Disabled:
  • assistant: 2.5.0 (installed 2.5.0)
  • carnet: 0.25.6 (installed 0.25.6)
  • collectives: 3.0.3 (installed 3.0.3)
  • cospend: 3.0.11 (installed 3.0.11)
  • drawio: 3.1.0 (installed 3.1.0)
  • duplicatefinder: 1.7.3 (installed 1.7.3)
  • electronicsignatures: 3.0.5 (installed 3.0.5)
  • encryption: 2.19.0 (installed 2.19.0)
  • end_to_end_encryption: 1.17.0 (installed 1.17.0)
  • epubreader: 1.4.7 (installed 1.4.7)
  • extract: 1.3.6 (installed 1.3.6)
  • federation: 1.21.0 (installed 1.17.0)
  • files_accesscontrol: 2.0.0 (installed 2.0.0)
  • files_antivirus: 6.0.2 (installed 6.0.2)
  • files_archive: 1.2.7 (installed 1.2.7)
  • files_mindmap: 0.0.33 (installed 0.0.33)
  • files_rightclick: 0.15.1 (installed 0.15.1)
  • files_scripts: 4.1.0 (installed 4.1.0)
  • files_trackdownloads: 1.11.0 (installed 1.11.0)
  • files_zip: 2.1.0 (installed 2.1.0)
  • flowupload: 1.1.3 (installed 1.1.3)
  • forms: 5.1.2 (installed 5.1.2)
  • google_synchronization: 3.2.0 (installed 3.2.0)
  • hsts: 0.9.0 (installed 0.9.0)
  • integration_openai: 3.7.1 (installed 3.7.1)
  • integration_reddit: 2.1.0 (installed 2.1.0)
  • integration_twitter: 1.0.7 (installed 1.0.7)
  • libresign: 11.2.5 (installed 11.2.5)
  • mediadc: 0.4.0 (installed 0.4.0)
  • money: 0.30.0 (installed 0.30.0)
  • ncdownloader: 1.0.23 (installed 1.0.23)
  • ocdownloader: 1.9.1 (installed 1.9.1)
  • ocsms: 2.2.0 (installed 2.2.0)
  • officeonline: 3.1.0 (installed 3.1.0)
  • pride_flags: 1.1.2 (installed 1.1.2)
  • profiler: 1.6.0 (installed 1.6.0)
  • ransomware_protection: 1.14.0 (installed 1.14.0)
  • richdocuments: 8.7.3 (installed 8.7.3)
  • riotchat: 0.19.0 (installed 0.19.0)
  • root_cache_cleaner: 0.1.8 (installed 0.1.8)
  • sharebymail: 1.21.0 (installed 1.17.0)
  • socialsharing_email: 3.3.0 (installed 3.3.0)
  • storj: 0.0.9 (installed 0.0.9)
  • support: 3.0.0 (installed 1.10.0)
  • survey_client: 3.0.0 (installed 1.15.0)
  • twofactor_gateway: 0.20.0 (installed 0.20.0)
  • unsplash: 3.1.0 (installed 3.1.0)
  • user_ldap: 1.22.0 (installed 1.17.0)
  • video_converter: 1.0.6 (installed 1.0.6)
  • webhooks: 0.4.3 (installed 0.4.3)
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/overview is 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)
{"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"}

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by reproducing a search failure with the enabled fulltextsearch and fulltextsearch_elasticsearch apps, then inspect the reported server logs and Elasticsearch configuration. Done means searches work without the logged errors on the reported Nextcloud, PHP, Apache, MariaDB, and Elasticsearch setup.

Written by the indexing model from the issue text.

Assessment

Tech stack
apache, elasticsearch, mariadb, php
Domain
backend, search
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
20/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.