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
559 stars 158 forks source link

After Upgrade to 9.1.0 Nextcloud not connected to onlyoffice server #977

Closed syntezit closed 5 months ago

syntezit commented 5 months ago

After Upgrade to 9.1.0, Nextcloud not connected to onlyoffice server. Nextcloud 28.0.4 Onlyoffice 8.0.1

Errors Could not find resource onlyoffice/js/onlyoffice-template.js to load {"reqId":"t1ol3FPfmGk44gNOLLZ2", "level":3, "time":"2024-04-08T17:34:56+03:00", "remoteAddr":"172.16.0.20", "user":"12345", "app":"jsresourceloader", "method":"GET", "url":"/settings/admin/onlyoffice","message":"Could not find resource onlyoffice/js/onlyoffice-template.js to load", "userAgent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.0.0 Safari/537.36", "version":"28.0.4.1", "data":{"app":"jsresourceloader"}, "id":"661400959c75b"}

JacobMembrino commented 5 months ago

Having this issue as well. I noticed that restoring the lost files (the entire JS directory under nextcloud/apps/onlyoffice/js) from a backup does not work. These files seem to be generated at install in previous versions but this no longer works.

edit: using a fresh install of onlyoffice 8.0.1-31 and nextcloud 28.0.4 (just updated) with the 9.0.1 plugin.

Nikos-Mennecy commented 5 months ago

Same problem After Upgrade to 9.1.0 Nextcloud 28.0.4 PHP 8.3.4

In the Nextcloud logs :

Could not find resource onlyoffice/js/onlyoffice-listener.js to load Could not find resource onlyoffice/js/onlyoffice-viewer.js to load Could not find resource onlyoffice/js/onlyoffice-template.js to load Could not find resource onlyoffice/js/onlyoffice-main.js to load Could not find resource onlyoffice/js/onlyoffice-desktop.js to load Could not find resource onlyoffice/js/desktop.js to load

Since version 9.1.0 the js folder (/apps/onlyoffice/js) has disappeared.

Seems to work good copying the js directory from version 9.0.0 to 9.1.0 ;+)

Thanks !

blcetux commented 5 months ago

Same problem after upgrade to 9.1.0

We've reverted to 8.2.4 in the meantime.

alyfilipe commented 5 months ago

Some problem here

waja commented 5 months ago

Downgrade to the app version 9.0.0 fixed the issue for now.

arnowelzel commented 5 months ago

Same issue here. Something went wrong with the 9.1.0 release. But even after downgrading to 9.0.0 it does not work any longer :-(

In fact I can not use OnlyOffice any longer at all! I completely removed the app and reinstalled it - now it only complains that the document server is not available, but this is not correct - it worked fine with version 9.0.0. But somehow the upgrade to 9.1.0 changed something, that even 9.0.0 does not work anymore.

In addition the OnlyOffice settings also don't work any longer. What ever I enter to "ONLYOFFICE Docs address" is just ignored. The whole form is completely without any function:

image

I tried everything including restoring the last known working version from my backup - it does not work any longer.


Got it working again.

I removed the setting for the document server URL in the Nextcloud appconfig table:

update oc_appconfig set configValue='' where appid='onlyoffice' and configKey='DocumentServerUrl';

Then the administration part of OnlyOffice worked again - I could now enter the old URL again and OnlyOffice also realized that the server is available.

Considering what files 9.1.0 tries to install it seems that this is not an correct build but just a plain 1:1 copy of the GitHub repository. The required folder js is missing but other files got included which are not needed:

.gitmodules
package.json
ruleset.xml
webpack.js
JacobMembrino commented 5 months ago

I tried everything including restoring the last known working version from my backup - it does not work any longer.

Run these commands:

$ sudo -u www-data php occ app:disable onlyoffice
$ sudo -u www-data php occ app:remove onlyoffice
$ sudo -u www-data php occ maintenance:repair

Then install the last release, unpack it to the /apps/ directory of nextcloud, and change its ownership to your web hosting user (www-data).

I am getting the "Error connection: Error occurred in the document service: Error while downloading the document file to be converted."' error but I can get the plugin to almost work at least.

arnowelzel commented 5 months ago

I am getting the "Error connection: Error occurred in the document service: Error while downloading the document file to be converted."' error but I can get the plugin to almost work at least.

See my last comment edit - I had to remove the URL setting from the appconfig table in Nextcloud, but after that I was able to configure OnlyOffice again.

JacobMembrino commented 5 months ago

See my last comment edit - I had to remove the URL setting from the appconfig table in Nextcloud, but after that I was able to configure OnlyOffice again.

Any thoughts on the Error connection: Error occurred in the document service: Error while downloading the document file to be converted error?

arnowelzel commented 5 months ago

See my last comment edit - I had to remove the URL setting from the appconfig table in Nextcloud, but after that I was able to configure OnlyOffice again.

Any thoughts on the Error connection: Error occurred in the document service: Error while downloading the document file to be converted error?

Sorry - no. I don't have this error here. Neither with DOCX nor with ODT or other formats. But there is an older issue which mentions this: https://github.com/ONLYOFFICE/onlyoffice-nextcloud/issues/895

stepcellwolf commented 5 months ago

Same here!

a0g83agbc84 commented 5 months ago

I unfortunately am experiencing the same issue...

alyfilipe commented 5 months ago

A problem like this for a stable package is quite complicated. We will have to act by migrating the solution to another platform, as the company is completely at a standstill.

a0g83agbc84 commented 5 months ago

This guy seems to be onto something but not even clearing the values from the db empties them from the onlyoffice configuration page, not even after deleting and reinstalling the app: https://github.com/ONLYOFFICE/onlyoffice-nextcloud/issues/956#issuecomment-2043295196

arnowelzel commented 5 months ago

This guy seems to be onto something but not even clearing the values from the db empties them from the onlyoffice configuration page, not even after deleting and reinstalling the app: #956 (comment)

The database table oc_appconfig is the only place where the app stores the configuration. If removing the value there does not work, then maybe you need to clear the browser cache, so it has to load the value from the DB.

a0g83agbc84 commented 5 months ago

@arnowelzel something seems off, because I cleared the browser data (even tried on incognito mode) and I can see the previous values every time. Those values are clearly empty in the db: https://i.imgur.com/KzWHEIn.jpeg

arnowelzel commented 5 months ago

@arnowelzel something seems off, because I cleared the browser data (even tried on incognito mode) and I can see the previous values every time. Those values are clearly empty in the db: https://i.imgur.com/KzWHEIn.jpeg

Strange - for me that worked fine and I have no idea from where else OnlyOffice should get the value from.

Maybe restart php-fpm just to be sure, that also the PHP opcache is flushed?

t3cneo commented 5 months ago

It does work after copying 9.0.0 js folder as @Nikos-Mennecy pointed out

on your server :

1 grab the 9.0 relaease

wget https://github.com/ONLYOFFICE/onlyoffice-nextcloud/releases/download/v9.0.0/onlyoffice.tar.gz

2 expend

tar -xf onlyoffice.tar.gz

3 copy js folder to where it should be

sudo cp -R onlyoffice/js/ /var/lib/docker/volumes/nextcloud_aio_nextcloud/_data/custom_apps/onlyoffice/js

4 change ownership

sudo chown -R www-data:www-data /var/lib/docker/volumes/nextcloud_aio_nextcloud/_data/custom_apps/onlyoffice/js

5 cleanup a bit

rm -rf onlyoffice onlyoffice.tar.gz

6 go to NC webUI > admin settings > OnlyOffice and hit save

Edit : I guess the new gitignore file is the explanation...

a0g83agbc84 commented 5 months ago

@arnowelzel something seems off, because I cleared the browser data (even tried on incognito mode) and I can see the previous values every time. Those values are clearly empty in the db: https://i.imgur.com/KzWHEIn.jpeg

Strange - for me that worked fine and I have no idea from where else OnlyOffice should get the value from.

Maybe restart php-fpm just to be sure, that also the PHP opcache is flushed?

I use docker compose with the nextcloud instance, its db, nginx, onlyoffice and redit. I take it down and then back up -d. Strange.

alyfilipe commented 5 months ago

It does work after copying 9.0.0 js folder as @Nikos-Mennecy pointed out

on your server :

1 grab the 9.0 relaease

wget https://github.com/ONLYOFFICE/onlyoffice-nextcloud/releases/download/v9.0.0/onlyoffice.tar.gz

2 expend

tar -xf onlyoffice.tar.gz

3 copy js folder to where it should be

sudo cp -R onlyoffice/js/ /var/lib/docker/volumes/nextcloud_aio_nextcloud/_data/custom_apps/onlyoffice/js

4 change ownership

sudo chown -R www-data:www-data /var/lib/docker/volumes/nextcloud_aio_nextcloud/_data/custom_apps/onlyoffice/js

5 cleanup a bit

rm -rf onlyoffice onlyoffice.tar.gz

6 go to NC webUI > admin settings > OnlyOffice and hit save

Edit : I guess the new gitignore file is the explanation...

Using this option it saves the onlyoffice configuration, but when I try to open a document, it keeps trying forever.... Direct tests on the onlyoffice server work normally. Only the integration has a problem following the plugin update.

kiwiradler commented 5 months ago

Wouldn't it be better to release an update to v.9.1.1 or whatever instead of finding workarounds? Not everyone is able to do all this stuff on his server...

JacobMembrino commented 5 months ago

Any thoughts on the Error connection: Error occurred in the document service: Error while downloading the document file to be converted error?

If anyone experiences this error, I was able to fix it after adding this line to my config file in nextcloud:

'onlyoffice' => array (
    'verify_peer_off' => false,
  ),

And rebooting the server.

arnowelzel commented 5 months ago

Wouldn't it be better to release an update to v.9.1.1 or whatever instead of finding workarounds? Not everyone is able to do all this stuff on his server...

Of course - but until then it might help people what to do to get their installation back running.

a0g83agbc84 commented 5 months ago

@arnowelzel the fact that onlyoffice kept the configuration even though I was deleting the values from the db remains a mystery, but at least I could fix my setup. I could have saved myself almost 1 hour or trial and error if I had gotten enough sleep last night and used the correct custom_apps directory :) Thanks for your help.

vagner-dias commented 5 months ago

Same problem here. OnlyOffice is down after the latest upgrade.

Nordlead75 commented 5 months ago

same problem for me too

masterwishx commented 5 months ago

same issue :

image

JacobMembrino commented 5 months ago

same issue :

Luckily all you have to do is uninstall the new version of the connector app and install the last release. The commands to do so are above

HB9HIL commented 5 months ago

same issue here... can't get it to work even with the tips above

HB9HIL commented 5 months ago

Wouldn't it be better to release an update to v.9.1.1 or whatever instead of finding workarounds? Not everyone is able to do all this stuff on his server...

absolutely! hotfix release please

jdaviescoates commented 5 months ago

I find it completely bonkers that such an important and widely used plugin that so many people and organisations depend on was not properly tested before being released :man_facepalming:

jdaviescoates commented 5 months ago

Luckily all you have to do is uninstall the new version of the connector app and install the last release. The commands to do so are above

For many people that is evidently not all you have to do.

An fixed update to this needs to be released urgently.

vagner-dias commented 5 months ago

@LinneyS - Please help on this issue - is cause massive problems

Leprazoriy commented 5 months ago

Urgently withdraw version 9.1.0! Stopped our office work.

DragDrop69 commented 5 months ago

same thing.. Nextcloud Snap can't work with Onlyoffice Docs Server aftel last update to 9.1.0

Onlyoffice app version - 9.1.0 Nextcloud Snap version 27.1.7

maybe give me manual about downgrade Onlyoffice app in Nextcloud Snap

Scriptkiddi commented 5 months ago

Onlyoffice 7.10 is also affected

phreaker0 commented 5 months ago

just installed v9.1.2 from the release page and can confirm that it works, thx.

mmallejac commented 5 months ago

No, not here. Having same issue with v9.1.2

Leprazoriy commented 5 months ago

9.1.2 work for me.

SergeyKorneyev commented 5 months ago

Version 9.1.2 should resolve this issue. If it does not, please let us know.

PifPof73 commented 5 months ago

@arnowelzel something seems off, because I cleared the browser data (even tried on incognito mode) and I can see the previous values every time. Those values are clearly empty in the db: https://i.imgur.com/KzWHEIn.jpeg

Strange - for me that worked fine and I have no idea from where else OnlyOffice should get the value from.

Maybe restart php-fpm just to be sure, that also the PHP opcache is flushed?

I had the same problem and restarting php-fpm solved it. I could reach the admin page again and type the old value into it. Since than it is running again with Version 9.0.0

PifPof73 commented 5 months ago

No, not here. Having same issue with v9.1.2

I think you have to repair the v9.1.0 first - just installing 9.1.2 over it does not worked for me either. I first downgraded to v9.0.0, deleted the entry in the database (see posts of @arnowelzel ), restarted the php-fpm service and got anything running. After that, I could upgrade from v9.0.0 -> v9.1.2 and still got everything up and running.

stepcellwolf commented 5 months ago

Even with the latest version, 9.1.2 having a issue: Error when trying to connect (Error occurred in the document service: Error while downloading the document file to be converted.) (version 7.5.1.23)

W3XTR1337 commented 5 months ago

Upgrade to 9.1.2 didn't work. Running cloud 27.1.8 on Ubuntu 20.04. Common settings reappeared and I can change them, but now I have missing area with extensions which OnlyOffice should open and he is still downloading files. Screenshot 2024-04-09 at 10 54 03

UPD: Forgot about error in logs "foreach() argument must be of type array|object, null given at /var/snap/nextcloud/41512/nextcloud/extra-apps/onlyoffice/lib/AppConfig.php#1282"

mmallejac commented 5 months ago

I have reverted to app v9.0.0 and now is ok https://github.com/ONLYOFFICE/onlyoffice-nextcloud/releases/download/v9.0.0/onlyoffice.tar.gz

arnowelzel commented 5 months ago

It seems, 9.1.2 fixes the issue and also brings back the missing js folder (at least on my test instances). You may have to completely disable and remove your existing installation first (maybe remove the folder apps/onlyoffice from your Nextcloud installation top be sure) and then reinstall 9.1.2 as a new app. If configuration fails, try removing the URL setting, so OnlyOffice allows you reconfigure the URL of the backend in the administrative settings:

update oc_appconfig set configValue='' where appid='onlyoffice' and configKey='DocumentServerUrl';

Thanks for the quick response to @LinneyS.

jdaviescoates commented 5 months ago

Just updating to 9.1.2 worked for me. Thanks @LinneyS

stepcellwolf commented 5 months ago

It does work after copying 9.0.0 js folder as @Nikos-Mennecy pointed out on your server : 1 grab the 9.0 relaease

wget https://github.com/ONLYOFFICE/onlyoffice-nextcloud/releases/download/v9.0.0/onlyoffice.tar.gz

2 expend

tar -xf onlyoffice.tar.gz

3 copy js folder to where it should be

sudo cp -R onlyoffice/js/ /var/lib/docker/volumes/nextcloud_aio_nextcloud/_data/custom_apps/onlyoffice/js

4 change ownership

sudo chown -R www-data:www-data /var/lib/docker/volumes/nextcloud_aio_nextcloud/_data/custom_apps/onlyoffice/js

5 cleanup a bit

rm -rf onlyoffice onlyoffice.tar.gz

6 go to NC webUI > admin settings > OnlyOffice and hit save Edit : I guess the new gitignore file is the explanation...

Using this option it saves the onlyoffice configuration, but when I try to open a document, it keeps trying forever.... Direct tests on the onlyoffice server work normally. Only the integration has a problem following the plugin update.

This is the only solution that worked for me in yunohost and manually install the app to /var/www/nextcloud/apps/ and chown -R nextcloud:www-data onlyoffice and enable it via admin in NC settings and it should work.

ostasevych commented 5 months ago

For me the upgrade from 8.x to 9.1.2 passed without errors and it works fine. Thanks for raising this issue, so I have waited for the fixed update.

rchaconmolero commented 5 months ago

After updating from 9.0.0 to 9.1.2 we got this message.

After uninstalling the app and reinstalling, this message continues to appear. After uninstalling we verified that the nextloud folder does not exist in app folders.

After installing again, we see that the onlyoffice/js folder exists with all the .js files, but the message still appears.

I ,"app":"jsresourceloader","method":"GET","url":"/apps/dashboard/","message":"Could not find resource onlyoffice/js/desktop.js to load