[Bug]: Cannot restore deleted share

[tomdeck]

⚠️ This issue respects the following points: ⚠️

• [X] This is a bug, not a question or a configuration/webserver/proxy issue.
• [X] This issue is not already reported on Github (I've searched it).
• [X] Nextcloud Server is up to date. See Maintenance and Release Schedule for supported versions.
• [X] Nextcloud Server is running on 64bit capable CPU, PHP and OS.
• [X] I agree to follow Nextcloud's Code of Conduct.

Bug description

The site admin user shared a folder with my user. I removed this share and it shows up in "Deleted shares" as expected. However, when I click on the "Restore" button next to it, this fails and gives the error "Something happened. Unable to restore the share."

Steps to reproduce

1. Share a folder with another user
2. As this other user, delete the share
3. Still as this other user, try to restore the share. It fails with "Something happened. Unable to restore the share."

The log contains the following: Doctrine\DBAL\Exception\DriverException: An exception occurred while executing a query: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type bigint: "9,ocinternal:10"

To resolve the issue, I tried upgrading nextcloud server step by step (24.0.6 -> 24.0.7 -> 25.0.1) ; it didn' help. I got the exact same error in each version.

Expected behavior

No error, just the share restored of course.

Installation method

Community Manual installation with Archive

Operating system

No response

PHP engine version

PHP 7.4

Web server

Apache (supported)

Database engine version

PostgreSQL

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

Updated from a minor version (ex. 22.2.3 to 22.2.4)

Are you using the Nextcloud Server Encryption module?

Encryption is Disabled

What user-backends are you using?

• [X] Default user-backend (database)
• [ ] LDAP/ Active Directory
• [ ] SSO - SAML
• [ ] Other

Configuration report

No response

List of activated Apps

Enabled:
  - admin_audit: 1.15.0
  - calendar: 4.1.0
  - cloud_federation_api: 1.8.0
  - cms_pico: 1.0.21
  - comments: 1.15.0
  - dav: 1.24.0
  - federatedfilesharing: 1.15.0
  - federation: 1.15.0
  - files: 1.20.1
  - files_external: 1.17.0
  - files_pdfviewer: 2.6.0
  - files_rightclick: 1.4.0
  - files_sharing: 1.17.0
  - files_trashbin: 1.15.0
  - firstrunwizard: 2.14.0
  - logreader: 2.10.0
  - lookup_server_connector: 1.13.0
  - oauth2: 1.13.0
  - password_policy: 1.15.0
  - photos: 2.0.0
  - provisioning_api: 1.15.0
  - rainloop: 7.2.6
  - related_resources: 1.0.3
  - settings: 1.7.0
  - text: 3.6.0
  - theming: 2.0.1
  - twofactor_backupcodes: 1.14.0
  - updatenotification: 1.15.0
  - viewer: 1.9.0
  - workflowengine: 2.7.0
Disabled:
  - activity: 2.13.4
  - bruteforcesettings: 2.0.1
  - circles: 22.2.0
  - contactsinteraction: 1.3.0
  - dashboard: 7.0.0
  - encryption
  - files_versions: 1.13.0
  - nextcloud_announcements: 1.9.0
  - notifications: 2.8.0
  - privacy: 1.4.0
  - recommendations: 0.8.0
  - serverinfo: 1.10.0
  - sharebymail: 1.10.0
  - support: 1.3.0
  - survey_client: 1.8.0
  - suspicious_login
  - systemtags: 1.12.0
  - twofactor_totp
  - user_ldap
  - user_status: 1.0.1
  - weather_status: 1.0.0

Nextcloud Signing status

No response

Nextcloud Logs

Doctrine\DBAL\Exception\DriverException: An exception occurred while executing a query: SQLSTATE[22P02]: Invalid text representation: 7 ERROR: invalid input syntax for type bigint: "9,ocinternal:10"

Additional info

No response