We have nextcloud installed and the onlyoffice app and are using the community document server installed via nextcloud app. Now changes in documents are only reflected when opening the document in onlyoffice. Downloading said document it shows up in local libreoffice in an old version. On a non nethserver nextcloud I have a similar problem, but there it is possible to workaround by save copy as documenttype from within onlyoffice. But in neth nextcloud/onlyoffice there is an a message: Unknown error apearing in webinterface.
Aparently the changes in documents by onlyoffice are reflected only in a database, but not flushed back to the filesystem.
Please let me know, what info I can provide to further debug this situation and find a fix/solution.
There is much colaborative work in the files modified with onlyoffice, so the actual version of the files are crucial to us. Thanks in advance on helping me flush the db content to filesystem. For safety reasons I did a backup, so any instruction will be very apreceated.
The modifications just in db (thus visible in onlyoffice) but not in filesystem thus not reflected when office document is downloaded should somehow be possible to at least workaround by somehow doing a manual flush from within console with occ command. It would be quite important to be able to do this, as they worked colaborative some days on those files.
I have seen, that they also have embeded some documents within the office document. As that was not supported by onlyoffice, they had downloaded the files, done that with a local libreoffice, and uploaded it back to the nextcloud…
Executing occ documentserver:flush as root in shell did not help either… I don’t know, if a server reboot will help, but I’ll try tonite to see where it gets. If I could only get the status of the files written to the disk, I would then try if libreoffice-online is the way to go, but first I need the files downloadable with the latest versions. Tried disabling ransomeware detection, but no luck with that one either…
Any logs I could check to find the source and hopefully fix?
Is there a possibility to see log from document server? If I could get rid of the unknown error message, at least we could File/Save copy as from within onlyoffice to get files downloaded with latest version.
I also rebooted the server and reinstalled community document server and onlyoffice apps. Did not help…
From what I’ve read, it happens with the Community Document Server (aka nextcloud’s document server app) and probably does not happen with the document server installed for instance with mrmarkuz module.
As you posted, there are open pinned issues:
The most important thing for me is to get the content in database of onlyoffice back to the filesystem so the files can get downloaded with their newest version. All else can be evaluated later, like dnutans recomandation on having a look at community repos.
WHAT BECAME CLEAR FOR ME ONLY NOW IS THAT ONLYOFFICE APP FROM NEXTCLOUD IS IN NO WAY READY FOR PRODUCTION!
Also colabora online obviously is also more than just a matter of activating the two apps built-in code server and colabora online app.
Edit to add that at least download copy as pdf from within onlyoffice seems to work. Not ideal, but at least one can download the files as pdfs…
Sorry, I’ve corrected my post, I meant to open developer console with Strg+Shift+I or F12 works also.
After opening it, try to save the file. After that, I learned from @stephdl, you see the command which was sent and you can copy it to a terminal and execute for more information.
## Interner Serverfehler
Der Server konnte die Anfrage nicht fertig stellen.
Sollte dies erneut auftreten, sende bitte die nachfolgenden technischen Einzelheiten an Deinen Server-Administrator.
Weitere Details können im Server-Protokoll gefunden werden.
### Technische Details
* Entfernte Adresse: 192.168.x.y
* Anfragekennung: YLY0WlNaIdsk5B@vMXlzJAAAAAk
[Nextcloud](https://nextcloud.com) – ein sicherer Ort für all Deine Daten
Yes, I can confirm this. The Nextcloud php version has issue was reliable data saving. It seems to work if in Nextcloud you use ajax in background tasks, but I would not trust it. Note - cron is the recommend way to do background tasks. This is a pity because this php version has reallowed mobile editing and has no 20 user limits.
I can confirm there is no issues with mrmarkuz’s onlyoffice [NethServer Wiki] or with Nextcloud app OnlyOffice connector working with a standalone OnlyOffice installation.
Thanks for posting this. I would love to try mrmarkuz version, but my problem is that for a project members have worked on documents within actual onlyoffice (nextcloud app) installation, and I cannot afford to loose all this work, thus I don’t know if the filechanges currently only saved in the database could would still be available if I remove the nextcloud app onlyoffice and follow mrmarkuz guide during this project at least maybe better wait and make the transistion afterwards.
If I switch setting to ajax cron - is there a way to push a flush in order to check if then changes are written back to the filesystem?
Thanks for the suggestion, but I have not the time to do so I am afraid. So I think we’ll use onlyoffice till this project finishes, then will ditch onlyoffice app and evaluate if we want to use either @mrmarkuz onlyoffice or if for production libreoffice would be more suitable. Would you consider onlyoffice from mrmarkuz production ready?
I really would like to know how I can trigger this ajax cron job once changed in the nextcloud settings to see if this could be a possible workaround.
Yes, you do not want to break the connection until you make a save.
Hopefully there is not too many Onlyoffice files so my suggestion is viable. I would open the cached Onlyoffice files then copy and paste the content into a Onlyoffice local desktop install, saving each Onlyoffice file locally. Then upload back to Nextcloud.
If there are too many Onlyoffice files with cache changes to do this process I am unsure what to suggest. But I will say that any disturbance to the OnlyOffice connection including a restart will result data loss.
Maybe if you snapshot where you are you can try of few things.