ONLYOFFICE / onlyoffice-nextcloud

The app which enables the users to edit office documents from Nextcloud using ONLYOFFICE Document Server, allows multiple users to collaborate in real time and to save back those changes to Nextcloud
GNU Affero General Public License v3.0
564 stars 161 forks source link

Documents blank if edited offline #187

Open jharej opened 5 years ago

jharej commented 5 years ago

Hi,

I've searched if anybody has had a similar issue but had no "luck". I've successfully installed Nextcloud and OnlyOffice (with docker). My problem is - online editing works, but if I open the same file directly from disk or download it from Nextcloud and open it in desktop version of Onlyoffice or Libreoffice, it is blank. If I export it directly from online onlyoffice, I can see the whole document. I've also first created a file offline, uploaded it to Nextcloud and edited it with online OnlyOffice. If I open it again offline, I can not see the changes made online. I've attached a screenshoot to present the issue. Am I missing something?

Thanks and bye Janko Izbor_103

alexanderonlyoffice commented 5 years ago

Hello @jharej, please specify some additional information:

  1. OS of the server where ONLYOFFICE Document Server is deployed;
  2. Its installation type (docker or deb/rpm);
  3. Currently installed version of Document Server;
  4. Version of Nextcloud;

It seems that you are downloading the file right after the file is closed. Please wait for a while and check if the new version of the file is saved in Nextcloud (you will see that the size of the file and the time when it was edited will change).

Do you have any errors when clicking on the 'Save' button on integration app address settings page?

jharej commented 5 years ago

I've deployed the server on centos 7.6. Command used

docker run -i -t -d -p 443:443 --restart=always --name=nameonlyoffice -v /etc/letsencrypt/:/certificates -v /var/log/onlyoffice:/app/onlyoffice/DocumentServer/logs -v /var/www/onlyoffice/Data:/app/onlyoffice/DocumentServer/data -v /var/lib/onlyoffice:/app/onlyoffice/DocumentServer/lib -v /var/lib/postgresql:/app/onlyoffice/DocumentServer/db onlyoffice/documentserver

Document editor version is 5.3.4 Nextcloud is version Nextcloud 16.0.3

thank and bye Janko

V V sre., 11. sep. 2019 ob 11:51 je oseba Alexander Zozulya < notifications@github.com> napisala:

Hello @jharej https://github.com/jharej, please specify some additional information:

  1. OS of the server where ONLYOFFICE Document Server is deployed;
  2. Its installation type (docker or deb/rpm);
  3. Currently installed version of Document Server;
  4. Version of Nextcloud;

It seems that you are downloading the file right after the file is closed. Please wait for a while and check if the new version of the file is saved in Nextcloud (you will see that the size of the file and the time when it was edited will change).

Do you have any errors when clicking on the 'Save' button on integration app address settings page?

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/ONLYOFFICE/onlyoffice-owncloud/issues/283?email_source=notifications&email_token=ACTXPCB6KB6I4LFGEZJJL2TQJC5RFA5CNFSM4IVMKPXKYY3PNVWWK3TUL52HS4DFVREXG43VMVBW63LNMVXHJKTDN5WW2ZLOORPWSZGOD6N54LI#issuecomment-530308653, or mute the thread https://github.com/notifications/unsubscribe-auth/ACTXPCFXAJBZR4ERS332U6LQJC5RFANCNFSM4IVMKPXA .

alexanderonlyoffice commented 4 years ago

@jharej, please specify if you checked the scenario I indicated in the previous message:

It seems that you are downloading the file right after the file is closed. Please wait for a while and check if the new version of the file is saved in Nextcloud (you will see that the size of the file and the time when it was edited will change).

Do you get any errors?

Do you have any errors when clicking on the 'Save' button on integration app address settings page?

jharej commented 4 years ago

No. No errors. I haven't downloaded the files prior to closing them.

I've "solved" the problem by installing the newer version of app on nextcloud side and newest version of docker image. All the content that was edited in onlyoffice (just a few files thought) after installation vanished. So it is obvious that content edited in onlyoffice has not been send to nextcloud.

alexanderonlyoffice commented 4 years ago

@jharej,

No. No errors.

You mean on the new installation or you mean that there were no errors on the previous installation when clicking on the 'Save' button.

If you mounted all folders indicated in the installation guide during the previous installation, try to check the folder /app/onlyoffice/DocumentServer/lib/documentserver/App_Data/cache/ for the disappeared files.

tjareson commented 4 years ago

Hello, I have exactly the same issue here, which is a bit fatal for the acceptance, as users start to feel insecure if working online is really safe or if there is always data loss. Also it is impossible to download anything more than an empty document, even if online one see most of the changes done to a document. I'm using the next cloud docker image, version is 18.0.1 with onlyoffice 5.4.2 on ubuntu server 16.04. I've disabled the version app as well, it didn't change anything so far.

The behaviour is kind of erratic: 99% of the times it is not working: newly created files in nextcloud gets shown with the creation date forever, even if updated online several times, even after logging off all users and having a look at it next day. In rare cases it works sometimes, but I didn't find out yet how to reproduce a working update back to nextcloud. And: if I open and close the file within the same user session it is shown as "Document is currently being edited by several users", which doesn't make a lot of sense, as it is the same user in the same session. I've read about several similar cases, but nowhere there was a solution posted for it. I wonder if no one else is using the online editing? As I'm using a docker image, I also expect no bigger configuration issue, as the rest is working pretty well. A solution would be highly appreciated. Tjareson

tjareson commented 4 years ago

The (supposedly) temporary data in /appdata_.../documentservercommunity/doc... are also not processed, so remain there and only change (Editor.bin) when the document is edited online in onlyoffice. (I had one case where it worked, so I know that the temp-directory should disappear after document is built and copied back) The difference I could see between working and not working case was, that in case where it worked I could also see a copy of the original file in that temp directory for the time the file was edited. In all other cases there is only Editor.bin, filedid and owner. Is there any way to force creating the document out of Editor.bin and write it back to nextcloud?

LinneyS commented 4 years ago

@jharej I've "solved" the problem ...

Could you please specify if the problem recurs or we can close the topic?

@tjareson Verify that all ONLYOFFICE services are running correctly. Make sure the settings point to the docker version of ONLYOFFICE and not to the integrated Nextcloud Community Documentserver. Is saving connection settings successful? If the problem persists, please create a separate issue.

tjareson commented 4 years ago

I think my problem is related to the integrated Nextcloud Community Documentserver, as I installed the docker image 18.0.1 from nextcloud where this is preconfigured that way. It's a bit confusing, as there are several ways and versions how one can put that together. Still the issue as such remains. I'm not sure when and how they trigger the build of the document in this integrated community version, but exactly that doesn't seem to work. Not sure who would have the knowledge about it. Nextcloud-Community? Or Onlyoffice-Community?

LinneyS commented 4 years ago

@tjareson Try disabling the Nextcloud Community Documentserver application in the Nextcloud application list. Then go to the ONLYOFFICE settings and specify the correct addresses for your ONLYOFFICE 5.4.2 instance. Any errors while saving settings? If so, then let's open a new issue on your problem.

Jolopu commented 4 years ago

I have the same issue. I can create and edit documents online in OnlyOffice. Then they get saved locally by the Nextcloud Client. When I open the local version the document is blank. I use: Nextcloud 18.0.2 on a shared hosting Community Document Server 0.1.5 ONLYOFFICE 4.1.4

Moltey commented 4 years ago

+1 Same here - the xlsx file is created and modified in onlyoffice. The file is synced with clients. However, the xlsx files are empty in the local client.

Nextcloud 18.0.4 (private server) Community Document Server 0.1.5 ONLYOFFICE 4.1.4

Edit: If I save the file manually with "save as" the file is no longer empty on the clients.

Xananax commented 4 years ago

Saving as a new xlsx and opening the document localy in libreOffice Calc: The document isn't blank anymore when opened locally.

However, subsequent changes are not picked up by Calc. In other words, it seems the way OpenOffice saves data isn't compatible with Calc.

I've tried turning off autosave, and saving manually, but the document still doesn't sync. The only way to read data seems to be Save As, which is a bummer.

Edit: same behavior with an .ods file.

ClundXIII commented 4 years ago

We have the same issue. I have sent a mail to support since we recently bought the integrative edition. This is not acceptable. If the save fails, onlyoffice should stop working in general.

In general, why does onlyoffice even save any documents? It should be stateless to avoid exactly this kind of problem. If it would discard the document every time we would have recognized the problem way earlier before being at risk of loosing so much work.

Xananax commented 4 years ago

It doesn't fail to save, it doesn't discard the document. It does save. If you only use OnlyOffice in Nextcloud, you will not see any problem. The issue arises only when opening the same file in OpenOffice on your desktop.

ClundXIII commented 4 years ago

Nextcloud does not recognize any change (in my case). Does not matter if I download from nextcloud (not onlyoffice), synchronize and open or look at the "last changed" information.

narFnarF commented 2 years ago

I have the same problem.

Steps to reproduce:

  1. On Nextcloud, install Community Document Server from the app store
  2. install the ONLYOFFICE app from the same app store
  3. In Nextcloud Files, create a new .xlsx document and open it.
  4. Write something in any cell. Save and close.
  5. Wait 1 minute.
  6. On your computer, install the Nextcloud Sync client
  7. Sync your Nextcloud files to your local computer
  8. In File Explorer (on Windows), navigate to the synced folder and to the file created earlier. Right-click and open this file with OnlyOffice (or LibreOffice)
  9. Observe that the file is blank. Expected result: The text written in the file at step # 4 should be visible.

My setup

OnlyOffice

Desktop version: 7.0.0.127 OnlyOffice app for Nextcloud: 7.3.0 Community Document Server: 0.1.12

Nextcloud Server

Version: 22.2.3

Database:

mysql 8.0.28 267.5 MB

PHP:

7.4.3 Memory Limit: 512 MB Max Execution Time: 3600 Upload max size: 2 GB

Nextcloud Desktop Client

Version 3.4.2 (Windows)

Jolopu commented 2 years ago

I gave up on this. Better switch to Collabora Online. This is supposed to be the future standard in Nextcloud.

ShockwaveNN commented 2 years ago

I saw a lot of questions in this thread are raised about Community Document Server

Please note that Community Document Server was developed by Nextcloud Team, if you have any issues with it, please contact them in the appropriate GitHub repository.

We (ONLYOFFICE team) cannot help with those issues at all, this product was not developed by us

diwacreation3 commented 1 year ago

Hey i ran into this problem How do i fix? if i try to export onlyoffice doc file i ended up downloading blank and sometimes it shows This cURL error 60: SSL certificate problem: self signed certificate (see https://curl.haxx.se/libcurl/c/libcurl-errors.html) for https://10.16.19.100/index.php/apps/documentserver_community/ConvertService.ashx i have Self-signed certificate on my local server any Solution?