nextcloud / server

☁️ Nextcloud server, a safe home for all your data
https://nextcloud.com
GNU Affero General Public License v3.0
26.48k stars 3.98k forks source link

[Bug]: move shared folder: "Node for share not found" #46467

Open genestouxguy opened 1 month ago

genestouxguy commented 1 month ago

⚠️ This issue respects the following points: ⚠️

Bug description

When I move a shared folder, I got the following error in log :

SyntaxErrorException An exception occurred while executing a query: SQLSTATE[42601]: Syntax error: 7 ERROR: syntax error at or near ")" LINE 1: ...level" = $1) WHERE ("sh"."share_type" = $2) AND (()) AND ("s... ^ Exception thrown: Doctrine\DBAL\Exception\SyntaxErrorException

I got this error only for some shared folders. I got this message because I activated the teams app. Before the teams app activated, I got the error message in log :

NotFoundException Node for share not found, fileid: 13485

Steps to reproduce

  1. Share a folder with files to another user of your instance
  2. the other user move the shared folder in another folder

Expected behavior

the other user move the shared folder in another folder

Installation method

Community Docker image

Nextcloud Server version

29

Operating system

Debian/Ubuntu

PHP engine version

PHP 8.2

Web server

Nginx

Database engine version

PostgreSQL

Is this bug present after an update or on a fresh install?

Upgraded to a MAJOR version (ex. 28 to 29)

Are you using the Nextcloud Server Encryption module?

Encryption is Disabled

What user-backends are you using?

Configuration report

{
    "system": {
        "memcache.local": "\\OC\\Memcache\\APCu",
        "apps_paths": [
            {
                "path": "\/var\/www\/html\/apps",
                "url": "\/apps",
                "writable": false
            },
            {
                "path": "\/var\/www\/html\/custom_apps",
                "url": "\/custom_apps",
                "writable": true
            }
        ],
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "localhost",
            "nextcloud.example.com",
            "nginx-nextcloud"
        ],
        "trusted_proxies": "***REMOVED SENSITIVE VALUE***",
        "overwritehost": "nextcloud.example.com",
        "overwriteprotocol": "https",
        "overwritewebroot": "\/",
        "overwirtecondaddr": "^172\\.18\\.0\\.3$",
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "dbtype": "pgsql",
        "version": "29.0.3.4",
        "overwrite.cli.url": "https:\/\/nextcloud.example.com",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbport": "",
        "dbtableprefix": "oc_",
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "installed": true,
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "maintenance": false,
        "theme": "",
        "loglevel": 1,
        "ldapIgnoreNamingRules": false,
        "ldapProviderFactory": "OCA\\User_LDAP\\LDAPProviderFactory",
        "mail_smtpmode": "smtp",
        "mail_smtpsecure": "tls",
        "mail_sendmailmode": "smtp",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpauthtype": "LOGIN",
        "mail_smtpauth": 1,
        "mail_smtphost": "***REMOVED SENSITIVE VALUE***",
        "mail_smtpport": "587",
        "mail_smtpname": "***REMOVED SENSITIVE VALUE***",
        "mail_smtppassword": "***REMOVED SENSITIVE VALUE***",
        "app_install_overwrite": [
            "groupfolders",
            "files_mindmap"
        ],
        "onlyoffice": {
            "DocumentServerUrl": "\/ds-vpath\/",
            "DocumentServerInternalUrl": "http:\/\/onlyoffice\/",
            "StorageUrl": "http:\/\/nginx-nextcloud\/"
        },
        "allow_local_remote_servers": "true",
        "force_language": "fr",
        "default_locale": "fr_FR",
        "force_locale": "fr_FR",
        "default_language": "fr",
        "default_phone_region": "FR",
        "maintenance_window_start": "3",
        "memcache.distributed": "\\OC\\Memcache\\Redis",
        "memcache.locking": "\\OC\\Memcache\\Redis",
        "redis": {
            "host": "***REMOVED SENSITIVE VALUE***",
            "port": 6379,
            "password": "***REMOVED SENSITIVE VALUE***"
        }
    }
}

List of activated Apps

Enabled:
  - activity: 2.21.1
  - admin_audit: 1.19.0
  - announcementcenter: 6.8.1
  - calendar: 4.7.8
  - circles: 29.0.0-dev
  - cloud_federation_api: 1.12.0
  - comments: 1.19.0
  - contactsinteraction: 1.10.0
  - dashboard: 7.9.0
  - dav: 1.30.1
  - drawio: 3.0.2
  - event_update_notification: 2.4.0
  - external: 5.4.0
  - federatedfilesharing: 1.19.0
  - federation: 1.19.0
  - files: 2.1.0
  - files_downloadlimit: 2.0.0
  - files_pdfviewer: 2.10.0
  - files_reminders: 1.2.0
  - files_sharing: 1.21.0
  - files_trashbin: 1.19.0
  - files_versions: 1.22.0
  - firstrunwizard: 2.18.0
  - forms: 4.2.4
  - groupfolders: 17.0.1
  - logreader: 2.14.0
  - lookup_server_connector: 1.17.0
  - nextcloud_announcements: 1.18.0
  - notes: 4.10.0
  - notifications: 2.17.0
  - oauth2: 1.17.0
  - onlyoffice: 9.2.2
  - password_policy: 1.19.0
  - photos: 2.5.0
  - polls: 7.1.2
  - privacy: 1.13.0
  - provisioning_api: 1.19.0
  - recommendations: 2.1.0
  - related_resources: 1.4.0
  - serverinfo: 1.19.0
  - settings: 1.12.0
  - sharebymail: 1.19.0
  - support: 1.12.0
  - survey_client: 1.17.0
  - systemtags: 1.19.0
  - text: 3.10.1
  - theming: 2.4.0
  - twofactor_backupcodes: 1.18.0
  - updatenotification: 1.19.1
  - user_ldap: 1.20.0
  - user_status: 1.9.0
  - viewer: 2.3.0
  - weather_status: 1.9.0
  - workflowengine: 2.11.0
Disabled:
  - bruteforcesettings: 2.9.0
  - encryption: 2.17.0
  - files_external: 1.21.0
  - files_mindmap: 0.0.30 (installed 0.0.30)
  - files_rightclick: 0.15.1 (installed 1.6.0)
  - registration: 2.4.0 (installed 2.4.0)
  - spreed: 19.0.4 (installed 19.0.4)
  - suspicious_login: 7.0.0
  - twofactor_totp: 11.0.0-dev
  - whiteboard: 0.0.3 (installed 0.0.3)

Nextcloud Signing status

No errors have been found.

Nextcloud Logs


{
  "reqId": "4zrSqheBpcs4NYR7H09I",
  "level": 3,
  "time": "2024-07-12T09:53:03+00:00",
  "remoteAddr": "134.214.47.72",
  "user": "aa262220-78ae-1039-8531-ed3c63ef8117",
  "app": "no app in context",
  "method": "MOVE",
  "url": "/remote.php/dav/files/aa262220-78ae-1039-8531-ed3c63ef8117/DMP",
  "message": "Exception thrown: Doctrine\\DBAL\\Exception\\SyntaxErrorException",
  "userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:128.0) Gecko/20100101 Firefox/128.0",
  "version": "29.0.3.4",
  "exception": {
    "Exception": "Doctrine\\DBAL\\Exception\\SyntaxErrorException",
    "Message": "An exception occurred while executing a query: SQLSTATE[42601]: Syntax error: 7 ERROR:  syntax error at or near \")\"\nLINE 1: ...level\" = $1) WHERE (\"sh\".\"share_type\" = $2) AND (()) AND (\"s...\n                                                             ^",
    "Code": 7,
    "Trace": [
      {
        "file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php",
        "line": 1943,
        "function": "convert",
        "class": "Doctrine\\DBAL\\Driver\\API\\PostgreSQL\\ExceptionConverter",
        "type": "->",
        "args": [
          [
            "Doctrine\\DBAL\\Driver\\PDO\\Exception"
          ],
          [
            "Doctrine\\DBAL\\Query"
          ]
        ]
      },
      {
        "file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php",
        "line": 1885,
        "function": "handleDriverException",
        "class": "Doctrine\\DBAL\\Connection",
        "type": "->",
        "args": [
          [
            "Doctrine\\DBAL\\Driver\\PDO\\Exception"
          ],
          [
            "Doctrine\\DBAL\\Query"
          ]
        ]
      },
      {
        "file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php",
        "line": 1106,
        "function": "convertExceptionDuringQuery",
        "class": "Doctrine\\DBAL\\Connection",
        "type": "->",
        "args": [
          [
            "Doctrine\\DBAL\\Driver\\PDO\\Exception"
          ],
          "SELECT \"sh\".\"id\", \"sh\".\"share_type\", \"sh\".\"share_with\", \"sh\".\"uid_owner\", \"sh\".\"uid_initiator\", \"sh\".\"parent\", \"sh\".\"item_type\", \"sh\".\"item_source\", \"sh\".\"item_target\", \"sh\".\"file_source\", \"sh\".\"file_target\", \"sh\".\"permissions\", \"sh\".\"attributes\", \"sh\".\"stime\", \"sh\".\"accepted\", \"sh\".\"expiration\", \"sh\".\"token\", \"sh\".\"mail_send\", \"sh_cc\".\"unique_id\" AS \"sh_cc_unique_id\", \"sh_cc\".\"name\" AS \"sh_cc_name\", \"sh_cc\".\"display_name\" AS \"sh_cc_display_name\", \"sh_cc\".\"sanitized_name\" AS \"sh_cc_sanitized_name\", \"sh_cc\".\"source\" AS \"sh_cc_source\", \"sh_cc\".\"description\" AS \"sh_cc_description\", \"sh_cc\".\"settings\" AS \"sh_cc_settings\", \"sh_cc\".\"config\" AS \"sh_cc_config\", \"sh_cc\".\"contact_addressbook\" AS \"sh_cc_contact_addressbook\", \"sh_cc\".\"contact_groupname\" AS \"sh_cc_contact_groupname\", \"sh_cc\".\"creation\" AS \"sh_cc_creation\", \"sh_cc_wn\".\"circle_id\" AS \"sh_cc_wn_circle_id\", \"sh_cc_wn\".\"member_id\" AS \"sh_cc_wn_member_id\", \"sh_cc_wn\".\"single_id\" AS \"sh_cc_wn_single_id\", \"sh_cc_wn\".\"user_id\" AS \"sh_cc_wn_user_id\", \"sh_cc_wn\".\"instance\" AS \"sh_cc_wn_instance\", \"sh_cc_wn\".\"user_type\" AS \"sh_cc_wn_user_type\", \"sh_cc_wn\".\"level\" AS \"sh_cc_wn_level\", \"sh_cc_wn\".\"status\" AS \"sh_cc_wn_status\", \"sh_cc_wn\".\"note\" AS \"sh_cc_wn_note\", \"sh_cc_wn\".\"contact_id\" AS \"sh_cc_wn_contact_id\", \"sh_cc_wn\".\"cached_name\" AS \"sh_cc_wn_cached_name\", \"sh_cc_wn\".\"cached_update\" AS \"sh_cc_wn_cached_update\", \"sh_cc_wn\".\"contact_meta\" AS \"sh_cc_wn_contact_meta\", \"sh_cc_wn\".\"joined\" AS \"sh_cc_wn_joined\" FROM \"oc_share\" \"sh\" LEFT JOIN \"oc_circles_circle\" \"sh_cc\" ON \"sh_cc\".\"unique_id\" = \"sh\".\"share_with\" LEFT JOIN \"oc_circles_member\" \"sh_cc_wn\" ON (\"sh_cc_wn\".\"circle_id\" = \"sh_cc\".\"unique_id\") AND (\"sh_cc_wn\".\"level\" = ?) WHERE (\"sh\".\"share_type\" = ?) AND (()) AND (\"sh\".\"parent\" IS NULL)",
          [
            9,
            7
          ],
          [
            1,
            1
          ]
        ]
      },
      {
        "file": "/var/www/html/lib/private/DB/Connection.php",
        "line": 328,
        "function": "executeQuery",
        "class": "Doctrine\\DBAL\\Connection",
        "type": "->",
        "args": [
          "SELECT \"sh\".\"id\", \"sh\".\"share_type\", \"sh\".\"share_with\", \"sh\".\"uid_owner\", \"sh\".\"uid_initiator\", \"sh\".\"parent\", \"sh\".\"item_type\", \"sh\".\"item_source\", \"sh\".\"item_target\", \"sh\".\"file_source\", \"sh\".\"file_target\", \"sh\".\"permissions\", \"sh\".\"attributes\", \"sh\".\"stime\", \"sh\".\"accepted\", \"sh\".\"expiration\", \"sh\".\"token\", \"sh\".\"mail_send\", \"sh_cc\".\"unique_id\" AS \"sh_cc_unique_id\", \"sh_cc\".\"name\" AS \"sh_cc_name\", \"sh_cc\".\"display_name\" AS \"sh_cc_display_name\", \"sh_cc\".\"sanitized_name\" AS \"sh_cc_sanitized_name\", \"sh_cc\".\"source\" AS \"sh_cc_source\", \"sh_cc\".\"description\" AS \"sh_cc_description\", \"sh_cc\".\"settings\" AS \"sh_cc_settings\", \"sh_cc\".\"config\" AS \"sh_cc_config\", \"sh_cc\".\"contact_addressbook\" AS \"sh_cc_contact_addressbook\", \"sh_cc\".\"contact_groupname\" AS \"sh_cc_contact_groupname\", \"sh_cc\".\"creation\" AS \"sh_cc_creation\", \"sh_cc_wn\".\"circle_id\" AS \"sh_cc_wn_circle_id\", \"sh_cc_wn\".\"member_id\" AS \"sh_cc_wn_member_id\", \"sh_cc_wn\".\"single_id\" AS \"sh_cc_wn_single_id\", \"sh_cc_wn\".\"user_id\" AS \"sh_cc_wn_user_id\", \"sh_cc_wn\".\"instance\" AS \"sh_cc_wn_instance\", \"sh_cc_wn\".\"user_type\" AS \"sh_cc_wn_user_type\", \"sh_cc_wn\".\"level\" AS \"sh_cc_wn_level\", \"sh_cc_wn\".\"status\" AS \"sh_cc_wn_status\", \"sh_cc_wn\".\"note\" AS \"sh_cc_wn_note\", \"sh_cc_wn\".\"contact_id\" AS \"sh_cc_wn_contact_id\", \"sh_cc_wn\".\"cached_name\" AS \"sh_cc_wn_cached_name\", \"sh_cc_wn\".\"cached_update\" AS \"sh_cc_wn_cached_update\", \"sh_cc_wn\".\"contact_meta\" AS \"sh_cc_wn_contact_meta\", \"sh_cc_wn\".\"joined\" AS \"sh_cc_wn_joined\" FROM \"oc_share\" \"sh\" LEFT JOIN \"oc_circles_circle\" \"sh_cc\" ON \"sh_cc\".\"unique_id\" = \"sh\".\"share_with\" LEFT JOIN \"oc_circles_member\" \"sh_cc_wn\" ON (\"sh_cc_wn\".\"circle_id\" = \"sh_cc\".\"unique_id\") AND (\"sh_cc_wn\".\"level\" = ?) WHERE (\"sh\".\"share_type\" = ?) AND (()) AND (\"sh\".\"parent\" IS NULL)",
          [
            9,
            7
          ],
          [
            1,
            1
          ],
          null
        ]
      },
      {
        "file": "/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php",
        "line": 344,
        "function": "executeQuery",
        "class": "OC\\DB\\Connection",
        "type": "->",
        "args": [
          "SELECT \"sh\".\"id\", \"sh\".\"share_type\", \"sh\".\"share_with\", \"sh\".\"uid_owner\", \"sh\".\"uid_initiator\", \"sh\".\"parent\", \"sh\".\"item_type\", \"sh\".\"item_source\", \"sh\".\"item_target\", \"sh\".\"file_source\", \"sh\".\"file_target\", \"sh\".\"permissions\", \"sh\".\"attributes\", \"sh\".\"stime\", \"sh\".\"accepted\", \"sh\".\"expiration\", \"sh\".\"token\", \"sh\".\"mail_send\", \"sh_cc\".\"unique_id\" AS \"sh_cc_unique_id\", \"sh_cc\".\"name\" AS \"sh_cc_name\", \"sh_cc\".\"display_name\" AS \"sh_cc_display_name\", \"sh_cc\".\"sanitized_name\" AS \"sh_cc_sanitized_name\", \"sh_cc\".\"source\" AS \"sh_cc_source\", \"sh_cc\".\"description\" AS \"sh_cc_description\", \"sh_cc\".\"settings\" AS \"sh_cc_settings\", \"sh_cc\".\"config\" AS \"sh_cc_config\", \"sh_cc\".\"contact_addressbook\" AS \"sh_cc_contact_addressbook\", \"sh_cc\".\"contact_groupname\" AS \"sh_cc_contact_groupname\", \"sh_cc\".\"creation\" AS \"sh_cc_creation\", \"sh_cc_wn\".\"circle_id\" AS \"sh_cc_wn_circle_id\", \"sh_cc_wn\".\"member_id\" AS \"sh_cc_wn_member_id\", \"sh_cc_wn\".\"single_id\" AS \"sh_cc_wn_single_id\", \"sh_cc_wn\".\"user_id\" AS \"sh_cc_wn_user_id\", \"sh_cc_wn\".\"instance\" AS \"sh_cc_wn_instance\", \"sh_cc_wn\".\"user_type\" AS \"sh_cc_wn_user_type\", \"sh_cc_wn\".\"level\" AS \"sh_cc_wn_level\", \"sh_cc_wn\".\"status\" AS \"sh_cc_wn_status\", \"sh_cc_wn\".\"note\" AS \"sh_cc_wn_note\", \"sh_cc_wn\".\"contact_id\" AS \"sh_cc_wn_contact_id\", \"sh_cc_wn\".\"cached_name\" AS \"sh_cc_wn_cached_name\", \"sh_cc_wn\".\"cached_update\" AS \"sh_cc_wn_cached_update\", \"sh_cc_wn\".\"contact_meta\" AS \"sh_cc_wn_contact_meta\", \"sh_cc_wn\".\"joined\" AS \"sh_cc_wn_joined\" FROM \"oc_share\" \"sh\" LEFT JOIN \"oc_circles_circle\" \"sh_cc\" ON \"sh_cc\".\"unique_id\" = \"sh\".\"share_with\" LEFT JOIN \"oc_circles_member\" \"sh_cc_wn\" ON (\"sh_cc_wn\".\"circle_id\" = \"sh_cc\".\"unique_id\") AND (\"sh_cc_wn\".\"level\" = :dcValue2) WHERE (\"sh\".\"share_type\" = :dcValue1) AND (()) AND (\"sh\".\"parent\" IS NULL)",
          [
            7,
            9
          ],
          [
            1,
            1
          ],
          null
        ]
      },
      {
        "file": "/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php",
        "line": 384,
        "function": "executeQuery",
        "class": "Doctrine\\DBAL\\Query\\QueryBuilder",
        "type": "->",
        "args": []
      },
      {
        "file": "/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php",
        "line": 280,
        "function": "execute",
        "class": "Doctrine\\DBAL\\Query\\QueryBuilder",
        "type": "->",
        "args": []
      },
      {
        "file": "/var/www/html/apps/circles/lib/Tools/Db/ExtendedQueryBuilder.php",
        "line": 1046,
        "function": "execute",
        "class": "OC\\DB\\QueryBuilder\\QueryBuilder",
        "type": "->",
        "args": []
      },
      {
        "file": "/var/www/html/apps/circles/lib/Tools/Db/ExtendedQueryBuilder.php",
        "line": 942,
        "function": "getRows",
        "class": "OCA\\Circles\\Tools\\Db\\ExtendedQueryBuilder",
        "type": "->",
        "args": [
          [
            [
              "OCA\\Circles\\Db\\CoreQueryBuilder"
            ],
            "parseSimpleSelectSql"
          ],
          "OCA\\Circles\\Model\\ShareWrapper",
          []
        ]
      },
      {
        "file": "/var/www/html/apps/circles/lib/Db/ShareWrapperRequestBuilder.php",
        "line": 120,
        "function": "asItems",
        "class": "OCA\\Circles\\Tools\\Db\\ExtendedQueryBuilder",
        "type": "->",
        "args": [
          "OCA\\Circles\\Model\\ShareWrapper"
        ]
      },
      {
        "file": "/var/www/html/apps/circles/lib/Db/ShareWrapperRequest.php",
        "line": 294,
        "function": "getItemsFromRequest",
        "class": "OCA\\Circles\\Db\\ShareWrapperRequestBuilder",
        "type": "->",
        "args": [
          [
            "OCA\\Circles\\Db\\CoreQueryBuilder"
          ]
        ]
      },
      {
        "file": "/var/www/html/apps/circles/lib/Service/ShareWrapperService.php",
        "line": 204,
        "function": "getSharesByFileIds",
        "class": "OCA\\Circles\\Db\\ShareWrapperRequest",
        "type": "->",
        "args": [
          [],
          true
        ]
      },
      {
        "file": "/var/www/html/apps/circles/lib/ShareByCircleProvider.php",
        "line": 664,
        "function": "getSharesByFileIds",
        "class": "OCA\\Circles\\Service\\ShareWrapperService",
        "type": "->",
        "args": [
          [],
          true
        ]
      },
      {
        "file": "/var/www/html/lib/private/Share20/Manager.php",
        "line": 1691,
        "function": "getAccessList",
        "class": "OCA\\Circles\\ShareByCircleProvider",
        "type": "->",
        "args": [
          [],
          true
        ]
      },
      {
        "file": "/var/www/html/lib/private/Share20/ShareHelper.php",
        "line": 51,
        "function": "getAccessList",
        "class": "OC\\Share20\\Manager",
        "type": "->",
        "args": [
          [
            "OC\\Files\\Node\\Folder"
          ],
          true,
          true
        ]
      },
      {
        "file": "/var/www/html/apps/activity/lib/FilesHooks.php",
        "line": 598,
        "function": "getPathsForAccessList",
        "class": "OC\\Share20\\ShareHelper",
        "type": "->",
        "args": [
          [
            "OC\\Files\\Node\\Folder"
          ]
        ]
      },
      {
        "file": "/var/www/html/apps/activity/lib/FilesHooks.php",
        "line": 295,
        "function": "getUserPathsFromPath",
        "class": "OCA\\Activity\\FilesHooks",
        "type": "->",
        "args": [
          "/",
          "aa262220-78ae-1039-8531-ed3c63ef8117"
        ]
      },
      {
        "file": "/var/www/html/apps/activity/lib/FilesHooksStatic.php",
        "line": 67,
        "function": "fileMove",
        "class": "OCA\\Activity\\FilesHooks",
        "type": "->",
        "args": [
          "/DMP",
          "/DISP/DMP"
        ]
      },
      {
        "file": "/var/www/html/lib/private/legacy/OC_Hook.php",
        "line": 105,
        "function": "fileMove",
        "class": "OCA\\Activity\\FilesHooksStatic",
        "type": "::",
        "args": [
          [
            "/DMP",
            "/DISP/DMP",
            true
          ]
        ]
      },
      {
        "file": "/var/www/html/lib/private/Files/View.php",
        "line": 770,
        "function": "emit",
        "class": "OC_Hook",
        "type": "::",
        "args": [
          "OC_Filesystem",
          "rename",
          [
            "/DMP",
            "/DISP/DMP",
            true
          ]
        ]
      },
      {
        "file": "/var/www/html/apps/dav/lib/Connector/Sabre/Directory.php",
        "line": 454,
        "function": "rename",
        "class": "OC\\Files\\View",
        "type": "->",
        "args": [
          "/DMP",
          "/DISP/DMP"
        ]
      },
      {
        "file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/Tree.php",
        "line": 178,
        "function": "moveInto",
        "class": "OCA\\DAV\\Connector\\Sabre\\Directory",
        "type": "->",
        "args": [
          "DMP",
          "files/aa262220-78ae-1039-8531-ed3c63ef8117/DMP",
          [
            "OCA\\DAV\\Connector\\Sabre\\Directory"
          ]
        ]
      },
      {
        "file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/CorePlugin.php",
        "line": 612,
        "function": "move",
        "class": "Sabre\\DAV\\Tree",
        "type": "->",
        "args": [
          "files/aa262220-78ae-1039-8531-ed3c63ef8117/DMP",
          "files/aa262220-78ae-1039-8531-ed3c63ef8117/DISP/DMP"
        ]
      },
      {
        "file": "/var/www/html/3rdparty/sabre/event/lib/WildcardEmitterTrait.php",
        "line": 89,
        "function": "httpMove",
        "class": "Sabre\\DAV\\CorePlugin",
        "type": "->",
        "args": [
          [
            "Sabre\\HTTP\\Request"
          ],
          [
            "Sabre\\HTTP\\Response"
          ]
        ]
      },
      {
        "file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php",
        "line": 472,
        "function": "emit",
        "class": "Sabre\\DAV\\Server",
        "type": "->",
        "args": [
          "method:MOVE",
          [
            [
              "Sabre\\HTTP\\Request"
            ],
            [
              "Sabre\\HTTP\\Response"
            ]
          ]
        ]
      },
      {
        "file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php",
        "line": 253,
        "function": "invokeMethod",
        "class": "Sabre\\DAV\\Server",
        "type": "->",
        "args": [
          [
            "Sabre\\HTTP\\Request"
          ],
          [
            "Sabre\\HTTP\\Response"
          ]
        ]
      },
      {
        "file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php",
        "line": 321,
        "function": "start",
        "class": "Sabre\\DAV\\Server",
        "type": "->",
        "args": []
      },
      {
        "file": "/var/www/html/apps/dav/lib/Server.php",
        "line": 379,
        "function": "exec",
        "class": "Sabre\\DAV\\Server",
        "type": "->",
        "args": []
      },
      {
        "file": "/var/www/html/apps/dav/appinfo/v2/remote.php",
        "line": 35,
        "function": "exec",
        "class": "OCA\\DAV\\Server",
        "type": "->",
        "args": []
      },
      {
        "file": "/var/www/html/remote.php",
        "line": 172,
        "args": [
          "/var/www/html/apps/dav/appinfo/v2/remote.php"
        ],
        "function": "require_once"
      }
    ],
    "File": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/API/PostgreSQL/ExceptionConverter.php",
    "Line": 62,
    "Previous": {
      "Exception": "Doctrine\\DBAL\\Driver\\PDO\\Exception",
      "Message": "SQLSTATE[42601]: Syntax error: 7 ERROR:  syntax error at or near \")\"\nLINE 1: ...level\" = $1) WHERE (\"sh\".\"share_type\" = $2) AND (()) AND (\"s...\n                                                             ^",
      "Code": 7,
      "Trace": [
        {
          "file": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php",
          "line": 132,
          "function": "new",
          "class": "Doctrine\\DBAL\\Driver\\PDO\\Exception",
          "type": "::",
          "args": [
            [
              "PDOException",
              [
                "42601",
                7,
                "ERROR:  syntax error at or near \")\"\nLINE 1: ...level\" = $1) WHERE (\"sh\".\"share_type\" = $2) AND (()) AND (\"s...\n                                                             ^"
              ]
            ]
          ]
        },
        {
          "file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php",
          "line": 1099,
          "function": "execute",
          "class": "Doctrine\\DBAL\\Driver\\PDO\\Statement",
          "type": "->",
          "args": []
        },
        {
          "file": "/var/www/html/lib/private/DB/Connection.php",
          "line": 328,
          "function": "executeQuery",
          "class": "Doctrine\\DBAL\\Connection",
          "type": "->",
          "args": [
            "SELECT \"sh\".\"id\", \"sh\".\"share_type\", \"sh\".\"share_with\", \"sh\".\"uid_owner\", \"sh\".\"uid_initiator\", \"sh\".\"parent\", \"sh\".\"item_type\", \"sh\".\"item_source\", \"sh\".\"item_target\", \"sh\".\"file_source\", \"sh\".\"file_target\", \"sh\".\"permissions\", \"sh\".\"attributes\", \"sh\".\"stime\", \"sh\".\"accepted\", \"sh\".\"expiration\", \"sh\".\"token\", \"sh\".\"mail_send\", \"sh_cc\".\"unique_id\" AS \"sh_cc_unique_id\", \"sh_cc\".\"name\" AS \"sh_cc_name\", \"sh_cc\".\"display_name\" AS \"sh_cc_display_name\", \"sh_cc\".\"sanitized_name\" AS \"sh_cc_sanitized_name\", \"sh_cc\".\"source\" AS \"sh_cc_source\", \"sh_cc\".\"description\" AS \"sh_cc_description\", \"sh_cc\".\"settings\" AS \"sh_cc_settings\", \"sh_cc\".\"config\" AS \"sh_cc_config\", \"sh_cc\".\"contact_addressbook\" AS \"sh_cc_contact_addressbook\", \"sh_cc\".\"contact_groupname\" AS \"sh_cc_contact_groupname\", \"sh_cc\".\"creation\" AS \"sh_cc_creation\", \"sh_cc_wn\".\"circle_id\" AS \"sh_cc_wn_circle_id\", \"sh_cc_wn\".\"member_id\" AS \"sh_cc_wn_member_id\", \"sh_cc_wn\".\"single_id\" AS \"sh_cc_wn_single_id\", \"sh_cc_wn\".\"user_id\" AS \"sh_cc_wn_user_id\", \"sh_cc_wn\".\"instance\" AS \"sh_cc_wn_instance\", \"sh_cc_wn\".\"user_type\" AS \"sh_cc_wn_user_type\", \"sh_cc_wn\".\"level\" AS \"sh_cc_wn_level\", \"sh_cc_wn\".\"status\" AS \"sh_cc_wn_status\", \"sh_cc_wn\".\"note\" AS \"sh_cc_wn_note\", \"sh_cc_wn\".\"contact_id\" AS \"sh_cc_wn_contact_id\", \"sh_cc_wn\".\"cached_name\" AS \"sh_cc_wn_cached_name\", \"sh_cc_wn\".\"cached_update\" AS \"sh_cc_wn_cached_update\", \"sh_cc_wn\".\"contact_meta\" AS \"sh_cc_wn_contact_meta\", \"sh_cc_wn\".\"joined\" AS \"sh_cc_wn_joined\" FROM \"oc_share\" \"sh\" LEFT JOIN \"oc_circles_circle\" \"sh_cc\" ON \"sh_cc\".\"unique_id\" = \"sh\".\"share_with\" LEFT JOIN \"oc_circles_member\" \"sh_cc_wn\" ON (\"sh_cc_wn\".\"circle_id\" = \"sh_cc\".\"unique_id\") AND (\"sh_cc_wn\".\"level\" = ?) WHERE (\"sh\".\"share_type\" = ?) AND (()) AND (\"sh\".\"parent\" IS NULL)",
            [
              9,
              7
            ],
            [
              1,
              1
            ],
            null
          ]
        },
        {
          "file": "/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php",
          "line": 344,
          "function": "executeQuery",
          "class": "OC\\DB\\Connection",
          "type": "->",
          "args": [
            "SELECT \"sh\".\"id\", \"sh\".\"share_type\", \"sh\".\"share_with\", \"sh\".\"uid_owner\", \"sh\".\"uid_initiator\", \"sh\".\"parent\", \"sh\".\"item_type\", \"sh\".\"item_source\", \"sh\".\"item_target\", \"sh\".\"file_source\", \"sh\".\"file_target\", \"sh\".\"permissions\", \"sh\".\"attributes\", \"sh\".\"stime\", \"sh\".\"accepted\", \"sh\".\"expiration\", \"sh\".\"token\", \"sh\".\"mail_send\", \"sh_cc\".\"unique_id\" AS \"sh_cc_unique_id\", \"sh_cc\".\"name\" AS \"sh_cc_name\", \"sh_cc\".\"display_name\" AS \"sh_cc_display_name\", \"sh_cc\".\"sanitized_name\" AS \"sh_cc_sanitized_name\", \"sh_cc\".\"source\" AS \"sh_cc_source\", \"sh_cc\".\"description\" AS \"sh_cc_description\", \"sh_cc\".\"settings\" AS \"sh_cc_settings\", \"sh_cc\".\"config\" AS \"sh_cc_config\", \"sh_cc\".\"contact_addressbook\" AS \"sh_cc_contact_addressbook\", \"sh_cc\".\"contact_groupname\" AS \"sh_cc_contact_groupname\", \"sh_cc\".\"creation\" AS \"sh_cc_creation\", \"sh_cc_wn\".\"circle_id\" AS \"sh_cc_wn_circle_id\", \"sh_cc_wn\".\"member_id\" AS \"sh_cc_wn_member_id\", \"sh_cc_wn\".\"single_id\" AS \"sh_cc_wn_single_id\", \"sh_cc_wn\".\"user_id\" AS \"sh_cc_wn_user_id\", \"sh_cc_wn\".\"instance\" AS \"sh_cc_wn_instance\", \"sh_cc_wn\".\"user_type\" AS \"sh_cc_wn_user_type\", \"sh_cc_wn\".\"level\" AS \"sh_cc_wn_level\", \"sh_cc_wn\".\"status\" AS \"sh_cc_wn_status\", \"sh_cc_wn\".\"note\" AS \"sh_cc_wn_note\", \"sh_cc_wn\".\"contact_id\" AS \"sh_cc_wn_contact_id\", \"sh_cc_wn\".\"cached_name\" AS \"sh_cc_wn_cached_name\", \"sh_cc_wn\".\"cached_update\" AS \"sh_cc_wn_cached_update\", \"sh_cc_wn\".\"contact_meta\" AS \"sh_cc_wn_contact_meta\", \"sh_cc_wn\".\"joined\" AS \"sh_cc_wn_joined\" FROM \"oc_share\" \"sh\" LEFT JOIN \"oc_circles_circle\" \"sh_cc\" ON \"sh_cc\".\"unique_id\" = \"sh\".\"share_with\" LEFT JOIN \"oc_circles_member\" \"sh_cc_wn\" ON (\"sh_cc_wn\".\"circle_id\" = \"sh_cc\".\"unique_id\") AND (\"sh_cc_wn\".\"level\" = :dcValue2) WHERE (\"sh\".\"share_type\" = :dcValue1) AND (()) AND (\"sh\".\"parent\" IS NULL)",
            [
              7,
              9
            ],
            [
              1,
              1
            ],
            null
          ]
        },
        {
          "file": "/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php",
          "line": 384,
          "function": "executeQuery",
          "class": "Doctrine\\DBAL\\Query\\QueryBuilder",
          "type": "->",
          "args": []
        },
        {
          "file": "/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php",
          "line": 280,
          "function": "execute",
          "class": "Doctrine\\DBAL\\Query\\QueryBuilder",
          "type": "->",
          "args": []
        },
        {
          "file": "/var/www/html/apps/circles/lib/Tools/Db/ExtendedQueryBuilder.php",
          "line": 1046,
          "function": "execute",
          "class": "OC\\DB\\QueryBuilder\\QueryBuilder",
          "type": "->",
          "args": []
        },
        {
          "file": "/var/www/html/apps/circles/lib/Tools/Db/ExtendedQueryBuilder.php",
          "line": 942,
          "function": "getRows",
          "class": "OCA\\Circles\\Tools\\Db\\ExtendedQueryBuilder",
          "type": "->",
          "args": [
            [
              [
                "OCA\\Circles\\Db\\CoreQueryBuilder"
              ],
              "parseSimpleSelectSql"
            ],
            "OCA\\Circles\\Model\\ShareWrapper",
            []
          ]
        },
        {
          "file": "/var/www/html/apps/circles/lib/Db/ShareWrapperRequestBuilder.php",
          "line": 120,
          "function": "asItems",
          "class": "OCA\\Circles\\Tools\\Db\\ExtendedQueryBuilder",
          "type": "->",
          "args": [
            "OCA\\Circles\\Model\\ShareWrapper"
          ]
        },
        {
          "file": "/var/www/html/apps/circles/lib/Db/ShareWrapperRequest.php",
          "line": 294,
          "function": "getItemsFromRequest",
          "class": "OCA\\Circles\\Db\\ShareWrapperRequestBuilder",
          "type": "->",
          "args": [
            [
              "OCA\\Circles\\Db\\CoreQueryBuilder"
            ]
          ]
        },
        {
          "file": "/var/www/html/apps/circles/lib/Service/ShareWrapperService.php",
          "line": 204,
          "function": "getSharesByFileIds",
          "class": "OCA\\Circles\\Db\\ShareWrapperRequest",
          "type": "->",
          "args": [
            [],
            true
          ]
        },
        {
          "file": "/var/www/html/apps/circles/lib/ShareByCircleProvider.php",
          "line": 664,
          "function": "getSharesByFileIds",
          "class": "OCA\\Circles\\Service\\ShareWrapperService",
          "type": "->",
          "args": [
            [],
            true
          ]
        },
        {
          "file": "/var/www/html/lib/private/Share20/Manager.php",
          "line": 1691,
          "function": "getAccessList",
          "class": "OCA\\Circles\\ShareByCircleProvider",
          "type": "->",
          "args": [
            [],
            true
          ]
        },
        {
          "file": "/var/www/html/lib/private/Share20/ShareHelper.php",
          "line": 51,
          "function": "getAccessList",
          "class": "OC\\Share20\\Manager",
          "type": "->",
          "args": [
            [
              "OC\\Files\\Node\\Folder"
            ],
            true,
            true
          ]
        },
        {
          "file": "/var/www/html/apps/activity/lib/FilesHooks.php",
          "line": 598,
          "function": "getPathsForAccessList",
          "class": "OC\\Share20\\ShareHelper",
          "type": "->",
          "args": [
            [
              "OC\\Files\\Node\\Folder"
            ]
          ]
        },
        {
          "file": "/var/www/html/apps/activity/lib/FilesHooks.php",
          "line": 295,
          "function": "getUserPathsFromPath",
          "class": "OCA\\Activity\\FilesHooks",
          "type": "->",
          "args": [
            "/",
            "aa262220-78ae-1039-8531-ed3c63ef8117"
          ]
        },
        {
          "file": "/var/www/html/apps/activity/lib/FilesHooksStatic.php",
          "line": 67,
          "function": "fileMove",
          "class": "OCA\\Activity\\FilesHooks",
          "type": "->",
          "args": [
            "/DMP",
            "/DISP/DMP"
          ]
        },
        {
          "file": "/var/www/html/lib/private/legacy/OC_Hook.php",
          "line": 105,
          "function": "fileMove",
          "class": "OCA\\Activity\\FilesHooksStatic",
          "type": "::",
          "args": [
            [
              "/DMP",
              "/DISP/DMP",
              true
            ]
          ]
        },
        {
          "file": "/var/www/html/lib/private/Files/View.php",
          "line": 770,
          "function": "emit",
          "class": "OC_Hook",
          "type": "::",
          "args": [
            "OC_Filesystem",
            "rename",
            [
              "/DMP",
              "/DISP/DMP",
              true
            ]
          ]
        },
        {
          "file": "/var/www/html/apps/dav/lib/Connector/Sabre/Directory.php",
          "line": 454,
          "function": "rename",
          "class": "OC\\Files\\View",
          "type": "->",
          "args": [
            "/DMP",
            "/DISP/DMP"
          ]
        },
        {
          "file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/Tree.php",
          "line": 178,
          "function": "moveInto",
          "class": "OCA\\DAV\\Connector\\Sabre\\Directory",
          "type": "->",
          "args": [
            "DMP",
            "files/aa262220-78ae-1039-8531-ed3c63ef8117/DMP",
            [
              "OCA\\DAV\\Connector\\Sabre\\Directory"
            ]
          ]
        },
        {
          "file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/CorePlugin.php",
          "line": 612,
          "function": "move",
          "class": "Sabre\\DAV\\Tree",
          "type": "->",
          "args": [
            "files/aa262220-78ae-1039-8531-ed3c63ef8117/DMP",
            "files/aa262220-78ae-1039-8531-ed3c63ef8117/DISP/DMP"
          ]
        },
        {
          "file": "/var/www/html/3rdparty/sabre/event/lib/WildcardEmitterTrait.php",
          "line": 89,
          "function": "httpMove",
          "class": "Sabre\\DAV\\CorePlugin",
          "type": "->",
          "args": [
            [
              "Sabre\\HTTP\\Request"
            ],
            [
              "Sabre\\HTTP\\Response"
            ]
          ]
        },
        {
          "file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php",
          "line": 472,
          "function": "emit",
          "class": "Sabre\\DAV\\Server",
          "type": "->",
          "args": [
            "method:MOVE",
            [
              [
                "Sabre\\HTTP\\Request"
              ],
              [
                "Sabre\\HTTP\\Response"
              ]
            ]
          ]
        },
        {
          "file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php",
          "line": 253,
          "function": "invokeMethod",
          "class": "Sabre\\DAV\\Server",
          "type": "->",
          "args": [
            [
              "Sabre\\HTTP\\Request"
            ],
            [
              "Sabre\\HTTP\\Response"
            ]
          ]
        },
        {
          "file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php",
          "line": 321,
          "function": "start",
          "class": "Sabre\\DAV\\Server",
          "type": "->",
          "args": []
        },
        {
          "file": "/var/www/html/apps/dav/lib/Server.php",
          "line": 379,
          "function": "exec",
          "class": "Sabre\\DAV\\Server",
          "type": "->",
          "args": []
        },
        {
          "file": "/var/www/html/apps/dav/appinfo/v2/remote.php",
          "line": 35,
          "function": "exec",
          "class": "OCA\\DAV\\Server",
          "type": "->",
          "args": []
        },
        {
          "file": "/var/www/html/remote.php",
          "line": 172,
          "args": [
            "/var/www/html/apps/dav/appinfo/v2/remote.php"
          ],
          "function": "require_once"
        }
      ],
      "File": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Exception.php",
      "Line": 28,
      "Previous": {
        "Exception": "PDOException",
        "Message": "SQLSTATE[42601]: Syntax error: 7 ERROR:  syntax error at or near \")\"\nLINE 1: ...level\" = $1) WHERE (\"sh\".\"share_type\" = $2) AND (()) AND (\"s...\n                                                             ^",
        "Code": "42601",
        "Trace": [
          {
            "file": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php",
            "line": 130,
            "function": "execute",
            "class": "PDOStatement",
            "type": "->",
            "args": [
              null
            ]
          },
          {
            "file": "/var/www/html/3rdparty/doctrine/dbal/src/Connection.php",
            "line": 1099,
            "function": "execute",
            "class": "Doctrine\\DBAL\\Driver\\PDO\\Statement",
            "type": "->",
            "args": []
          },
          {
            "file": "/var/www/html/lib/private/DB/Connection.php",
            "line": 328,
            "function": "executeQuery",
            "class": "Doctrine\\DBAL\\Connection",
            "type": "->",
            "args": [
              "SELECT \"sh\".\"id\", \"sh\".\"share_type\", \"sh\".\"share_with\", \"sh\".\"uid_owner\", \"sh\".\"uid_initiator\", \"sh\".\"parent\", \"sh\".\"item_type\", \"sh\".\"item_source\", \"sh\".\"item_target\", \"sh\".\"file_source\", \"sh\".\"file_target\", \"sh\".\"permissions\", \"sh\".\"attributes\", \"sh\".\"stime\", \"sh\".\"accepted\", \"sh\".\"expiration\", \"sh\".\"token\", \"sh\".\"mail_send\", \"sh_cc\".\"unique_id\" AS \"sh_cc_unique_id\", \"sh_cc\".\"name\" AS \"sh_cc_name\", \"sh_cc\".\"display_name\" AS \"sh_cc_display_name\", \"sh_cc\".\"sanitized_name\" AS \"sh_cc_sanitized_name\", \"sh_cc\".\"source\" AS \"sh_cc_source\", \"sh_cc\".\"description\" AS \"sh_cc_description\", \"sh_cc\".\"settings\" AS \"sh_cc_settings\", \"sh_cc\".\"config\" AS \"sh_cc_config\", \"sh_cc\".\"contact_addressbook\" AS \"sh_cc_contact_addressbook\", \"sh_cc\".\"contact_groupname\" AS \"sh_cc_contact_groupname\", \"sh_cc\".\"creation\" AS \"sh_cc_creation\", \"sh_cc_wn\".\"circle_id\" AS \"sh_cc_wn_circle_id\", \"sh_cc_wn\".\"member_id\" AS \"sh_cc_wn_member_id\", \"sh_cc_wn\".\"single_id\" AS \"sh_cc_wn_single_id\", \"sh_cc_wn\".\"user_id\" AS \"sh_cc_wn_user_id\", \"sh_cc_wn\".\"instance\" AS \"sh_cc_wn_instance\", \"sh_cc_wn\".\"user_type\" AS \"sh_cc_wn_user_type\", \"sh_cc_wn\".\"level\" AS \"sh_cc_wn_level\", \"sh_cc_wn\".\"status\" AS \"sh_cc_wn_status\", \"sh_cc_wn\".\"note\" AS \"sh_cc_wn_note\", \"sh_cc_wn\".\"contact_id\" AS \"sh_cc_wn_contact_id\", \"sh_cc_wn\".\"cached_name\" AS \"sh_cc_wn_cached_name\", \"sh_cc_wn\".\"cached_update\" AS \"sh_cc_wn_cached_update\", \"sh_cc_wn\".\"contact_meta\" AS \"sh_cc_wn_contact_meta\", \"sh_cc_wn\".\"joined\" AS \"sh_cc_wn_joined\" FROM \"oc_share\" \"sh\" LEFT JOIN \"oc_circles_circle\" \"sh_cc\" ON \"sh_cc\".\"unique_id\" = \"sh\".\"share_with\" LEFT JOIN \"oc_circles_member\" \"sh_cc_wn\" ON (\"sh_cc_wn\".\"circle_id\" = \"sh_cc\".\"unique_id\") AND (\"sh_cc_wn\".\"level\" = ?) WHERE (\"sh\".\"share_type\" = ?) AND (()) AND (\"sh\".\"parent\" IS NULL)",
              [
                9,
                7
              ],
              [
                1,
                1
              ],
              null
            ]
          },
          {
            "file": "/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php",
            "line": 344,
            "function": "executeQuery",
            "class": "OC\\DB\\Connection",
            "type": "->",
            "args": [
              "SELECT \"sh\".\"id\", \"sh\".\"share_type\", \"sh\".\"share_with\", \"sh\".\"uid_owner\", \"sh\".\"uid_initiator\", \"sh\".\"parent\", \"sh\".\"item_type\", \"sh\".\"item_source\", \"sh\".\"item_target\", \"sh\".\"file_source\", \"sh\".\"file_target\", \"sh\".\"permissions\", \"sh\".\"attributes\", \"sh\".\"stime\", \"sh\".\"accepted\", \"sh\".\"expiration\", \"sh\".\"token\", \"sh\".\"mail_send\", \"sh_cc\".\"unique_id\" AS \"sh_cc_unique_id\", \"sh_cc\".\"name\" AS \"sh_cc_name\", \"sh_cc\".\"display_name\" AS \"sh_cc_display_name\", \"sh_cc\".\"sanitized_name\" AS \"sh_cc_sanitized_name\", \"sh_cc\".\"source\" AS \"sh_cc_source\", \"sh_cc\".\"description\" AS \"sh_cc_description\", \"sh_cc\".\"settings\" AS \"sh_cc_settings\", \"sh_cc\".\"config\" AS \"sh_cc_config\", \"sh_cc\".\"contact_addressbook\" AS \"sh_cc_contact_addressbook\", \"sh_cc\".\"contact_groupname\" AS \"sh_cc_contact_groupname\", \"sh_cc\".\"creation\" AS \"sh_cc_creation\", \"sh_cc_wn\".\"circle_id\" AS \"sh_cc_wn_circle_id\", \"sh_cc_wn\".\"member_id\" AS \"sh_cc_wn_member_id\", \"sh_cc_wn\".\"single_id\" AS \"sh_cc_wn_single_id\", \"sh_cc_wn\".\"user_id\" AS \"sh_cc_wn_user_id\", \"sh_cc_wn\".\"instance\" AS \"sh_cc_wn_instance\", \"sh_cc_wn\".\"user_type\" AS \"sh_cc_wn_user_type\", \"sh_cc_wn\".\"level\" AS \"sh_cc_wn_level\", \"sh_cc_wn\".\"status\" AS \"sh_cc_wn_status\", \"sh_cc_wn\".\"note\" AS \"sh_cc_wn_note\", \"sh_cc_wn\".\"contact_id\" AS \"sh_cc_wn_contact_id\", \"sh_cc_wn\".\"cached_name\" AS \"sh_cc_wn_cached_name\", \"sh_cc_wn\".\"cached_update\" AS \"sh_cc_wn_cached_update\", \"sh_cc_wn\".\"contact_meta\" AS \"sh_cc_wn_contact_meta\", \"sh_cc_wn\".\"joined\" AS \"sh_cc_wn_joined\" FROM \"oc_share\" \"sh\" LEFT JOIN \"oc_circles_circle\" \"sh_cc\" ON \"sh_cc\".\"unique_id\" = \"sh\".\"share_with\" LEFT JOIN \"oc_circles_member\" \"sh_cc_wn\" ON (\"sh_cc_wn\".\"circle_id\" = \"sh_cc\".\"unique_id\") AND (\"sh_cc_wn\".\"level\" = :dcValue2) WHERE (\"sh\".\"share_type\" = :dcValue1) AND (()) AND (\"sh\".\"parent\" IS NULL)",
              [
                7,
                9
              ],
              [
                1,
                1
              ],
              null
            ]
          },
          {
            "file": "/var/www/html/3rdparty/doctrine/dbal/src/Query/QueryBuilder.php",
            "line": 384,
            "function": "executeQuery",
            "class": "Doctrine\\DBAL\\Query\\QueryBuilder",
            "type": "->",
            "args": []
          },
          {
            "file": "/var/www/html/lib/private/DB/QueryBuilder/QueryBuilder.php",
            "line": 280,
            "function": "execute",
            "class": "Doctrine\\DBAL\\Query\\QueryBuilder",
            "type": "->",
            "args": []
          },
          {
            "file": "/var/www/html/apps/circles/lib/Tools/Db/ExtendedQueryBuilder.php",
            "line": 1046,
            "function": "execute",
            "class": "OC\\DB\\QueryBuilder\\QueryBuilder",
            "type": "->",
            "args": []
          },
          {
            "file": "/var/www/html/apps/circles/lib/Tools/Db/ExtendedQueryBuilder.php",
            "line": 942,
            "function": "getRows",
            "class": "OCA\\Circles\\Tools\\Db\\ExtendedQueryBuilder",
            "type": "->",
            "args": [
              [
                [
                  "OCA\\Circles\\Db\\CoreQueryBuilder"
                ],
                "parseSimpleSelectSql"
              ],
              "OCA\\Circles\\Model\\ShareWrapper",
              []
            ]
          },
          {
            "file": "/var/www/html/apps/circles/lib/Db/ShareWrapperRequestBuilder.php",
            "line": 120,
            "function": "asItems",
            "class": "OCA\\Circles\\Tools\\Db\\ExtendedQueryBuilder",
            "type": "->",
            "args": [
              "OCA\\Circles\\Model\\ShareWrapper"
            ]
          },
          {
            "file": "/var/www/html/apps/circles/lib/Db/ShareWrapperRequest.php",
            "line": 294,
            "function": "getItemsFromRequest",
            "class": "OCA\\Circles\\Db\\ShareWrapperRequestBuilder",
            "type": "->",
            "args": [
              [
                "OCA\\Circles\\Db\\CoreQueryBuilder"
              ]
            ]
          },
          {
            "file": "/var/www/html/apps/circles/lib/Service/ShareWrapperService.php",
            "line": 204,
            "function": "getSharesByFileIds",
            "class": "OCA\\Circles\\Db\\ShareWrapperRequest",
            "type": "->",
            "args": [
              [],
              true
            ]
          },
          {
            "file": "/var/www/html/apps/circles/lib/ShareByCircleProvider.php",
            "line": 664,
            "function": "getSharesByFileIds",
            "class": "OCA\\Circles\\Service\\ShareWrapperService",
            "type": "->",
            "args": [
              [],
              true
            ]
          },
          {
            "file": "/var/www/html/lib/private/Share20/Manager.php",
            "line": 1691,
            "function": "getAccessList",
            "class": "OCA\\Circles\\ShareByCircleProvider",
            "type": "->",
            "args": [
              [],
              true
            ]
          },
          {
            "file": "/var/www/html/lib/private/Share20/ShareHelper.php",
            "line": 51,
            "function": "getAccessList",
            "class": "OC\\Share20\\Manager",
            "type": "->",
            "args": [
              [
                "OC\\Files\\Node\\Folder"
              ],
              true,
              true
            ]
          },
          {
            "file": "/var/www/html/apps/activity/lib/FilesHooks.php",
            "line": 598,
            "function": "getPathsForAccessList",
            "class": "OC\\Share20\\ShareHelper",
            "type": "->",
            "args": [
              [
                "OC\\Files\\Node\\Folder"
              ]
            ]
          },
          {
            "file": "/var/www/html/apps/activity/lib/FilesHooks.php",
            "line": 295,
            "function": "getUserPathsFromPath",
            "class": "OCA\\Activity\\FilesHooks",
            "type": "->",
            "args": [
              "/",
              "aa262220-78ae-1039-8531-ed3c63ef8117"
            ]
          },
          {
            "file": "/var/www/html/apps/activity/lib/FilesHooksStatic.php",
            "line": 67,
            "function": "fileMove",
            "class": "OCA\\Activity\\FilesHooks",
            "type": "->",
            "args": [
              "/DMP",
              "/DISP/DMP"
            ]
          },
          {
            "file": "/var/www/html/lib/private/legacy/OC_Hook.php",
            "line": 105,
            "function": "fileMove",
            "class": "OCA\\Activity\\FilesHooksStatic",
            "type": "::",
            "args": [
              [
                "/DMP",
                "/DISP/DMP",
                true
              ]
            ]
          },
          {
            "file": "/var/www/html/lib/private/Files/View.php",
            "line": 770,
            "function": "emit",
            "class": "OC_Hook",
            "type": "::",
            "args": [
              "OC_Filesystem",
              "rename",
              [
                "/DMP",
                "/DISP/DMP",
                true
              ]
            ]
          },
          {
            "file": "/var/www/html/apps/dav/lib/Connector/Sabre/Directory.php",
            "line": 454,
            "function": "rename",
            "class": "OC\\Files\\View",
            "type": "->",
            "args": [
              "/DMP",
              "/DISP/DMP"
            ]
          },
          {
            "file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/Tree.php",
            "line": 178,
            "function": "moveInto",
            "class": "OCA\\DAV\\Connector\\Sabre\\Directory",
            "type": "->",
            "args": [
              "DMP",
              "files/aa262220-78ae-1039-8531-ed3c63ef8117/DMP",
              [
                "OCA\\DAV\\Connector\\Sabre\\Directory"
              ]
            ]
          },
          {
            "file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/CorePlugin.php",
            "line": 612,
            "function": "move",
            "class": "Sabre\\DAV\\Tree",
            "type": "->",
            "args": [
              "files/aa262220-78ae-1039-8531-ed3c63ef8117/DMP",
              "files/aa262220-78ae-1039-8531-ed3c63ef8117/DISP/DMP"
            ]
          },
          {
            "file": "/var/www/html/3rdparty/sabre/event/lib/WildcardEmitterTrait.php",
            "line": 89,
            "function": "httpMove",
            "class": "Sabre\\DAV\\CorePlugin",
            "type": "->",
            "args": [
              [
                "Sabre\\HTTP\\Request"
              ],
              [
                "Sabre\\HTTP\\Response"
              ]
            ]
          },
          {
            "file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php",
            "line": 472,
            "function": "emit",
            "class": "Sabre\\DAV\\Server",
            "type": "->",
            "args": [
              "method:MOVE",
              [
                [
                  "Sabre\\HTTP\\Request"
                ],
                [
                  "Sabre\\HTTP\\Response"
                ]
              ]
            ]
          },
          {
            "file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php",
            "line": 253,
            "function": "invokeMethod",
            "class": "Sabre\\DAV\\Server",
            "type": "->",
            "args": [
              [
                "Sabre\\HTTP\\Request"
              ],
              [
                "Sabre\\HTTP\\Response"
              ]
            ]
          },
          {
            "file": "/var/www/html/3rdparty/sabre/dav/lib/DAV/Server.php",
            "line": 321,
            "function": "start",
            "class": "Sabre\\DAV\\Server",
            "type": "->",
            "args": []
          },
          {
            "file": "/var/www/html/apps/dav/lib/Server.php",
            "line": 379,
            "function": "exec",
            "class": "Sabre\\DAV\\Server",
            "type": "->",
            "args": []
          },
          {
            "file": "/var/www/html/apps/dav/appinfo/v2/remote.php",
            "line": 35,
            "function": "exec",
            "class": "OCA\\DAV\\Server",
            "type": "->",
            "args": []
          },
          {
            "file": "/var/www/html/remote.php",
            "line": 172,
            "args": [
              "/var/www/html/apps/dav/appinfo/v2/remote.php"
            ],
            "function": "require_once"
          }
        ],
        "File": "/var/www/html/3rdparty/doctrine/dbal/src/Driver/PDO/Statement.php",
        "Line": 130
      }
    },
    "CustomMessage": "Exception thrown: Doctrine\\DBAL\\Exception\\SyntaxErrorException"
  }
}```

### Additional info

_No response_
joshtrichards commented 1 month ago

Looks like a variation of #46196. This is fixed in the upcoming maintenance release. You can test the change early if you want, to confirm it also fixes your variation, by manually applying the one line change found here to your installation of the Circles/Teams app: https://github.com/nextcloud/circles/pull/1625/files

genestouxguy commented 1 month ago

Hi, Thanks for you answer!

I added the fix and the error "SQLSTATE[42601] ..." fixed but I can't move the folder ... The error "NotFoundException Node for share not found, fileid: 13485" is still there, so 1 fixed.

Do you want another ticket ?

skjnldsv commented 2 weeks ago

@icewind1991 I suspect this happened after https://github.com/nextcloud/server/pull/43471

skjnldsv commented 2 weeks ago

From #46467

Installation method

Community Manual installation with Archive

Nextcloud Server version

29

Operating system

Debian/Ubuntu

PHP engine version

PHP 8.2

Web server

Nginx

Database engine version

PostgreSQL

Is this bug present after an update or on a fresh install?

Updated from a MINOR version (ex. 28.0.1 to 28.0.2)

Are you using the Nextcloud Server Encryption module?

None

What user-backends are you using?

Configuration report

{
    "system": {
        "instanceid": "***REMOVED SENSITIVE VALUE***",
        "passwordsalt": "***REMOVED SENSITIVE VALUE***",
        "secret": "***REMOVED SENSITIVE VALUE***",
        "trusted_domains": [
            "home.domain.net"
        ],
        "datadirectory": "***REMOVED SENSITIVE VALUE***",
        "overwrite.cli.url": "https:\/\/home.domain.net\/",
        "overwritewebroot": "\/",
        "htaccess.RewriteBase": "\/",
        "version": "29.0.4.1",
        "knowledgebaseenabled": false,
        "apps_paths": [
            {
                "path": "\/var\/www\/nextcloud\/apps",
                "url": "\/apps",
                "writable": true
            }
        ],
        "dbtype": "pgsql",
        "dbname": "***REMOVED SENSITIVE VALUE***",
        "dbhost": "***REMOVED SENSITIVE VALUE***",
        "dbtableprefix": "oc_",
        "dbuser": "***REMOVED SENSITIVE VALUE***",
        "dbpassword": "***REMOVED SENSITIVE VALUE***",
        "default_phone_region": "DE",
        "installed": true,
        "loglevel": 2,
        "mail_smtpmode": "sendmail",
        "maintenance": false,
        "maintenance_window_start": 1,
        "memcache.local": "\\OC\\Memcache\\APCu",
        "memcache.distributed": "\\OC\\Memcache\\Redis",
        "memcache.locking": "\\OC\\Memcache\\Redis",
        "mail_from_address": "***REMOVED SENSITIVE VALUE***",
        "mail_domain": "***REMOVED SENSITIVE VALUE***",
        "updater.release.channel": "stable",
        "preview_max_x": 2048,
        "preview_max_y": 2048,
        "preview_max_filesize_image": 100,
        "preview_max_memory": 256,
        "app_install_overwrite": [
            "checksum",
            "files_3d",
            "calendar",
            "camerarawpreviews",
            "metadata"
        ],
        "redis": {
            "host": "***REMOVED SENSITIVE VALUE***",
            "port": 0,
            "password": "***REMOVED SENSITIVE VALUE***",
            "dbindex": 0
        },
        "theme": ""
    },
    "apps": {
        "168512": {
            "enabled": "no"
        },
        "Object": {
            "enabled": "no"
        },
        "activity": {
            "enable_email": "no",
            "enabled": "yes",
            "notify_email_calendar": "0",
            "notify_email_calendar_event": "0",
            "notify_email_calendar_todo": "0",
            "notify_email_comments": "1",
            "notify_email_contacts": "0",
            "notify_email_favorite": "0",
            "notify_email_file_changed": "0",
            "notify_email_file_created": "0",
            "notify_email_file_deleted": "0",
            "notify_email_file_restored": "0",
            "notify_email_group_settings": "1",
            "notify_email_public_links": "0",
            "notify_email_remote_share": "1",
            "notify_email_shared": "1",
            "notify_email_systemtags": "0",
            "notify_notification_calendar": "1",
            "notify_notification_calendar_event": "1",
            "notify_notification_calendar_todo": "1",
            "notify_notification_comments": "1",
            "notify_notification_contacts": "1",
            "notify_notification_favorite": "0",
            "notify_notification_file_changed": "0",
            "notify_notification_file_favorite_changed": "0",
            "notify_notification_group_settings": "0",
            "notify_notification_personal_settings": "1",
            "notify_notification_public_links": "1",
            "notify_notification_remote_share": "1",
            "notify_notification_security": "1",
            "notify_notification_shared": "1",
            "notify_notification_twofactor_totp": "1",
            "notify_setting_batchtime": "3600",
            "notify_setting_self": "0",
            "notify_setting_selfemail": "0",
            "notify_stream_calendar": "1",
            "notify_stream_calendar_event": "1",
            "notify_stream_calendar_todo": "1",
            "notify_stream_comments": "1",
            "notify_stream_favorite": "1",
            "notify_stream_file_changed": "1",
            "notify_stream_file_created": "1",
            "notify_stream_file_deleted": "1",
            "notify_stream_file_favorite": "0",
            "notify_stream_file_restored": "1",
            "notify_stream_public_links": "1",
            "notify_stream_remote_share": "1",
            "notify_stream_shared": "1",
            "notify_stream_systemtags": "1",
            "signed": "true",
            "types": "filesystem",
            "installed_version": "2.21.1"
        },
        "admin_dependencies_chk": {
            "enabled": "no",
            "installed_version": "0.02",
            "ocsid": "166041",
            "types": ""
        },
        "backgroundjob": {
            "lastjob": "46617"
        },
        "calendar": {
            "signed": "true",
            "types": "",
            "installed_version": "4.7.15",
            "enabled": "yes"
        },
        "camerarawpreviews": {
            "signed": "true",
            "types": "filesystem",
            "enabled": "yes",
            "installed_version": "0.8.5"
        },
        "checksum": {
            "installed_version": "1.2.4",
            "enabled": "yes",
            "signed": "true",
            "types": "filesystem"
        },
        "circles": {
            "enabled": "no",
            "installed_version": "22.1.1",
            "loopback_tmp_path": "\/",
            "loopback_tmp_scheme": "https",
            "maintenance_run": "0",
            "maintenance_update": "{\"maximum\":3,\"3\":1632854704,\"2\":1632855602,\"1\":1632855602}",
            "types": "filesystem,dav"
        },
        "cloud_federation_api": {
            "enabled": "yes",
            "types": "filesystem",
            "installed_version": "1.12.0"
        },
        "comments": {
            "enabled": "yes",
            "types": "logging",
            "installed_version": "1.19.0"
        },
        "configreport": {
            "enabled": "no",
            "installed_version": "0.1.1",
            "types": "filesystem"
        },
        "contacts": {
            "installed_version": "6.0.0",
            "enabled": "yes",
            "signed": "true",
            "types": "dav"
        },
        "contactsinteraction": {
            "enabled": "no",
            "installed_version": "1.0.0",
            "types": "dav"
        },
        "core": {
            "lastupdatedat": 1722881114,
            "backgroundjobs_mode": "cron",
            "default_encryption_module": "OC_DEFAULT_MODULE",
            "enterpriseLogoChecked": "yes",
            "global_cache_gc_lastrun": "1446893101",
            "installedat": "1441298319.1224",
            "moveavatarsdone": "yes",
            "previewsCleanedUp": "1",
            "public_caldav": "calendar\/share.php",
            "public_calendar": "calendar\/share.php",
            "public_documents": "documents\/public.php",
            "public_files": "files_sharing\/public.php",
            "public_gallery": "gallery\/public.php",
            "public_webdav": "dav\/appinfo\/v1\/publicwebdav.php",
            "remote_caldav": "dav\/appinfo\/v1\/caldav.php",
            "remote_calendar": "dav\/appinfo\/v1\/caldav.php",
            "remote_carddav": "dav\/appinfo\/v1\/carddav.php",
            "remote_contacts": "dav\/appinfo\/v1\/carddav.php",
            "remote_dav": "dav\/appinfo\/v2\/remote.php",
            "remote_files": "dav\/appinfo\/v1\/webdav.php",
            "remote_filesync": "files\/appinfo\/filesync.php",
            "remote_mozilla_sync": "mozilla_sync\/appinfo\/remote.php",
            "remote_webdav": "dav\/appinfo\/v1\/webdav.php",
            "repairlegacystoragesdone": "yes",
            "scss.variables": "f14db8cff751edac4726fff7271e42e3",
            "shareapi_allow_public_notification": "no",
            "shareapi_allow_share_dialog_user_enumeration": "no",
            "shareapi_allow_social_share": "no",
            "shareapi_default_expire_date": "yes",
            "shareapi_default_permission_candelete": "no",
            "shareapi_default_permissions": "21",
            "shareapi_enabled": "yes",
            "shareapi_enforce_expire_date": "no",
            "shareapi_enforce_links_password_write_only": "yes",
            "shareapi_expire_after_n_days": "7",
            "shareapi_only_share_with_group_members": "no",
            "shareapi_only_share_with_membership_groups": "yes",
            "vendor": "nextcloud",
            "theming.variables": "314c8041839d7a04f280ae64ed73d846",
            "shareapi_exclude_groups": "no",
            "metadataGenerationLastHandledUser": "haarp",
            "lastupdateResult": "[]",
            "updater.secret.created": 1722826274,
            "files_metadata_installed": "1",
            "lastcron": 1722948657,
            "oc.integritycheck.checker": [],
            "files_metadata": {
                "photos-original_date_time": {
                    "value": null,
                    "type": "int",
                    "etag": "",
                    "indexed": true,
                    "editPermission": 0
                },
                "photos-exif": {
                    "value": null,
                    "type": "array",
                    "etag": "",
                    "indexed": false,
                    "editPermission": 0
                },
                "photos-ifd0": {
                    "value": null,
                    "type": "array",
                    "etag": "",
                    "indexed": false,
                    "editPermission": 0
                },
                "photos-size": {
                    "value": null,
                    "type": "array",
                    "etag": "",
                    "indexed": false,
                    "editPermission": 0
                },
                "photos-gps": {
                    "value": null,
                    "type": "array",
                    "etag": "",
                    "indexed": false,
                    "editPermission": 0
                },
                "photos-place": {
                    "value": null,
                    "type": "string",
                    "etag": "",
                    "indexed": true,
                    "editPermission": 0
                },
                "blurhash": {
                    "value": null,
                    "type": "string",
                    "etag": "bc473f23d545f9142f37826f3df49809",
                    "indexed": false,
                    "editPermission": 0
                }
            }
        },
        "dashboard": {
            "enabled": "no",
            "installed_version": "7.0.0",
            "types": ""
        },
        "dav": {
            "buildCalendarReminderIndex": "yes",
            "buildCalendarSearchIndex": "yes",
            "chunks_migrated": "1",
            "enabled": "yes",
            "regeneratedBirthdayCalendarsForYearFix": "yes",
            "sendEventReminders": "no",
            "sendEventRemindersPush": "yes",
            "types": "filesystem",
            "installed_version": "1.30.1"
        },
        "documents": {
            "enabled": "no",
            "installed_version": "0.8.2",
            "ocsid": "168711",
            "types": ""
        },
        "duplicatefinder": {
            "enabled": "no",
            "types": "",
            "installed_version": "1.2.3"
        },
        "encryption": {
            "masterKeyId": "master_0b8de5cd",
            "publicShareKeyId": "pubShare_0b8de5cd",
            "recoveryKeyId": "recoveryKey_0b8de5cd"
        },
        "federatedfilesharing": {
            "enabled": "yes",
            "types": "",
            "installed_version": "1.19.0"
        },
        "federation": {
            "enabled": "yes",
            "types": "authentication",
            "installed_version": "1.19.0"
        },
        "files": {
            "mimetype_version": "29.0.2.2",
            "cronjob_scan_files": "500",
            "enabled": "yes",
            "types": "filesystem",
            "installed_version": "2.1.0"
        },
        "files_3d": {
            "installed_version": "0.5.0",
            "types": "filesystem",
            "enabled": "yes"
        },
        "files_clipboard": {
            "enabled": "no",
            "installed_version": "1.0.2",
            "signed": "true",
            "types": ""
        },
        "files_downloadlimit": {
            "installed_version": "2.0.0",
            "types": "",
            "enabled": "yes"
        },
        "files_external": {
            "enabled": "yes",
            "types": "filesystem",
            "installed_version": "1.21.0"
        },
        "files_mv": {
            "enabled": "no",
            "installed_version": "0.8.2",
            "ocsid": "150271",
            "types": "filesystem"
        },
        "files_pdfviewer": {
            "enabled": "no",
            "installed_version": "0.8.1",
            "ocsid": "166049",
            "types": ""
        },
        "files_reminders": {
            "types": "",
            "enabled": "yes",
            "installed_version": "1.2.0"
        },
        "files_rightclick": {
            "types": "",
            "installed_version": "1.6.0",
            "enabled": "no"
        },
        "files_sharing": {
            "enabled": "yes",
            "incoming_server2server_group_share_enabled": "yes",
            "types": "filesystem",
            "installed_version": "1.21.0",
            "outgoing_server2server_group_share_enabled": "yes"
        },
        "files_texteditor": {
            "enabled": "no",
            "installed_version": "2.11.0",
            "signed": "true",
            "types": ""
        },
        "files_textviewer": {
            "enabled": "no",
            "installed_version": "1.0",
            "signed": "true",
            "types": ""
        },
        "files_trashbin": {
            "enabled": "yes",
            "types": "filesystem,dav",
            "installed_version": "1.19.0"
        },
        "files_versions": {
            "enabled": "yes",
            "types": "filesystem,dav",
            "installed_version": "1.22.0"
        },
        "files_videoviewer": {
            "enabled": "no",
            "installed_version": "0.1.3",
            "ocsid": "166054",
            "types": ""
        },
        "firstrunwizard": {
            "enabled": "no",
            "installed_version": "2.8.0",
            "types": "logging"
        },
        "gallery": {
            "enabled": "no",
            "installed_version": "18.4.0",
            "signed": "true",
            "types": ""
        },
        "logreader": {
            "enabled": "yes",
            "installed_version": "2.14.0",
            "types": "logging"
        },
        "lookup_server_connector": {
            "enabled": "yes",
            "types": "authentication",
            "installed_version": "1.17.0"
        },
        "market": {
            "activity": "2.4.2",
            "calendar": "1.6.4",
            "enabled": "no",
            "files_clipboard": "1.0.2",
            "installed_version": "0.4.0",
            "key": "",
            "market": "0.4.0",
            "signed": "true",
            "types": ""
        },
        "metadata": {
            "types": "",
            "installed_version": "0.20.0",
            "enabled": "no"
        },
        "mozilla_sync": {
            "enabled": "no",
            "installed_version": "1.4",
            "types": ""
        },
        "music": {
            "types": "filesystem",
            "enabled": "yes",
            "installed_version": "2.0.0"
        },
        "nextcloud_announcements": {
            "enabled": "yes",
            "pub_date": "Thu, 24 Oct 2019 00:00:00 +0200",
            "types": "logging",
            "installed_version": "1.18.0"
        },
        "notes": {
            "enabled": "yes",
            "types": "",
            "installed_version": "4.10.1"
        },
        "notifications": {
            "enabled": "yes",
            "types": "logging",
            "installed_version": "2.17.0",
            "sound_talk": "yes",
            "setting_batchtime": "0",
            "sound_notification": "yes"
        },
        "notify_push": {
            "enabled": "yes",
            "installed_version": "0.7.0",
            "types": "filesystem"
        },
        "oauth2": {
            "enabled": "yes",
            "types": "authentication",
            "installed_version": "1.17.0"
        },
        "ocsms": {
            "enabled": "no",
            "installed_version": "1.9.0",
            "ocsid": "167289",
            "types": ""
        },
        "password_policy": {
            "enabled": "yes",
            "types": "authentication",
            "enforceNonCommonPassword": "1",
            "enforceHaveIBeenPwned": "1",
            "installed_version": "1.19.0"
        },
        "phonetrack": {
            "enabled": "yes",
            "signed": "true",
            "types": "",
            "installed_version": "0.8.1"
        },
        "photos": {
            "enabled": "yes",
            "installed_version": "2.5.0",
            "types": "dav,authentication",
            "lastPlaceMappedUser": "wifisd",
            "lastPlaceMappingDone": "true"
        },
        "preview": {
            "jpeg_quality": "60"
        },
        "previewgenerator": {
            "enabled": "no",
            "installed_version": "2.3.0",
            "types": "filesystem"
        },
        "privacy": {
            "enabled": "yes",
            "readableLocation": "de",
            "types": "",
            "installed_version": "1.13.0",
            "fullDiskEncryptionEnabled": "1"
        },
        "provisioning_api": {
            "enabled": "yes",
            "types": "prevent_group_restriction",
            "installed_version": "1.19.0"
        },
        "ransomware_protection": {
            "enabled": "no",
            "installed_version": "1.14.0",
            "types": "logging"
        },
        "recommendations": {
            "enabled": "no",
            "installed_version": "1.1.0",
            "types": ""
        },
        "related_resources": {
            "types": "",
            "enabled": "yes",
            "installed_version": "1.4.0"
        },
        "root_cache_cleaner": {
            "enabled": "yes",
            "types": "",
            "installed_version": "0.1.7"
        },
        "search_lucene": {
            "enabled": "no",
            "installed_version": "0.5.3",
            "ocsid": "168709",
            "types": "filesystem"
        },
        "serverinfo": {
            "enabled": "yes",
            "types": "",
            "cached_count_storages": "19",
            "installed_version": "1.19.0",
            "cached_count_filecache": "3467232"
        },
        "settings": {
            "enabled": "yes",
            "profile_enabled_by_default": "0",
            "types": "",
            "installed_version": "1.12.0"
        },
        "sharebymail": {
            "enabled": "yes",
            "types": "filesystem",
            "installed_version": "1.19.0",
            "sendpasswordmail": "no"
        },
        "support": {
            "SwitchUpdaterServerHasRun": "yes",
            "enabled": "yes",
            "types": "session",
            "installed_version": "1.12.0"
        },
        "survey_client": {
            "enabled": "no",
            "installed_version": "1.10.0",
            "types": ""
        },
        "systemtags": {
            "enabled": "no",
            "installed_version": "1.11.0",
            "types": "logging"
        },
        "templateeditor": {
            "enabled": "no",
            "installed_version": "0.1",
            "types": ""
        },
        "text": {
            "enabled": "yes",
            "types": "dav",
            "workspace_available": "0",
            "installed_version": "3.10.1"
        },
        "theming": {
            "enabled": "yes",
            "name": "ERPPC Nextcloud",
            "types": "logging",
            "installed_version": "2.4.0",
            "cachebuster": "75",
            "color": "#00353D",
            "faviconMime": "image\/png",
            "logoheaderMime": "image\/png",
            "backgroundMime": "backgroundColor",
            "disable-user-theming": "yes",
            "slogan": "***REMOVED SENSITIVE VALUE***",
            "url": "***REMOVED SENSITIVE VALUE***",
            "logoMime": "image\/png"
        },
        "theming_customcss": {
            "installed_version": "1.17.0",
            "customcss": "div#contactsmenu { display:none !important; }",
            "enabled": "yes",
            "types": "",
            "cachebuster": "1688254772356"
        },
        "twofactor_backupcodes": {
            "enabled": "yes",
            "types": "",
            "installed_version": "1.18.0"
        },
        "twofactor_totp": {
            "enabled": "yes",
            "types": "",
            "installed_version": "11.0.0-dev"
        },
        "updatenotification": {
            "theming_customcss": "1.17.0",
            "metadata": "0.19.0",
            "calendar": "4.7.14",
            "duplicatefinder": "0.0.11",
            "enabled": "yes",
            "files_3d": "0.3.3",
            "types": "",
            "checksum": "1.2.4",
            "camerarawpreviews": "0.8.5",
            "notes": "4.10.1",
            "installed_version": "1.19.1",
            "contacts": "5.5.3",
            "root_cache_cleaner": "0.1.7",
            "phonetrack": "0.8.1",
            "notify_push": "0.7.0",
            "music": "2.0.0",
            "core": "29.0.4.1",
            "update_check_errors": "0"
        },
        "uppush": {
            "enabled": "no",
            "installed_version": "1.0.0",
            "types": ""
        },
        "user_status": {
            "enabled": "no",
            "installed_version": "1.0.1",
            "types": ""
        },
        "viewer": {
            "enabled": "yes",
            "types": "",
            "installed_version": "2.3.0"
        },
        "weather_status": {
            "enabled": "no",
            "installed_version": "1.1.0",
            "types": ""
        },
        "workflowengine": {
            "enabled": "yes",
            "types": "filesystem",
            "installed_version": "2.11.0"
        }
    }
}

List of activated Apps

Enabled:
  - activity: 2.21.1
  - calendar: 4.7.15
  - camerarawpreviews: 0.8.5
  - checksum: 1.2.4
  - cloud_federation_api: 1.12.0
  - comments: 1.19.0
  - contacts: 6.0.0
  - dav: 1.30.1
  - federatedfilesharing: 1.19.0
  - federation: 1.19.0
  - files: 2.1.0
  - files_3d: 0.5.0
  - files_downloadlimit: 2.0.0
  - files_external: 1.21.0
  - files_reminders: 1.2.0
  - files_sharing: 1.21.0
  - files_trashbin: 1.19.0
  - files_versions: 1.22.0
  - logreader: 2.14.0
  - lookup_server_connector: 1.17.0
  - music: 2.0.0
  - nextcloud_announcements: 1.18.0
  - notes: 4.10.1
  - notifications: 2.17.0
  - notify_push: 0.7.0
  - oauth2: 1.17.0
  - password_policy: 1.19.0
  - phonetrack: 0.8.1
  - photos: 2.5.0
  - privacy: 1.13.0
  - provisioning_api: 1.19.0
  - related_resources: 1.4.0
  - root_cache_cleaner: 0.1.7
  - serverinfo: 1.19.0
  - settings: 1.12.0
  - sharebymail: 1.19.0
  - support: 1.12.0
  - text: 3.10.1
  - theming: 2.4.0
  - theming_customcss: 1.17.0
  - twofactor_backupcodes: 1.18.0
  - twofactor_totp: 11.0.0-dev
  - updatenotification: 1.19.1
  - viewer: 2.3.0
  - workflowengine: 2.11.0
Disabled:
  - admin_audit: 1.19.0
  - bruteforcesettings: 2.9.0
  - circles: 29.0.0-dev (installed 22.1.1)
  - contactsinteraction: 1.10.0 (installed 1.0.0)
  - dashboard: 7.9.0 (installed 7.0.0)
  - duplicatefinder: 1.2.3 (installed 1.2.3)
  - encryption: 2.17.0
  - files_pdfviewer: 2.10.0 (installed 0.8.1)
  - firstrunwizard: 2.18.0 (installed 2.8.0)
  - metadata: 0.20.0 (installed 0.20.0)
  - ransomware_protection: 1.14.0 (installed 1.14.0)
  - recommendations: 2.1.0 (installed 1.1.0)
  - survey_client: 1.17.0 (installed 1.10.0)
  - suspicious_login: 7.0.0
  - systemtags: 1.19.0 (installed 1.11.0)
  - user_ldap: 1.20.0
  - user_status: 1.9.0 (installed 1.0.1)
  - weather_status: 1.9.0 (installed 1.1.0)

Nextcloud Signing status

No errors have been found.

Nextcloud Logs


{
  "reqId": "liRTsu7ItuTBXMqF54US",
  "level": 3,
  "time": "2024-08-06T12:13:14+00:00",
  "remoteAddr": "123.123.123.123",
  "user": "foo",
  "app": "webdav",
  "method": "MOVE",
  "url": "/remote.php/dav/files/foo/Wohnung",
  "message": "Node for share not found, fileid: 3256914",
  "userAgent": "Mozilla/5.0 (Windows) mirall/3.4.2stable-Win64 (build 20220127) (Nextcloud, windows-10.0.22631 ClientArchitecture: x86_64 OsArchitecture: x86_64)",
  "version": "29.0.4.1",
  "exception": {
    "Exception": "OCP\\Files\\NotFoundException",
    "Message": "Node for share not found, fileid: 3256914",
    "Code": 0,
    "Trace": [
      {
        "file": "/var/www/nextcloud/lib/private/Files/View.php",
        "line": 1818,
        "function": "getNode",
        "class": "OC\\Share20\\Share",
        "type": "->"
      },
      {
        "file": "/var/www/nextcloud/lib/private/Files/View.php",
        "line": 798,
        "function": "targetIsNotShared",
        "class": "OC\\Files\\View",
        "type": "->"
      },
      {
        "file": "/var/www/nextcloud/apps/dav/lib/Connector/Sabre/Node.php",
        "line": 159,
        "function": "rename",
        "class": "OC\\Files\\View",
        "type": "->"
      },
      {
        "file": "/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Tree.php",
        "line": 171,
        "function": "setName",
        "class": "OCA\\DAV\\Connector\\Sabre\\Node",
        "type": "->"
      },
      {
        "file": "/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php",
        "line": 612,
        "function": "move",
        "class": "Sabre\\DAV\\Tree",
        "type": "->"
      },
      {
        "file": "/var/www/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php",
        "line": 89,
        "function": "httpMove",
        "class": "Sabre\\DAV\\CorePlugin",
        "type": "->"
      },
      {
        "file": "/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php",
        "line": 472,
        "function": "emit",
        "class": "Sabre\\DAV\\Server",
        "type": "->"
      },
      {
        "file": "/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php",
        "line": 253,
        "function": "invokeMethod",
        "class": "Sabre\\DAV\\Server",
        "type": "->"
      },
      {
        "file": "/var/www/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php",
        "line": 321,
        "function": "start",
        "class": "Sabre\\DAV\\Server",
        "type": "->"
      },
      {
        "file": "/var/www/nextcloud/apps/dav/lib/Server.php",
        "line": 383,
        "function": "exec",
        "class": "Sabre\\DAV\\Server",
        "type": "->"
      },
      {
        "file": "/var/www/nextcloud/apps/dav/appinfo/v2/remote.php",
        "line": 35,
        "function": "exec",
        "class": "OCA\\DAV\\Server",
        "type": "->"
      },
      {
        "file": "/var/www/nextcloud/remote.php",
        "line": 172,
        "args": [
          "/var/www/nextcloud/apps/dav/appinfo/v2/remote.php"
        ],
        "function": "require_once"
      }
    ],
    "File": "/var/www/nextcloud/lib/private/Share20/Share.php",
    "Line": 194,
    "message": "Node for share not found, fileid: 3256914",
    "exception": {},
    "CustomMessage": "Node for share not found, fileid: 3256914"
  }
}```

### Additional info

There is no id 3256914 in `oc_filecache`. the file in question (before being shared) has id 3925410.
ObiWahn commented 1 week ago

same issue here:

{
  "reqId": "XXXXXXXXXXXXXXXXXXXX",
  "level": 3,
  "time": "2024-08-18T05:37:17+00:00",
  "remoteAddr": "10.13.44.4",
  "user": "someuser",
  "app": "webdav",
  "method": "MOVE",
  "url": "/nextcloud//remote.php/dav/files/someuser/ASHAREDFOLDER",
  "message": "Node for share not found, fileid: 11824",
  "userAgent": "Mozilla/5.0 (iOS) Nextcloud-iOS/5.5.3",
  "version": "29.0.4.1",
  "exception": {
    "Exception": "OCP\\Files\\NotFoundException",
    "Message": "Node for share not found, fileid: 11824",
    "Code": 0,
    "Trace": [
      {
        "file": "/home/nextcloud/lib/private/Files/View.php",
        "line": 1818,
        "function": "getNode",
        "class": "OC\\Share20\\Share",
        "type": "->"
      },
      {
        "file": "/home/nextcloud/lib/private/Files/View.php",
        "line": 798,
        "function": "targetIsNotShared",
        "class": "OC\\Files\\View",
        "type": "->"
      },
      {
        "file": "/home/nextcloud/apps/dav/lib/Connector/Sabre/Directory.php",
        "line": 454,
        "function": "rename",
        "class": "OC\\Files\\View",
        "type": "->"
      },
      {
        "file": "/home/nextcloud/3rdparty/sabre/dav/lib/DAV/Tree.php",
        "line": 178,
        "function": "moveInto",
        "class": "OCA\\DAV\\Connector\\Sabre\\Directory",
        "type": "->"
      },
      {
        "file": "/home/nextcloud/3rdparty/sabre/dav/lib/DAV/CorePlugin.php",
        "line": 612,
        "function": "move",
        "class": "Sabre\\DAV\\Tree",
        "type": "->"
      },
      {
        "file": "/home/nextcloud/3rdparty/sabre/event/lib/WildcardEmitterTrait.php",
        "line": 89,
        "function": "httpMove",
        "class": "Sabre\\DAV\\CorePlugin",
        "type": "->"
      },
      {
        "file": "/home/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php",
        "line": 472,
        "function": "emit",
        "class": "Sabre\\DAV\\Server",
        "type": "->"
      },
      {
        "file": "/home/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php",
        "line": 253,
        "function": "invokeMethod",
        "class": "Sabre\\DAV\\Server",
        "type": "->"
      },
      {
        "file": "/home/nextcloud/3rdparty/sabre/dav/lib/DAV/Server.php",
        "line": 321,
        "function": "start",
        "class": "Sabre\\DAV\\Server",
        "type": "->"
      },
      {
        "file": "/home/nextcloud/apps/dav/lib/Server.php",
        "line": 383,
        "function": "exec",
        "class": "Sabre\\DAV\\Server",
        "type": "->"
      },
      {
        "file": "/home/nextcloud/apps/dav/appinfo/v2/remote.php",
        "line": 35,
        "function": "exec",
        "class": "OCA\\DAV\\Server",
        "type": "->"
      },
      {
        "file": "/home/nextcloud/remote.php",
        "line": 172,
        "args": [
          "/home/nextcloud/apps/dav/appinfo/v2/remote.php"
        ],
        "function": "require_once"
      }
    ],
    "File": "/home/nextcloud/lib/private/Share20/Share.php",
    "Line": 194,
    "message": "Node for share not found, fileid: 11824",
    "exception": [],
    "CustomMessage": "Node for share not found, fileid: 11824"
  },
  "id": "99c1890c861cb"
}

I think ./occ sharing:delete-orphan-shares resovled the problem for me. I'll update this in case it is not the case.