4 hours ago, blaine07 said:

After my fiasco a few weeks back been afraid to do much with Nextcloud.

On my MAIN instance - it is currently: lscr.io/linuxserver/nextcloud:version-30.0.5

Would it be wise to go 30.0.7 first and then THEN 31.0.1 or?

It's a minor update and shouldn't make a difference. Run an appdata backup first. If something goes wrong, you can delete the NC and MariaDB appdata folders and restore them from backup, rolling back the NC d9cker as well. That's far quicker than trying to fix. 

Personally, I would jump to 31, but doing 30.0.07 first, only takes a few minutes. Remember to update the data fingerprint afterwards.

 

 

 

 

9 hours ago, Geck0 said:

Roll back your Nextcloud docker to the previous version, ie. 30.0.14 by tagging the Nextcloud docker. Once that is up and running, upgrade your MariaDB docker, make sure Nextcloud is running fine on the new MariaDB and then upgrade Nextcloud.

 

I'm not sure if you ran the occ upgrade command, because the upgrade failed, or you're used to doing it that way. Nextcloud will automatically upgrade when you start the docker, if you have the "latest" tag or you tag a higher version than the one you were on. You shouldn't be trying manually on a tagged version.

 

 

Thanks for the response.

MariaDB is showing up to date.

I only ran the occ upgrade command for troubleshooting just to check if that worked, the 'latest' tag did auto upgrade and failed with the same error.

 

I can't seem to find get the 30.0.14 tag to work, I can't see that specific release tag on the docker/github either, closest I can fine is "30.0.0-ls345" anything  newer ("30.0.1-ls346")  gives that same previous error.

 

When it installs 30.0.0-ls345, I can no longer access the WebUI, it eventually times out with http Error 500 in the browser.

This is the log from Nextcloud from Unraid docker section after rollback to "30.0.0-ls345"

 

───────────────────────────────────────

      ██╗     ███████╗██╗ ██████╗
      ██║     ██╔════╝██║██╔═══██╗
      ██║     ███████╗██║██║   ██║
      ██║     ╚════██║██║██║   ██║
      ███████╗███████║██║╚██████╔╝
      ╚══════╝╚══════╝╚═╝ ╚═════╝

   Brought to you by linuxserver.io
───────────────────────────────────────

To support LSIO projects visit:
https://www.linuxserver.io/donate/

───────────────────────────────────────
GID/UID
───────────────────────────────────────

User UID:    99
User GID:    100
───────────────────────────────────────
Linuxserver.io version: 30.0.0-ls345
Build-date: 2024-10-08T11:50:56+00:00
───────────────────────────────────────
    
using keys found in /config/keys
After completing the web-based installer, restart the Nextcloud container to apply default memory caching and transactional file locking configurations.
Alternatively, you can apply your own configurations by editing /config/www/nextcloud/config/config.php following the documentation:
https://docs.nextcloud.com/server/latest/admin_manual/configuration_server/caching_configuration.html
https://docs.nextcloud.com/server/latest/admin_manual/configuration_files/files_locking_transactional.html
[custom-init] No custom files found, skipping...
[ls.io-init] done.

 

9 minutes ago, egtrev said:

 

Thanks for the response.

MariaDB is showing up to date.

I only ran the occ upgrade command for troubleshooting just to check if that worked, the 'latest' tag did auto upgrade and failed with the same error.

 

I can't seem to find get the 30.0.14 tag to work, I can't see that specific release tag on the docker/github either, closest I can fine is "30.0.0-ls345" anything  newer ("30.0.1-ls346")  gives that same previous error.

 

When it installs 30.0.0-ls345, I can no longer access the WebUI, it eventually times out with http Error 500 in the browser.

This is the log from Nextcloud from Unraid docker section after rollback to "30.0.0-ls345"

 

───────────────────────────────────────

      ██╗     ███████╗██╗ ██████╗
      ██║     ██╔════╝██║██╔═══██╗
      ██║     ███████╗██║██║   ██║
      ██║     ╚════██║██║██║   ██║
      ███████╗███████║██║╚██████╔╝
      ╚══════╝╚══════╝╚═╝ ╚═════╝

   Brought to you by linuxserver.io
───────────────────────────────────────

To support LSIO projects visit:
https://www.linuxserver.io/donate/

───────────────────────────────────────
GID/UID
───────────────────────────────────────

User UID:    99
User GID:    100
───────────────────────────────────────
Linuxserver.io version: 30.0.0-ls345
Build-date: 2024-10-08T11:50:56+00:00
───────────────────────────────────────
    
using keys found in /config/keys
After completing the web-based installer, restart the Nextcloud container to apply default memory caching and transactional file locking configurations.
Alternatively, you can apply your own configurations by editing /config/www/nextcloud/config/config.php following the documentation:
https://docs.nextcloud.com/server/latest/admin_manual/configuration_server/caching_configuration.html
https://docs.nextcloud.com/server/latest/admin_manual/configuration_files/files_locking_transactional.html
[custom-init] No custom files found, skipping...
[ls.io-init] done.

 

Yep, that would be the correct tag. I think you took the version I mentioned (which I got from your docker log) literally. 

If its not working, then restore your MariaDB from your last appdata backup. Its likely that failed migration has caused some issues. Basically, scrap your MariaDB docker and Nextcloud, roll them back to the versions you were on and restore your most recent appdata backup. That will put you back where you were before you upgraded.

 

 Once you're back where you were, then upgrade your MariaDB and then upgrade Nextcloud.

 

 

Seeking help updating my nextcloud database…I am trying to run occ commands to add missing indices and run maintenance repairs, but I can’t seem to run occ commands due to another error referring to a missing .ncdata file in my directory.  Attached are screenshots of my nextcloud install errors and the console occ error. Thank you so much for any insights/solutions!

Not sure if this is the same as some of the previous posted upgrade issues but I am having one as well. Seems to be after the latest update I get a very generic error at the home page. (See the Screenshot)

I check the docker logs and don't see anything.

I have run through a bunch of the occ commands to attempt to repair stuff with no luck. Where do I go from here?

13 hours ago, Elembemedia said:

Not sure if this is the same as some of the previous posted upgrade issues but I am having one as well. Seems to be after the latest update I get a very generic error at the home page. (See the Screenshot)

I check the docker logs and don't see anything.

I have run through a bunch of the occ commands to attempt to repair stuff with no luck. Where do I go from here?

I had all kinds of issues with next cloud using MariaDB. I happened to have the PG16-Vector database running, so I threw yet another NC install against that. It's been stable since November. 

Give that a whirl. I used Adminer to setup the DB in the PG application for NC.

7 hours ago, eagle470 said:

I had all kinds of issues with next cloud using MariaDB. I happened to have the PG16-Vector database running, so I threw yet another NC install against that. It's been stable since November. 

Give that a whirl. I used Adminer to setup the DB in the PG application for NC.

mySQL and MariaDB are the recommended database engines for NC. The issue is the OP hasn't given sufficient information to get feedback on the forum. ie.

 

NCversion --> NCversion (which versions caused the failure).

What database version.

Was a new docker installed, or did the OP try to use OCC Upgrade.

 

Going from 30 --> 31 needs a bit more consideration. Mine upgraded without a hitch, but I still had to change the tables to support dynamic. Which wasn't as smooth as I thought it would be. I doubt that's the issue he has though.

 

Bottom line is, the quality of information you put in supports the quality of the information you get out. I've stopped responding to posts for help when there is zilch information, and its not a case that I don't want to help, but people need to give more information.

Edited March 18, 20251 yr by Geck0

On 3/16/2025 at 8:35 PM, nationapn said:

Seeking help updating my nextcloud database…I am trying to run occ commands to add missing indices and run maintenance repairs, but I can’t seem to run occ commands due to another error referring to a missing .ncdata file in my directory.  Attached are screenshots of my nextcloud install errors and the console occ error. Thank you so much for any insights/solutions!

How did you run the upgrade? You seem to have a permissions issue, did you check the permissions of the data directory, it looks like NC can't read the directory and cannot find the .ncdata file. Either that, or your config.php is referencing the data folder incorrectly. Post your config.php.

16 hours ago, Geck0 said:

mySQL and MariaDB are the recommended database engines for NC. The issue is the OP hasn't given sufficient information to get feedback on the forum. ie.

 

NCversion --> NCversion (which versions caused the failure).

What database version.

Was a new docker installed, or did the OP try to use OCC Upgrade.

 

Going from 30 --> 31 needs a bit more consideration. Mine upgraded without a hitch, but I still had to change the tables to support dynamic. Which wasn't as smooth as I thought it would be. I doubt that's the issue he has though.

 

Bottom line is, the quality of information you put in supports the quality of the information you get out. I've stopped responding to posts for help when there is zilch information, and its not a case that I don't want to help, but people need to give more information.

Yet Postgres doesn't just work, it works BETTER.

For you maybe, but then you must have had something in your environment causing it. MariaDB is the standard, it works, mine's been running with it for half a decade without issues,...

4 minutes ago, Kilrah said:

For you maybe, but then you must have had something in your environment causing it. MariaDB is the standard, it works, mine's been running with it for half a decade without issues,...

I just like to chime in. MariaDB works awesome for me as well. When I did have issues, I was new to Linux, so it was user error. Lol

Just chiming in to say that I just upgraded to v31, that in order to clear the Row Format should be DYNAMIC erros, I had to run the script on this page, following these instructions:

https://help.nextcloud.com/t/upgrade-to-nextcloud-hub-10-31-0-0-incorrect-row-format-found-in-your-database/218366/30

 

Hope that helps anyone else struggling with it.

The other errors I could clear using the provided occ commands.

I am having so many issues trying to fix the DYNAMIC DB issue. I have run all the commands but it never actually changes the DB.

 

On 3/24/2025 at 3:18 PM, jademonkee said:

Just chiming in to say that I just upgraded to v31, that in order to clear the Row Format should be DYNAMIC erros, I had to run the script on this page, following these instructions:

https://help.nextcloud.com/t/upgrade-to-nextcloud-hub-10-31-0-0-incorrect-row-format-found-in-your-database/218366/30

 

Hope that helps anyone else struggling with it.

The other errors I could clear using the provided occ commands.

I tried this, but the changes never stick.

2 hours ago, strahd_zarovich said:

I am having so many issues trying to fix the DYNAMIC DB issue. I have run all the commands but it never actually changes the DB.

 

Ok, I ran another command through adminer, and got everything fixed. I had to change the tables individually. The command is a This page

3 hours ago, strahd_zarovich said:

Ok, I ran another command through adminer, and got everything fixed. I had to change the tables individually. The command is a This page

Yeah, I didn't find it straightforward. Some people wrote a script to automate it, I found that even after modifying it, it wouldn't work properly for me. I had to run the commands directly in MariaDB, I can't remember exactly what I ran, I didn't document it, but it was virtually the same as whats on the Nextcloud support forum.

 

I echo the same thought as others, this could have been integrated into the update process.

I am hoping someone can shed some light on copying files to a Nextcloud share via the Nextcloud web interface, by dropping the folder or files directly into the share. I have tried to copy large files, 50 - 100 GB, backups of drives, via the web interface, directly into the folder. I get a progress bar and the time countdown, but after about half an hour, or however long it is supposed to take to copy, only the copied folder name is actually copied, but the contents are not there. 0 KB are in the folder. I can copy small files with no problem, documents or pictures. 

 

Is there a size setting that I need to check? Under the administrative setting / system,  upload max is listed as 100 GB.

 

Thanks,

 

Lev

3 hours ago, levster said:

I am hoping someone can shed some light on copying files to a Nextcloud share via the Nextcloud web interface, by dropping the folder or files directly into the share. I have tried to copy large files, 50 - 100 GB, backups of drives, via the web interface, directly into the folder. I get a progress bar and the time countdown, but after about half an hour, or however long it is supposed to take to copy, only the copied folder name is actually copied, but the contents are not there. 0 KB are in the folder. I can copy small files with no problem, documents or pictures. 

 

Is there a size setting that I need to check? Under the administrative setting / system,  upload max is listed as 100 GB.

 

Thanks,

 

Lev

If you're running it behind Swag, there's a setting in your Swag config that defines max down/upload size.

I have nothing to back this up, but personally I'd be hesitant to upload that much data via a browser.

If it's a fairly new instance, I believe you can just put the data directly in the NextCloud directory on the server, then rescan the database. If your NextCloud instance already contains a lot of files, you may not want to do this, though, as it could take a while. 

I've never done that before, so you'll have to Google how or wait for someone else to chime in.

8 hours ago, jademonkee said:

If you're running it behind Swag, there's a setting in your Swag config that defines max down/upload size.

I have nothing to back this up, but personally I'd be hesitant to upload that much data via a browser.

If it's a fairly new instance, I believe you can just put the data directly in the NextCloud directory on the server, then rescan the database. If your NextCloud instance already contains a lot of files, you may not want to do this, though, as it could take a while. 

I've never done that before, so you'll have to Google how or wait for someone else to chime in.

Oh, I would not have thought about checking SWAG. Thanks. I'll see how to go about doing that. As far as browser uploads, I am remote and unless I go ftp I do not want to drop into a folder. These are PC backups to a USB and I want them centralized.

8 hours ago, levster said:

Oh, I would not have thought about checking SWAG. Thanks. I'll see how to go about doing that. As far as browser uploads, I am remote and unless I go ftp I do not want to drop into a folder. These are PC backups to a USB and I want them centralized.

I looked this up this link for you. Read the php and nginx sections.

if you're behind a reverse proxy, you will need to consider where you are placing the settings, ie. you can put the max upload file size settings, etc on the reverse proxy, along with the majority of other relevant settings or simply pass through to Nextcloud and let Nextcloud's nginx conf handle it.

 

https://docs.nextcloud.com/server/latest/admin_manual/configuration_files/big_file_upload_configuration.html

 

I've set it on both, as there is no harm in doing so.

As for placing large files on your NC and file scanning, its simple to do.

1. Go to Nextcloud's data directory's user folder and create the folder that you want to create, make sure you check chmod and chown settings for 

2. Copy over all of your files, etc. into the desired data structure you want.

3. Chmod and Chown all your files, ensuring its done recursively to the folder and all of its contents, so that it matches the permissions and ownership of the existing files.

4. run this command, 

Quote

docker exec -it nextcloud occ files:scan --all

"nextcloud" is the name of your NC docker container, you can substitute it.

"files:scan --all" can be changed to the specific user that you "files:scan --username", entering the name of the user (which is case sensistive) so it only scans that user's files and therefore, specifically the files and folders you uploaded. 

This will reduce the amount of scan time, it doesn't take that long to do your whole structure anyway, unless your PC is resource light.

 

Next time, I recommend you give more detail on your network. Are you behind a proxy, like opnSense firewall's reverse proxy or SWAG, etc. Its hard to give an answer when nothing is known about your set up.

 

Edited March 27, 20251 yr by Geck0

Also if you're using cloudflare proxy that's not gonna go through.

 

Not at all what nextcloud is meant for though. 

3 hours ago, Kilrah said:

Also if you're using cloudflare proxy that's not gonna go through.

 

Not at all what nextcloud is meant for though. 

I do use Cloudflare, but can upload about 20GB files. The backups are about 70 - 90 GB.

 

 

21 hours ago, levster said:

I do use Cloudflare, but can upload about 20GB files. The backups are about 70 - 90 GB.

 

 

I use Nextcloud to sync backups of my opnSense configuration, as it supports webdav and they're small files. 

NC is not meant for what you're trying to achieve. 

You're better off using rclone for this, which supports multiple protocols and its a simple cli to use.

 

Do you need them to be accessible in NC, or its just your chosen vehicle for backup?

On 2/12/2025 at 2:15 PM, huladaddy said:

Help.

I just received this image when trying to load the webui:

```

Internal Server Error

The server encountered an internal error and was unable to complete your request.
Please contact the server administrator if this error reappears multiple times, please include the technical details below in your report.
More details can be found in the server log.

```

This is the error in the logs:

```

Doctrine\DBAL\Exception: Failed to connect to the database: An exception occurred in the driver: SQLSTATE[HY000] [2006] MySQL server has gone away in /app/www/public/lib/private/DB/Connection.php:140

```

In MariaDB, I get this error:

```

cat: /run/mysqld/mysqld.pid: No such file or directory

```

 

Is there anyone that could provide some guidance, or point me in a direction to solve this. I have no idea what caused this. I have been unable to access my nextcloud for months. I would be so grateful for any assistance. Thanks.

4 minutes ago, huladaddy said:

Is there anyone that could provide some guidance, or point me in a direction to solve this. I have no idea what caused this. I have been unable to access my nextcloud for months. I would be so grateful for any assistance. Thanks.

If its been months, why don't you just restore a backup of your MariaDB and your NC dockers to when they were last working?? That's the quickest way and then revert for advice, before you do any further upgrades.

 

I cannot underline enough how important it is to have decent backups to resolve issues quickly. I only troubleshoot when I absolutely have to.

The problem with your error, it could be a number of things. Anything from your MariaDB version being out of date and NC having the :latest tag and auto updating could be sufficient for that to happen.