Problem inserting a graph in calc

[quelo1972]

I have ubuntu-server 16.04 LTS with nextcloud installed and working, I installed the docker image of collabora code and work with nextcloud. But when I insert a graph in calc and click on "Save" I have the error below: translated from the italian "Unable to save document to storage space. Check your permissions or contact the storage server administrator."

What's the problem?

[quelo1972]

In the docker log I have the following ERR when I click on "Save":

mwsd-00026-00041 12:59:46.806779 [ docbroker_001 ] ERR Cannot save docKey [/nextcloud/apps/richdocuments/wopi/files/1664_ocvfyj3y2l3m], the .uno:Save has failed in LOK.| wsd/DocumentBroker.cpp:758

[quelo1972]

Is there anyone that tryed to reproduce and then solve the problem?

[ghost]

I tried to reproduce it but for me its working without any problem. Do you have any error in the nextcloud log when you get this?

[quelo1972]

In the docker container I have the following error:

mwsd-00026-00041 12:59:46.806779 [ docbroker_001 ] ERR Cannot save docKey [/nextcloud/apps/richdocuments/wopi/files/1664_ocvfyj3y2l3m], the .uno:Save has failed in LOK.| wsd/DocumentBroker.cpp:758

Where is the nextcloud log?

[ghost]

In the Nextcloud settings -> logs. You need to be admin to see them of course.

[quelo1972]

No errors in nextcloud log.

[ghost]

When you go to the about screen, which version do you see? I mean the about screen of collabora online.

[quelo1972]

[ghost]

Do you use any kind of encryption in nextcloud?

[quelo1972]

I don't use any kind of encryption... I think... How can I verify this with certainty? Unfortunately I'm not very expert with docker. How can I update the collabora image without re-download it?

[ghost]

But I have an idea: How did you installed your nextcloud installation? Which "tutorial" did you use?

[quelo1972]

I used the following tutorial https://bayton.org/docs/nextcloud/installing-nextcloud-on-ubuntu-16-04-lts-with-redis-apcu-ssl-apache/

[ghost]

Can you go to the /nextcloud/apps/richdocuments/wopi/files directory and type "ls -l" and paste the result here? Or at least so far how it works for you like /nextcloud/apps/richdocuments

[quelo1972]

cd /var/www/html/nextcloud/apps/richdocuments/wopi/files
-bash: cd: /var/www/html/nextcloud/apps/richdocuments/wopi/files: File o directory non esistente

[ghost]

yeah and there (/var/www/html/nextcloud/apps/richdocuments or /var/www/html/nextcloud/apps/richdocuments/wopi or /var/www/html/nextcloud/apps/richdocuments/wopi/files) please type in "ls -l" as far as it works. And btw - your collabora app in nextcloud is also up to date? YOURWEBSITE.tld/settings/apps?category=enabled#

[quelo1972]

The directory /var/www/html/nextcloud/apps/richdocuments/wopi/files doesn't exists! the version of collabora code app in nextcloud is

[ghost]

Then please use ls -l in the /var/www/html/nextcloud/apps/richdocuments/wopi or /var/www/html/nextcloud/apps/richdocuments/wopi/wopi dictionary. I want to check the file permissions.

[quelo1972]

there is not any wopi dir as you can see below

root@DROP02:/var/www/html/nextcloud/apps/richdocuments# ls -la
totale 52
drwxr-xr-x 10 www-data www-data 4096 mag  4 16:22 .
drwxr-xr-x 57 www-data www-data 4096 mag  7 19:49 ..
drwxr-xr-x  2 www-data www-data 4096 mag  4 16:22 appinfo
drwxr-xr-x  2 www-data www-data 4096 mag  4 16:22 assets
-rw-r--r--  1 www-data www-data 2121 mag  4 16:22 CHANGELOG.md
drwxr-xr-x  3 www-data www-data 4096 mag  4 16:22 css
drwxr-xr-x  2 www-data www-data 4096 mag  4 16:22 img
-rw-r--r--  1 www-data www-data 3124 mag  4 16:22 issue_template.md
drwxr-xr-x  3 www-data www-data 4096 mag  4 16:22 js
drwxr-xr-x  2 www-data www-data 4096 mag  4 16:22 l10n
drwxr-xr-x  7 www-data www-data 4096 mag  4 16:22 lib
-rw-r--r--  1 www-data www-data 2786 mag  4 16:22 README.md
drwxr-xr-x  2 www-data www-data 4096 mag  4 16:22 templates
root@DROP02:/var/www/html/nextcloud/apps/richdocuments#

[thebearon]

Indeed, the save failes with a chart in the spreadsheet, but only if you click save. Closing the file triggers an automatic save, which succeeds (provided no manual save was attempted beforehand).

[quelo1972]

@thebearon now I can't try this because I'm downloading the latest docker image of collabora/code

[ghost]

@quelo1972 @thebearon is right. I tested it with an new spreadsheet and clicking on save isnt working. But with an old one it was first working for me .. hm. Automatic save is working, just close the document with the red x of collabora online, it's sometimes not saving for me if I just close the browser tab.

---

And @quelo1972 sry for wasting your time, I should have try it with a new spreadsheet also.

[quelo1972]

@s-john19 @thebearon for me authomatic saving clicking on the red X doesn't work when I re-open the document is a blank spreadsheet! :(

[quelo1972]

@s-john19

Do you use any kind of encryption in nextcloud? And btw can you do me a favor? Can you pull the latest docker image of CODE and go into languages? Do you still see the dictionaries (DE, IT, EN, ..)?

Why I don't have anymore the languages? Before I have it!!!

[ghost]

@quelo1972 Its because of the new version pushed to the docker hub. Which languages do you need? I can give you the copy and paste lines to get them back. I just wanted to know if it's a bug only for me, because it was working for others.

And don't worry. No need for a new download.

[quelo1972]

I need Italian and english how can I add them?

[quelo1972]

@s-john19 @thebearon have you any idea to the "save" problems? Why for me the automatic saving doesn't work? Why doesn't work clicking on save button and the document isn't saved when there is a chart in the spreadsheet?

[ghost]

Ok here are the lines:

docker ps 

to see the new name of the container (it should be the last one, a random name you can also take the container id)

It should be like:

CONTAINER ID        IMAGE                              COMMAND                  CREATED             STATUS              PORTS                      NAMES
26df0f1f6863        collabora/code   "/bin/sh -c 'bash st…"   21 hours ago        Up 21 hours         127.0.0.1:9980->9980/tcp   office (THIS would be the name)

Now type in this:

docker exec -it IDorNAME bash

And then:

mkdir -p /usr/share/hunspell
mkdir -p /usr/share/hyphen
mkdir -p /usr/share/mythes
mkdir -p /opt/lool/systemplate/usr/share/hyphen

for i in `find /opt/collaboraoffice5.3/share/extensions/ -name hyph*.dic`;do cp $i /opt/lool/systemplate/usr/share/hyphen;done
for i in `find /opt/collaboraoffice5.3/share/extensions/ -name hyph*.dic`;do cp $i /usr/share/hyphen;done

for it:

cp /opt/collaboraoffice5.3/share/extensions/dict-it/it_IT.* /usr/share/hunspell
cp /opt/collaboraoffice5.3/share/extensions/dict-it/th_it_IT_v2.dat /usr/share/mythes
cp /opt/collaboraoffice5.3/share/extensions/dict-it/th_it_IT_v2.idx /usr/share/mythes

for en_US:

cp /opt/collaboraoffice5.3/share/extensions/dict-en/en_US.* /usr/share/hunspell
cp /opt/collaboraoffice5.3/share/extensions/dict-en/th_en_US_v2.dat /usr/share/mythes
cp /opt/collaboraoffice5.3/share/extensions/dict-en/th_en_US_v2.idx /usr/share/mythes

When you are finished use

exit

and

docker stop IDorNAME
docker start IDorNAME

The dictionaries should be back :) And you only need this to do one time, so not on every restart.

[quelo1972]

The problem is there also if I use libreoffice/online docker image instead collabora/code!!!

[ghost]

@quelo1972 and about the auto save: Try to create a new spreadsheet, add something to it, click on the normal save button, add a chart - wait 5 minutes - click on x of collabora online.

It could be a problem of a slow internet connection.

[ghost]

@quelo1972 and thank you, now I know its not just me where the dictionaries are not showing up without the lines.

Please confirm here if you see the dictionaries again and if auto save is working with the waittime :)

[quelo1972]

@s-john19

root@216f75ca2275:/# for i in find /opt/collaboraoffice5.3/share/extensions/ -name hyph*.dic;do cp $i /opt/lool/systemplate/ue/hyphen;done
cp: cannot stat 'find': No such file or directory
cp: omitting directory '/opt/collaboraoffice5.3/share/extensions/'
cp: invalid option -- 'm'
Try 'cp --help' for more information.
cp: cannot stat 'hyph*.dic': No such file or directory

[ghost]

@quelo1972 Just copy the hole line, in your line there is an mistype "/opt/lool/systemplate/ue/hyphen" instead of "/opt/lool/systemplate/usr/share/hyphen;done" - in putty you can paste things with right click.

[ghost]

@quelo1972 A new docker image is out now where dictionaries are working again. If you still have problems with my lines you can download it again, but it should work without any problem with my lines.

[quelo1972]

No, wait for 5 minutes didn't work for me, after click to Red X button the spreadsheet is closed but the chart is not saved. I re pull the docker image and Now I nave the languages. But the "save" button still return the error when a chart is present.

[ghost]

@quelo1972 Great that you have the dictionaries again. About auto save - do you see anything in the logs of collabora? For me its working. I created a test sheet -> Added a chart -> clicked on the x -> got back to the document and the chart was still there.

But now they know about the bug, that the save button is not working - so it should get fixed

[quelo1972]

Where is the logs of collabora?

[ghost]

@quelo1972 I mean the same logs like you got this "mwsd-00026-00041 12:59:46.806779 [ docbroker_001 ] ERR Cannot save docKey [/nextcloud/apps/richdocuments/wopi/files/1664_ocvfyj3y2l3m], the .uno:Save has failed in LOK.| wsd/DocumentBroker.cpp:758"

[quelo1972]

I have the following error continuously

mwsd-00027-00054 21:17:32.272178 [ docbroker_003 ] WRN  Attempted ping on non-upgraded websocket!| ./net/WebSocketHandler.hpp:280
,
mwsd-00027-00054 21:18:53.529527 [ docbroker_003 ] WRN  Attempted ping on non-upgraded websocket!| ./net/WebSocketHandler.hpp:280

[quelo1972]

Is there any information about how to fix the problem?

[timar]

Version 3.2.2 was released 12 days ago, have not you pulled it? It was a bugfix release. In the previous version, the explicit save using the toolbar button could fail with .odf files containing charts. Other formats like .xls or .xlsx, and auto-saving of .odf were not affected.

The CODE docker images now contain all the available dictionaries and thesauri. A new environment variable can be set to specify the appropriate subset of languages to be used at runtime. See also: https://www.collaboraoffice.com/code/

[quelo1972]

For me still doesn't work! I've removed container and the image and the pulled the new image and started container.

Still I have error after saving a spreadsheet containing a chart!

[quelo1972]

@timar In fact the version is not 3.2.2 but 3.2.0 as you can see below

[timar]

REPOSITORY TAG IMAGE ID CREATED SIZE collabora/code latest d5900995e7eb 12 days ago 1.54GB

loolforkit version details: 3.2.2 - ffc419a

[quelo1972]

Excuse me but I'm not a docker expert (I'm newbye!) how can I pull this image? I have done

docker pull collabora/code
docker run -t -i -d -p 127.0.0.1:9980:9980 -e 'domain=drop\.ddns\.net' --restart unless-stopped --cap-add MKNOD collabora/code

[quelo1972]

excuse me I was wrong!!! Now the version is right... But the saving a spreadsheet containing a chart still doesn't work!!!

[quelo1972]

Can you re-open the issue please?

[quelo1972]

Can you reopen the issue? I still have this problem, is there anyone can help me to solve it?

Thanks.