nextcloud / nextcloud/richdocuments
Numeric value out of range: 1264 Out of range value for column 'fileid' at row 1
Nobody has claimed this yet.
- Dominant language
- JavaScript
- Stars
- 453
- Forks
- 147
- Avg merge
- 14h 54m
- Merged PRs (30d)
- 83
Description
Describe the bug
Viewing documents now reports " Document loading failed" / "Unauthorised WOPI host. Please try again later and report to your administrator if the issue persists."
See the log at the bottom
To Reproduce
Steps to reproduce the behavior:
- Open any file in Nextcloud
Expected behavior
The file opens
Screenshots
If applicable, add screenshots to help explain your problem.
Client details:
- OS: Ubuntu 24.04
- Browser Firefox
- Version 136.0.1
- Device: Laptop
Server details
Operating system: Ubuntu 24.04
Web server: nginx version: nginx/1.24.0 (Ubuntu)
Database: Server version: 10.11.8-MariaDB-0ubuntu0.24.04.1-log Ubuntu 24.04
PHP version: PHP 8.3.6 (cli) (built: Dec 2 2024 12:36:18) (NTS)
Nextcloud version: Nextcloud Hub 10 (31.0.1)
Version of the richdocuments app 8.6.2
Version of Collabora Online collabora/code:24.04.13.2.1
Configuration of the richdocuments app
{
"apps": {
"richdocuments": {
"canonical_webroot": "https:\/\/cloud.example.com",
"disable_certificate_verification": "",
"doc_format": "odf",
"enabled": "yes",
"external_apps": "",
"installed_version": "8.6.2",
"public_wopi_url": "https:\/\/loo.example.com",
"types": "prevent_group_restriction",
"use_groups": "",
"wopi_allowlist": "192.168.1.1",
"wopi_url": "https:\/\/loo.example.com"
}
}
}
Logs
Nextcloud log (data/nextcloud.log)
Omitted due to post size limit, will attach separately...
Browser log
NA
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by reproducing the failure while opening a file and inspect the richdocuments WOPI flow around the reported fileid database error. Review the Nextcloud log and the MariaDB schema or query involved; done means documents open without the numeric out-of-range error or the resulting WOPI authorization failure.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- javascript, mariadb, php
- Domain
- backend, databases
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 35/100