Cloudron makes it easy to run web apps like WordPress, Nextcloud, GitLab on your server. Find out more or install now.


    Cloudron Forum

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Tags
    • Popular

    Solved Nextcloud 19

    Nextcloud
    nextcloud
    9
    32
    721
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • girish
      girish Staff last edited by girish

      Heads up, this is a major release for Nextcloud from 18 to 19. We are only rolling this out slowly to see if any issues pop up.

      If you are curious and want to update right away, just check for updates of your nextcloud instance manually from the app configure screen in the Cloudron dashboard and you should be able to apply the update.

      1 Reply Last reply Reply Quote 0
      • necrevistonnezr
        necrevistonnezr last edited by

        I noted that the "Community Document Server" (based on Only Office) as part of Nextcloud Hub is marked as "not-compatible" with NC 19.

        And this https://www.collaboraoffice.com/press-releases/collabora-online-as-default-in-nextcloud-hub/ states that Collabora will be the standard for Nextcloud Hub starting with NC 19?!

        necrevistonnezr 1 Reply Last reply Reply Quote 1
        • ?
          A Former User last edited by

          Yes there is now a Community Version of Collabora Office: https://apps.nextcloud.com/apps/richdocumentscode
          I tried itjust now and the connection to the server was not working. So I will wait until the app is in status "stable".

          1 Reply Last reply Reply Quote 0
          • nebulon
            nebulon Staff last edited by

            I guess it makes sense to not push out the autoupdate to more users, but allow curious users to update manually for a few more days.

            1 Reply Last reply Reply Quote 2
            • nebulon
              nebulon Staff last edited by

              I've now tested Collabora connector with Nextcloud 19 and the Cloudron collabora package and that works fine.

              The OnlyOffice connector also works with Nextcloud 19 just like it did with Nextcloud 18

              So I think we are good from our side.

              1 Reply Last reply Reply Quote 2
              • necrevistonnezr
                necrevistonnezr last edited by necrevistonnezr

                The "Hub" package lists both Collabora Servers:

                • Collabora Online https://apps.nextcloud.com/apps/richdocuments and
                • Collabora Online - Built-in CODE Server https://apps.nextcloud.com/apps/richdocumentscode

                Screenshot_2020-06-04 Apps -.png

                So it seems you need both for the "Hub" and it says it does not rely on an external server like the Cloudron Collabora Server?!

                This is very confusing and intransparent from Nextcloud's side. They didn't even mention the switch from OnlyOffice to Collabora anywhere.

                ? 1 Reply Last reply Reply Quote 0
                • girish
                  girish Staff last edited by

                  @nebulon @necrevistonnezr I created a new topic to discuss the changes instead of the update thread.

                  necrevistonnezr 1 Reply Last reply Reply Quote 0
                  • necrevistonnezr
                    necrevistonnezr @girish last edited by

                    @girish said in Nextcloud 19:

                    @nebulon @necrevistonnezr I created a new topic to discuss the changes instead of the update thread.

                    Thx and sorry 🙂

                    1 Reply Last reply Reply Quote 0
                    • ?
                      A Former User @necrevistonnezr last edited by A Former User

                      @necrevistonnezr to use office in Nextcloud, two parts are necessary:

                      • "Connector"

                      • "Server"

                      For Collabora Office:

                      • Collabora Online is the connector and includes the settings - it is needed to use Collabora Online

                      • Collabora Online - Built-in CODE Server is the server, which can be installed as a Nextcloud app. Advantage: it is very easy to install. You can also use the Cloudron Collabora app.

                      • Cloudron Collabora App This is the Cloudron Collabora Server App. Advantage: scales better then the Nextcloud Collabora app.

                      If you want to use Collabora Office in Nextcloud you need install the Collabora Online app in Nextcloud. In the settings you can choose whether to use thebuilt in Version or your own server (= Cloudron Collabora App in my case).
                      collabora.png

                      1 Reply Last reply Reply Quote 1
                      • ?
                        A Former User last edited by

                        @nebulon
                        my Collabora Online - Built in CODE Server is not working due to error log: ResourceLocator can not find a web root (root: /app/data/apps/settings.
                        I saw you mentioned the same error here: https://github.com/nextcloud/server/issues/13556
                        Do you know how to fix this?

                        1 Reply Last reply Reply Quote 0
                        • necrevistonnezr
                          necrevistonnezr last edited by necrevistonnezr

                          Thanks for the detailed explanation - but in line editing of documents doesn't work for me.

                          I have set up the Cloudron Collabora package, installed Collabora Online Nextcloud app and pointed to the Cloudron Collobora url. I get a "green light" i.e. it can connect:

                          Screenshot_2020-06-05 Einstellungen -(1).png

                          However, if I click on a odt document for example to edit, it tells me

                          Collabora Online Development Edition could not be loaded
                          

                          even though the Collabora Online Nextcloud app is not pointed to the Collabora Online Development Edition but to the separata Cloudron Collabora installation.

                          The logs in the admin account of Nextcloud are filled with things like this:

                          Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing 'INSERT INTO "oc_richdocuments_wopi"("fileid","owner_uid","editor_uid","version","canwrite","server_host","token","expiry","template_destination","hide_download","direct","is_remote_token","template_id") VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?)' with params [708914, "username", "username", 0, true, "https:\/\/nc.MYROOTDOMAIN.tld\/", "Xx1zy2tgxFRDxPiUWUbvFQ4zPgreLEip", 1591344464, 0, false, false, false, 0]: SQLSTATE[42703]: Undefined column: 7 ERROR: column "template_id" of relation "oc_richdocuments_wopi" does not exist LINE 1: ...ation","hide_download","direct","is_remote_token","template_... ^
                          

                          and

                          ResourceLocator can not find a web root (root: /app/data/apps/spreed, file: css/spreed/e6bc-1805-merged-files.css?v=184d440645b8bb9e5d3642f9160f9b28, webRoot: , throw: true)
                          
                          1 Reply Last reply Reply Quote 0
                          • nebulon
                            nebulon Staff last edited by

                            The resource locator error in the logs should be irrelevant for this issue and it something which is there since a long time. We have to investigate again if it is finally possible to make Nextcloud not complain here.

                            Regarding the other issue about the database error, this looks like some db migration went wrong during enabling that connector app. Can you maybe remove the connector app and readd it?

                            necrevistonnezr 1 Reply Last reply Reply Quote 0
                            • necrevistonnezr
                              necrevistonnezr @nebulon last edited by

                              @nebulon said in Nextcloud 19:

                              Regarding the other issue about the database error, this looks like some db migration went wrong during enabling that connector app. Can you maybe remove the connector app and readd it?

                              Disabled and then removed app. Added it again, checked settings, logged out as admin and logged in as user, Collabora still doesn't load.

                              Admin log still:

                              Doctrine\DBAL\Exception\InvalidFieldNameException: An exception occurred while executing 'INSERT INTO "oc_richdocuments_wopi"("fileid","owner_uid","editor_uid","version","canwrite","server_host","token","expiry","template_destination","hide_download","direct","is_remote_token","template_id") VALUES(?,?,?,?,?,?,?,?,?,?,?,?,?)' with params [80482, "user", "user", 0, true, "https://nc.domain.tld/", "X9YFmDsPRZMIvvuejigppXn7yuOQTzaR", 1591346839, 0, false, false, false, 0]: SQLSTATE[42703]: Undefined column: 7 ERROR: column "template_id" of relation "oc_richdocuments_wopi" does not exist LINE 1: ...ation","hide_download","direct","is_remote_token","template_... ^

                              1 Reply Last reply Reply Quote 0
                              • nebulon
                                nebulon Staff last edited by

                                I cannot really reproduce this, maybe you can report this upstream with the connector app and maybe the authors know better what is missing or went wrong in your instance.

                                necrevistonnezr 1 Reply Last reply Reply Quote 0
                                • necrevistonnezr
                                  necrevistonnezr @necrevistonnezr last edited by

                                  @necrevistonnezr said in Nextcloud 19:

                                  I noted that the "Community Document Server" (based on Only Office) as part of Nextcloud Hub is marked as "not-compatible" with NC 19.

                                  And this https://www.collaboraoffice.com/press-releases/collabora-online-as-default-in-nextcloud-hub/ states that Collabora will be the standard for Nextcloud Hub starting with NC 19?!

                                  BTW the reason for the switch could be https://github.com/ONLYOFFICE/DocumentServer/issues/805

                                  1 Reply Last reply Reply Quote 0
                                  • necrevistonnezr
                                    necrevistonnezr @nebulon last edited by

                                    @nebulon said in Nextcloud 19:

                                    I cannot really reproduce this, maybe you can report this upstream with the connector app and maybe the authors know better what is missing or went wrong in your instance.

                                    Reported here: https://help.nextcloud.com/t/nc-19-document-not-editable-with-external-collabora-server-doctrine-dbal-exception-invalidfieldnameexception/83751

                                    1 Reply Last reply Reply Quote 1
                                    • O
                                      oj last edited by

                                      Hi:

                                      I faced an issue while trying to use the Cloudron LDAP with a fresh install of Nextcloud 19.

                                      If "access control" is either set to "all Cloudron users", or to a specific "Cloudron group" or to a specific "Cloudron user" while installing Nextcloud 19, the list of relevant Cloudron users keeps on being added repeatedly - roughly once every second when seen under the "Everyone" tab in the "Users" section on Nextcloud.

                                      Since my fresh install was only for demo purposes, I have solved my immediate problem by delegating "access control" to Nextcloud.

                                      I am reporting this odd behaviour so that the Cloudron-Nextcloud LDAP settings can be fixed, if required.

                                      1 Reply Last reply Reply Quote 0
                                      • Y
                                        YurkshireLad last edited by YurkshireLad

                                        I don't want to be a party pooper, but I would hold off using Nextcloud 19 until the next point release. I hit some problems, one of which they've already fixed. The worst one was duplicate pictures in the Photos app. (Edit for details)

                                        I deleted all the example pictures and uploaded one via the Android app (which is also broken). If I clicked the picture in NextCloud, it was displayed full screen. If I closed it, the photo was duplicated in the photo gallery.

                                        Deleting documents in the Android app is impossible as selection is completely broken at the moment.

                                        1 Reply Last reply Reply Quote 0
                                        • girish
                                          girish Staff last edited by girish

                                          There's also this strange bug that in the user listing the users keep re-appearing like infinite scroll...

                                          edit: oh this is exactly what @oj has reported.

                                          @oj this is a bug in nextcloud and also it's a display issue, it's harmless otherwise.

                                          O 1 Reply Last reply Reply Quote 2
                                          • O
                                            oj @girish last edited by

                                            @girish Your new "UPDATE" button is in an "inviting green" color... asking to be pushed.

                                            What if it was switched to a "scarry red" with a scary message like "You sure you cannot wait for a few days for the devs to push you a nice, stable release of this app as an autoupdate??? By proceeding, you risk ruining your hitherto trouble-free app updates experience on Cloudron!!!"

                                            d19dotca 1 Reply Last reply Reply Quote 2
                                            • girish
                                              girish Staff last edited by

                                              @oj That's a good idea. Currently, we don't have a way to distinguish between automatic stable update vs manual-possibly-unstable update. Seems worth adding.

                                              1 Reply Last reply Reply Quote 3
                                              • nebulon
                                                nebulon Staff last edited by

                                                I have revoked the release now just to avoid more people hitting that issue after manually updating. We can just wait for at least the next patch release to iron out the rough edges.

                                                jdaviescoates 1 Reply Last reply Reply Quote 2
                                                • jdaviescoates
                                                  jdaviescoates @nebulon last edited by

                                                  @nebulon wise move.

                                                  I note the release announcement says:

                                                  If you are on an existing Nextcloud, the updater will notify you of the new version once we make it available. We usually roll out gradually and often, especially if issues are found, only make the first minor release available to all users. If you don’t want to wait and upgrade sooner, version 19 is in the beta channel. You can enable the beta channel, refresh the page, then upgrade. After the upgrade you can go back to the stable channel and you’ll be notified when 19.0.1 is out!

                                                  Sounds to me like it might make sense to nearly always wait until the first minor release before pushing updates to Cloudron.

                                                  I use Cloudron with Gandi & Hetzner

                                                  1 Reply Last reply Reply Quote 0
                                                  • d19dotca
                                                    d19dotca @oj last edited by

                                                    @oj I wouldn't make it red, because updates are often fixing many issues too and are usually fine to update a bit early, but a cautionary yellow/orange would do the trick. 😉 haha

                                                    --
                                                    Dustin Dauncey
                                                    www.d19.ca

                                                    1 Reply Last reply Reply Quote 0
                                                    • girish
                                                      girish Staff last edited by

                                                      I have added a caution note for the next release (5.3)

                                                      1 Reply Last reply Reply Quote 2
                                                      • nebulon
                                                        nebulon Staff last edited by

                                                        Since 19.0.1 is out, I was wondering if the db migration is fixed, however https://help.nextcloud.com/t/nc-19-document-not-editable-with-external-collabora-server-doctrine-dbal-exception-invalidfieldnameexception/83751 does not have any resolution, besides some manual hack. @necrevistonnezr do you have any more input on this?

                                                        necrevistonnezr 1 Reply Last reply Reply Quote 2
                                                        • necrevistonnezr
                                                          necrevistonnezr @nebulon last edited by

                                                          @nebulon No, not really. I haven’t tried the manual solution proposed there

                                                          1 Reply Last reply Reply Quote 1
                                                          • nebulon
                                                            nebulon Staff last edited by

                                                            Since there is no update on the issue, we are rolling out the new app package slowly. If you hit any issues, please restore the the previous version and disable automatic updates for that app for the time being.

                                                            jdaviescoates 1 Reply Last reply Reply Quote 1
                                                            • jdaviescoates
                                                              jdaviescoates @nebulon last edited by

                                                              @nebulon sounds like this is just an issue for people using Collabora instead of OnlyOffice, right? So perhaps a warning somewhere that if you are using Collabora you might not want to update?

                                                              I use Cloudron with Gandi & Hetzner

                                                              1 Reply Last reply Reply Quote 0
                                                              • A
                                                                adrw last edited by

                                                                I recently updated to 19.0.1 and see in Settings that DB migrations aren't updated for some optional columns. Should I manually run those commands or should those be included in the Cloudron image?

                                                                Screen Shot 2020-07-23 at 14.02.52.png

                                                                1 Reply Last reply Reply Quote 0
                                                                • girish
                                                                  girish Staff last edited by

                                                                  @adrw Not sure why that wasn't part of nextcloud migration but indeed you can run sudo -u www-data php -f /app/code/occ db:add-missing-columns and it should fix the problem. I have added this to the next release of our package.

                                                                  A 1 Reply Last reply Reply Quote 2
                                                                  • A
                                                                    adrw @girish last edited by

                                                                    @girish said in Nextcloud 19:

                                                                    sudo -u www-data php -f /app/code/occ db:add-missing-columns

                                                                    Perfect, that did the trick! No more warnings in Nextcloud Settings.

                                                                    1 Reply Last reply Reply Quote 1
                                                                    • First post
                                                                      Last post
                                                                    Powered by NodeBB