tables icon indicating copy to clipboard operation
tables copied to clipboard
verified publisher icon nextcloud

Change ownership of a Table "Failed to fetch user"

Open boddedo opened this issue 1 year ago • 3 comments

Steps to reproduce

  1. As the owner of a table
  2. Press Edit table, then "Change Owner"
  3. Try typing something (the error appear when you enter letters)

ERROR in the console:

{
  "stack": "Rr@https://mynextcloudserver.com/apps/tables/js/tables-main.js?v=0d9ee579-4:2:2646670\nwi</</f/<@https://mynextcloudserver.com/apps/tables/js/tables-main.js?-v=0d9ee579-4:2:2660704\nf@https://mynextcloudserver.com/apps/tables/js/tables-main.js?v=0d9ee579-4:2:2660852\nEventHandlerNonNull*wi</<@https://mynextcloudserver.com/apps/tables/js/tables-main.js?v=0d9ee579-4:2:2661142\nwi<@https://mynextcloudserver.com/apps/tables/js/tables-main.js?v=0d9ee579-4:2:2659826\nSi@https://mynextcloudserver.com/apps/tables/js/tables-main.js?v=0d9ee579-4:2:2663861\nrequest@https://mynextcloudserver.com/apps/tables/js/tables-main.js?v=0d9ee579-4:2:2667511\nIi.prototype[e]@https://mynextcloudserver.com/apps/tables/js/tables-main.js?v=0d9ee579-4:2:2667807\nXn/<@https://mynextcloudserver.com/apps/tables/js/tables-main.js?v=0d9ee579-4:2:2641496\ngetSuggestions/r/<@https://mynextcloudserver.com/apps/tables/js/tables-main.js?v=0d9ee579-4:2:5642673\nd@https://mynextcloudserver.com/apps/tables/js/tables-main.js?v=0d9ee579-4:2:5634570\nR0/C/<@https://mynextcloudserver.com/apps/tables/js/tables-main.js?v=0d9ee579-4:2:5635918\nR0/T/</<@https://mynextcloudserver.com/apps/tables/js/tables-main.js?v=0d9ee579-4:2:5634999\nM0@https://mynextcloudserver.com/apps/tables/js/tables-main.js?v=0d9ee579-4:2:5640488\no@https://mynextcloudserver.com/apps/tables/js/tables-main.js?v=0d9ee579-4:2:5640694\nL0/</<@https://mynextcloudserver.com/apps/tables/js/tables-main.js?v=0d9ee579-4:2:5640754\nL0/<@https://mynextcloudserver.com/apps/tables/js/tables-main.js?v=0d9ee579-4:2:5640632\ngetSuggestions@https://mynextcloudserver.com/apps/tables/js/tables-main.js?v=0d9ee579-4:2:5643135\nI0.methods.debounceGetSuggestions<@https://mynextcloudserver.com/apps/tables/js/tables-main.js?v=0d9ee579-4:2:5643199\nu@https://mynextcloudserver.com/apps/tables/js/tables-main.js?v=0d9ee579-4:2:989896\nsetTimeout handler*c@https://mynextcloudserver.com/apps/tables/js/tables-main.js?v=0d9ee579-4:2:990061\nasyncFind/n/<@https://mynextcloudserver.com/apps/tables/js/tables-main.js?v=0d9ee579-4:2:5642227\nd@https://mynextcloudserver.com/apps/tables/js/tables-main.js?v=0d9ee579-4:2:5634570\nR0/C/<@https://mynextcloudserver.com/apps/tables/js/tables-main.js?v=0d9ee579-4:2:5635918\nR0/T/</<@https://mynextcloudserver.com/apps/tables/js/tables-main.js?v=0d9ee579-4:2:5634999\nM0@https://mynextcloudserver.com/apps/tables/js/tables-main.js?v=0d9ee579-4:2:5640488\no@https://mynextcloudserver.com/apps/tables/js/tables-main.js?v=0d9ee579-4:2:5640694\nL0/</<@https://mynextcloudserver.com/apps/tables/js/tables-main.js?v=0d9ee579-4:2:5640754\nL0/<@https://mynextcloudserver.com/apps/tables/js/tables-main.js?v=0d9ee579-4:2:5640632\nasyncFind@https://mynextcloudserver.com/apps/tables/js/tables-main.js?v=0d9ee579-4:2:5642295\ndn@https://mynextcloudserver.com/apps/tables/js/tables-main.js?v=0d9ee579-4:2:1768233\nn@https://mynextcloudserver.com/apps/tables/js/tables-main.js?v=0d9ee579-4:2:1760923\ndn@https://mynextcloudserver.com/apps/tables/js/tables-main.js?v=0d9ee579-4:2:1768233\nn@https://mynextcloudserver.com/apps/tables/js/tables-main.js?v=0d9ee579-4:2:1761002\ndn@https://mynextcloudserver.com/apps/tables/js/tables-main.js?v=0d9ee579-4:2:1768233\n20144/e.prototype.$emit@https://mynextcloudserver.com/apps/tables/js/tables-main.js?v=0d9ee579-4:2:1790103\nsearch@https://mynextcloudserver.com/apps/tables/js/tables-main.js?v=0d9ee579-4:2:31412\ndn@https://mynextcloudserver.com/apps/tables/js/tables-main.js?v=0d9ee579-4:2:1768233\n20144/e.prototype.run@https://mynextcloudserver.com/apps/tables/js/tables-main.js?v=0d9ee579-4:2:1772649\nrr@https://mynextcloudserver.com/apps/tables/js/tables-main.js?v=0d9ee579-4:2:1774479\n20144/wn/<@https://mynextcloudserver.com/apps/tables/js/tables-main.js?v=0d9ee579-4:2:1769315\n_n@https://mynextcloudserver.com/apps/tables/js/tables-main.js?v=0d9ee579-4:2:1768714\npromise callback*hn@https://mynextcloudserver.com/apps/tables/js/tables-main.js?v=0d9ee579-4:2:1768804\nwn@https://mynextcloudserver.com/apps/tables/js/tables-main.js?v=0d9ee579-4:2:1769378\nir@https://mynextcloudserver.com/apps/tables/js/tables-main.js?v=0d9ee579-4:2:1774975\n20144/e.prototype.update@https://mynextcloudserver.com/apps/tables/js/tables-main.js?v=0d9ee579-4:2:1772438\n20144/e.prototype.notify@https://mynextcloudserver.com/apps/tables/js/tables-main.js?v=0d9ee579-4:2:1753754\nset@https://mynextcloudserver.com/apps/tables/js/tables-main.js?v=0d9ee579-4:2:1755598\n20144/Sr/Dr.set@https://mynextcloudserver.com/apps/tables/js/tables-main.js?v=0d9ee579-4:2:1783507\ninput@https://mynextcloudserver.com/apps/tables/js/tables-main.js?v=0d9ee579-4:2:39791\ndn@https://mynextcloudserver.com/apps/tables/js/tables-main.js?v=0d9ee579-4:2:1768233\nn@https://mynextcloudserver.com/apps/tables/js/tables-main.js?v=0d9ee579-4:2:1760923\n20144/Pi/a._wrapper@https://mynextcloudserver.com/apps/tables/js/tables-main.js?v=0d9ee579-4:2:1801148\n",
  "message": "Request failed with status code 500",
  "name": "AxiosError",
  "code": "ERR_BAD_RESPONSE",
  "config": {
    "transitional": {
      "silentJSONParsing": true,
      "forcedJSONParsing": true,
      "clarifyTimeoutError": false
    },
    "adapter": [
      "xhr",
      "http"
    ],
    "transformRequest": [
      null
    ],
    "transformResponse": [
      null
    ],
    "timeout": 0,
    "xsrfCookieName": "XSRF-TOKEN",
    "xsrfHeaderName": "X-XSRF-TOKEN",
    "maxContentLength": -1,
    "maxBodyLength": -1,
    "env": {},
    "headers": {
      "Accept": "application/json, text/plain, */*",
      "Content-Type": null,
      "requesttoken": "T3CouayX/rcqrGmNvygeXsbP0WabjxJ01GuuMZm6Ah0=:IwH7icPBkeBulAzA7WEsKKe2phzL+2NftSLmU/HVQHQ="
    },
    "method": "get",
    "url": "https://mynextcloudserver.com/ocs/v2.php/core/autocomplete/get?search=a&shareTypes[]=0&limit=20"
  },
  "request": {},
  "response": {
    "data": "<?xml version=\"1.0\"?>\n<ocs>\n <meta>\n  <status>failure</status>\n  <statuscode>500</statuscode>\n  <message>Internal Server Error\n</message>\n </meta>\n <data/>\n</ocs>\n",
    "status": 500,
    "statusText": "",
    "headers": {
      "cache-control": "no-store, no-cache, must-revalidate",
      "content-security-policy": "default-src 'self'; script-src 'self' 'nonce-eDloYUhZazcxSUlYSjFXdXdJSUNmR2NUMEszNkFkSDdXSkhaYWtQZmQxUT06cTZrSkxlWnR1OVZUSHpEamtzc3dDZ1pxcDllcWRhRFFPZGlSQ0N1d05UMD0='; style-src 'self' 'unsafe-inline'; frame-src *; img-src * data: blob:; font-src 'self' data:; media-src *; connect-src *; object-src 'none'; base-uri 'self';",
      "content-type": "text/xml; charset=UTF-8",
      "date": "Wed, 17 Jul 2024 09:22:34 GMT",
      "expires": "Thu, 19 Nov 1981 08:52:00 GMT",
      "pragma": "no-cache",
      "referrer-policy": "same-origin",
      "server": "nginx",
      "strict-transport-security": "max-age=15768000",
      "x-content-type-options": "nosniff",
      "x-download-options": "noopen",
      "x-firefox-spdy": "h2",
      "x-frame-options": "SAMEORIGIN",
      "x-permitted-cross-domain-policies": "none",
      "x-robots-tag": "noindex, nofollow",
      "x-xss-protection": "1; mode=block"
    },
    "config": {
      "transitional": {
        "silentJSONParsing": true,
        "forcedJSONParsing": true,
        "clarifyTimeoutError": false
      },
      "adapter": [
        "xhr",
        "http"
      ],
      "transformRequest": [
        null
      ],
      "transformResponse": [
        null
      ],
      "timeout": 0,
      "xsrfCookieName": "XSRF-TOKEN",
      "xsrfHeaderName": "X-XSRF-TOKEN",
      "maxContentLength": -1,
      "maxBodyLength": -1,
      "env": {},
      "headers": {
        "Accept": "application/json, text/plain, */*",
        "Content-Type": null,
        "requesttoken": "T3CouayX/rcqrGmNvygeXsbP0WabjxJ01GuuMZm6Ah0=:IwH7icPBkeBulAzA7WEsKKe2phzL+2NftSLmU/HVQHQ="
      },
      "method": "get",
      "url": "https://mynextcloudserver.com/ocs/v2.php/core/autocomplete/get?search=a&shareTypes[]=0&limit=20"
    },
    "request": {}
  }
}

ERROR in the Nextcloud log file:

{
  "reqId": "hMAduV2PjzJHc0hARRYh",
  "level": 3,
  "time": "2024-07-17T08:29:45+00:00",
  "remoteAddr": "IPADDRESS",
  "user": "myusername",
  "app": "no app in context",
  "method": "GET",
  "url": "/ocs/v2.php/core/autocomplete/get?search=quen&shareTypes[]=0&limit=20",
  "message": "Exception thrown: Exception",
  "userAgent": "Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:128.0) Gecko/20100101 Firefox/128.0",
  "version": "27.1.5.1",
  "exception": {
    "Exception": "Exception",
    "Message": "OCP\\Collaboration\\AutoComplete\\AutoCompleteEvent::getItemType(): Return value must be of type string, null returned in file '/var/www/nextcloud/lib/public/Collaboration/AutoComplete/AutoCompleteEvent.php' line 76",
    "Code": 0,
    "Trace": [
      {
        "file": "/var/www/nextcloud/lib/private/AppFramework/App.php",
        "line": 183,
        "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": 65,
        "function": "match",
        "class": "OC\\Route\\Router",
        "type": "->"
      },
      {
        "file": "/var/www/nextcloud/ocs/v2.php",
        "line": 23,
        "args": [
          "/var/www/nextcloud/ocs/v1.php"
        ],
        "function": "require_once"
      }
    ],
    "File": "/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
    "Line": 169,
    "Previous": {
      "Exception": "TypeError",
      "Message": "OCP\\Collaboration\\AutoComplete\\AutoCompleteEvent::getItemType(): Return value must be of type string, null returned",
      "Code": 0,
      "Trace": [
        {
          "file": "/var/www/nextcloud/apps/spreed/lib/Collaboration/Collaborators/Listener.php",
          "line": 78,
          "function": "getItemType",
          "class": "OCP\\Collaboration\\AutoComplete\\AutoCompleteEvent",
          "type": "->"
        },
        {
          "file": "/var/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php",
          "line": 251,
          "function": "filterNonListableMesssages",
          "class": "OCA\\Talk\\Collaboration\\Collaborators\\Listener",
          "type": "::"
        },
        {
          "file": "/var/www/nextcloud/3rdparty/symfony/event-dispatcher/EventDispatcher.php",
          "line": 73,
          "function": "callListeners",
          "class": "Symfony\\Component\\EventDispatcher\\EventDispatcher",
          "type": "->"
        },
        {
          "file": "/var/www/nextcloud/lib/private/EventDispatcher/EventDispatcher.php",
          "line": 94,
          "function": "dispatch",
          "class": "Symfony\\Component\\EventDispatcher\\EventDispatcher",
          "type": "->"
        },
        {
          "file": "/var/www/nextcloud/core/Controller/AutoCompleteController.php",
          "line": 77,
          "function": "dispatch",
          "class": "OC\\EventDispatcher\\EventDispatcher",
          "type": "->"
        },
        {
          "file": "/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
          "line": 230,
          "function": "get",
          "class": "OC\\Core\\Controller\\AutoCompleteController",
          "type": "->"
        },
        {
          "file": "/var/www/nextcloud/lib/private/AppFramework/Http/Dispatcher.php",
          "line": 137,
          "function": "executeController",
          "class": "OC\\AppFramework\\Http\\Dispatcher",
          "type": "->"
        },
        {
          "file": "/var/www/nextcloud/lib/private/AppFramework/App.php",
          "line": 183,
          "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": 65,
          "function": "match",
          "class": "OC\\Route\\Router",
          "type": "->"
        },
        {
          "file": "/var/www/nextcloud/ocs/v2.php",
          "line": 23,
          "args": [
            "/var/www/nextcloud/ocs/v1.php"
          ],
          "function": "require_once"
        }
      ],
      "File": "/var/www/nextcloud/lib/public/Collaboration/AutoComplete/AutoCompleteEvent.php",
      "Line": 76
    },
    "CustomMessage": "Exception thrown: Exception"
  }
}

Expected behavior

Found the user and change the ownership of a table

Actual behavior

Not found user.

Tables app version

0.7.4

Browser

Firefox 128

Client operating system

Linux (but same bug on Windows)

Operating system

Ubuntu 22.04 Server without GUI

Web server

Nginx

PHP engine version

PHP 8.1

Database

MySQL

Additional info

No response

boddedo avatar Jul 17 '24 09:07 boddedo

@boddedo I can't reporduce this. Doesn't seem to be a Tables-specific problem. Are you able to search in other apps? e.g collectives, richdocuments, talk/spreed

enjeck avatar Jul 17 '24 12:07 enjeck

Hello @enjeck ! Thanks for your answer

I checked:

  • notes : the button "share" do nothing, and nothing to share the ownership
  • files : it work, I can transfer my ownership from a folder to anybody
  • deck : I can share and transfer ownership to anybody image
  • collective : I can share to who I want, there is no option for changing ownership
  • form : I can share, but no option for ownership
  • tasks : I can share but no option for ownership
  • talk : I can share, I can add participant, but no option for ownership
  • calendar : I can share, but no option for ownership

I hope it could help you

boddedo avatar Jul 18 '24 14:07 boddedo

Not tables related, and on short glance I cannot pinpoint where the root cause is, but

"Message": "OCP\\Collaboration\\AutoComplete\\AutoCompleteEvent::getItemType(): Return value must be of type string, null returned in file '/var/www/nextcloud/lib/public/Collaboration/AutoComplete/AutoCompleteEvent.php' line 76",

AutoCompleteEvent::getItemType() indeed requires a string, but the newer AutoCompleteFilterEvent::getItemType() also allows null as return value. The Listener checks and requires a AutoCompleteFilterEvent though. Strange.

blizzz avatar Jul 22 '24 11:07 blizzz