After upgrading to "27", database indices cannot be upgraded and ONLYOFFICE does not work.

[piiskop]

Bug description
After upgrading to "27", database indices cannot be upgraded and ONLYOFFICE does not work.

Steps to reproduce
Administreerimise seaded.
See that it complains:

The database is missing some indexes. Due to the fact that adding indexes on big tables could take some time they were not added automatically. By running "occ db:add-missing-indices" those missing indexes could be added manually while the instance keeps running. Once the indexes are added queries to those tables are usually much faster.
Missing index "mounts_user_root_path_index" in table "oc_mounts".

So I did:

kalmer@test:/projektid/nextcloud$ sudo -u www-data php --define apc.enable_cli=1 occ db:add-missing-indices

An unhandled exception has been thrown:
OCP\AutoloadNotAllowedException: Autoload path not allowed: /projektid/nextcloud/apps/onlyoffice/appinfo/application.php in /projektid/nextcloud/lib/autoloader.php:141
Stack trace:
#0 /projektid/nextcloud/lib/autoloader.php(166): OC\Autoloader->isValidPath()
nextcloud/server#1 [internal function]: OC\Autoloader->load()
nextcloud/server#2 /projektid/nextcloud/lib/private/ServerContainer.php(106): class_exists()
nextcloud/server#3 /projektid/nextcloud/lib/private/ServerContainer.php(186): OC\ServerContainer->getAppContainer()
nextcloud/server#4 /projektid/nextcloud/lib/private/ServerContainer.php(153): OC\ServerContainer->getAppContainerForService()
nextcloud/server#5 /projektid/nextcloud/lib/private/Console/Application.php(217): OC\ServerContainer->query()
nextcloud/server#6 /projektid/nextcloud/lib/private/Console/Application.php(131): OC\Console\Application->loadCommandsFromInfoXml()
nextcloud/server#7 /projektid/nextcloud/console.php(99): OC\Console\Application->loadCommands()
nextcloud/server#8 /projektid/nextcloud/occ(11): require_once('...')
nextcloud/server#9 {main}kalmer@test:/projektid/ne

See that the settings section for ONLYOFFICE is gone!
Failid.
Click an existing XLSX file! Experience that it only offers a download option, not opening with ONLYOFFICE.
Expected behavior
ONLYOFFICE works as previously and upgrading indices is possible.

Installation method
None

Nextcloud Server version
27

Operating system
Debian/Ubuntu

PHP engine version
PHP 8.2

Web server
Apache (supported)

Database engine version
MariaDB

Is this bug present after an update or on a fresh install?
Upgraded to a MAJOR version (ex. 22 to 23)

[SergeyKorneyev]

Hello,
Have you updated the connector as well? Version 8.0.0 should work with Nextcloud 27.

[piiskop]

Hello, Have you updated the connector as well? Version 8.0.0 should work with Nextcloud 27.

Nextcloud complained about my PHP version being too old, so I upgraded to 8.2 and now Nextcloud is satisfied. But ONLYOFFICE does not work. All the apps are in their latest version.

[piiskop]

If you mean updating the connector then I have the version 7.1.2. If I click to see the details, I see this piece of information:

8.0.0
Changed
compatible with Nextcloud 27

There is no upgrade provided.

[chandlben]

I'm not certain it's related but I have a similar issue having just upgraded to v27. Among many other plugins not working, OnlyOffice also does not work. I have the latest plugin version 8.0.0 but when attempting to access the OnlyOffice settings, it gives me an internal server error. I can't open documents as before, only download them. NC v27, PHP 8.2.7, pgsql. No other problems with NC.

Let me know if I need a separate post, not trying to takeover here but it's apparent NC 27 is giving issues with OnlyOffice regardless.

[SergeyKorneyev]

@piiskop
The Autoload issue is your initial post is not related to ONLYOFFICE: Nextcloud's approach to launching has changed in the latest version, so a restart of web services is required. After the restart, we also recommend re-saving the Server settings in the connector options.
Regarding the database, there hasn't been any changes to it.

[piiskop]

I also reported the issue on the Nextcloud server and they responded to report it here.

What web services need to be restarted in particular? The web server has been restarted many times since then. How can I re-save the server settings in the connector options if the connector options is not available anymore?

[GVLLIFESTYLE]

I have the same issue.
I upgraded nextcloud today to 27.0.0 and Onlyoffice Plugin to 8.1.0.0 and its broken now.

[chandlben]

I'm not certain it's related but I have a similar issue having just upgraded to v27. Among many other plugins not working, OnlyOffice also does not work. I have the latest plugin version 8.0.0 but when attempting to access the OnlyOffice settings, it gives me an internal server error. I can't open documents as before, only download them. NC v27, PHP 8.2.7, pgsql. No other problems with NC.

Let me know if I need a separate post, not trying to takeover here but it's apparent NC 27 is giving issues with OnlyOffice regardless.

Found another closed issue, #830 which was the issue. A simple reboot fixed it but now I've got another issue to contend with. Sorry to add something unrelated to the original issue here.

[piiskop]

A simple reboot did not fix the issue. Even many reboots did not fix the issue. With rebooting, they fixed something else but apparently not this issue as in my server machine the issue still persists. I asked them to reopen the issue but they did not do that.

[uruzFR]

Hello ,

Just wanted to quickly share that after updating to version 27, I encountered the same problem. However, a simple restart fixed the issue completely.

[GVLLIFESTYLE]

for me as well for some reason.

[piiskop]

I repeat: multiple restarts have not been a solution for me.

[uruzFR]

Have you tried reinstalling the OnlyOffice client application on your Nextcloud server ?

[piiskop]

Yes, I have turned it off and on again with no effect.

[jdancouga]

same here. Nextcloud 27 and onlyoffice app 8.1 does not work. The onlyoffice's app admin page can connect to the documentserver just fine, but it won't open any files.

[piiskop]

I had to manually remove ONLYOFFICE app and reinstall it. Somehow, the settings remained and now, it works again. This only makes it possible for me and other users to use some files in collaboration but as ONLYOFFICE has proven itself so many times untrustworthy whereas the biggest problem was data loss then I use RStudio Server now for new collaboration activities instead. Actually, the makers of ONLYOFFICE may not be accused as much as the makers of the connector to Nextcloud or the makers of Nextcloud. ONLYOFFICE seems to have their own document management environment as well though but my first expression was so negative that I avoid it so far - it consumed so much of resources that even that server alone could not work.

[sat-hub]

I had the same issue today. For me, the problem was solved by reinstalling the connector app und rebooting both NC and OO.

[jdancouga]

I had the same issue today. For me, the problem was solved by reinstalling the connector app und rebooting both NC and OO.

Unfortunately reboot didn't work for me somehow. I ran both nextcloud and documentserver in containers. I have remove and rebuilt the images entirely and still having the same issue. I know my documentserver is functioning correctly since I can reach it from the public domain and can also access the example editor. Nextcloud's "occ onlyoffice:documentserver --check" command also returned successful connection result.

[jdancouga]

I have determined the root cause for my problem is due to enabling "add_header X-Frame-Options "SAMEORIGIN" always;" universally in my reverse proxy's (swag) ssl.conf. I originally enabled it to pass nextcloud's security check, but this is cause the integration of nextcloud/onlyoffice to break.