Nextcloud web not working after last update

Dear Boris,

Unfortunately, our Nextcloud instance is no longer accessible via the browser following the recent update; however, the synchronization applications on our PCs continue to function correctly. I have forwarded the log file to you and would be most grateful if you could investigate the cause of this issue.

Many thanks,

Rudy
Muret La Barba, Berlin

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.

Let me check, I will come back

Can you check if running this helps?

occ maintenance:repair

And send me the output

root@syncloud:~# occ maintenance:repair
-bash: occ: command not found
root@syncloud:~#

Sorry I meant

snap run nextcloud.occ maintenance:repair

Hello Boris, it worked; thank you very much.

root@syncloud:~# snap run nextcloud.occ maintenance:repair

  • Repair MySQL collation
    • Not a mysql database → nothing to do
  • Clean tags and favorites
    • 0 tags of deleted users have been removed.
    • 0 tags for delete files have been removed.
    • 0 tag entries for deleted tags have been removed.
    • 0 tags with no entries have been removed.
  • Repair invalid shares
  • Move .step file of updater to backup location
  • Add move avatar background job
    • Repair step already executed
  • Add preview cleanup background jobs
  • Migrate oc_properties table to nextcloud schema
    • oc_properties table does not exist.
  • Migrate oauth2_clients table to nextcloud schema
    • Update the oauth2_access_tokens table schema.
    • Update the oauth2_clients table schema.
    • Delete clients (and their related access tokens) with the redirect_uri starting with oc:// or ending wi
      th *
  • Repair language codes
  • Add log rotate job
  • Clear frontend caches
    • Image cache cleared
    • JS cache cleared
  • Clear every generated avatar
  • Add preview background cleanup job
  • Queue a one-time job to cleanup old backups of the updater
  • Cleanup invalid photocache files for carddav
  • Add background job to cleanup login flow v2 tokens
  • Remove potentially over exposing share links
    • No need to remove link shares.
  • Clear access cache of projects
  • Reset generated avatar flag
  • Keep legacy encryption enabled
  • Check encryption key format
  • Remove old dashboard app config data
  • Add job to cleanup the bruteforce entries
  • Queue a one-time job to check for user uploaded certificates
  • Repair DAV shares
  • Add background job to set the lookup server share state for users
  • Add token cleanup job
  • Clean up abandoned apps
  • Add possibly missing system config
  • Add AI tasks cleanup jobs
  • Queue a job to generate metadata
  • Cache logo dimension to fix size in emails on Outlook
    • Logo dimensions are already known
  • Remove legacy “.ocdata” file
  • Add cleanup-deleted-users background job
  • Validate account properties and store phone numbers in a known format for search
    • Queued background to validate account properties.
  • Migrate config keys
  • Update hook for Appointments app
    • appointments UpdateHook finished
  • Upgrading Circles App
  • Fix component of birthday calendars
    • 28 birthday calendars updated.
  • Regenerating birthday calendars to use new icons and fix old birthday events without year
    • Repair step already executed
  • Fix broken values of calendar objects
    0 [->--------------------------]
  • Registering building of calendar search index as background job
    • Repair step already executed
  • Register building of social profile search index as background job
    • Repair step already executed
  • Registering background jobs to update cache for webcal calendars
    • Added 0 background jobs to update webcal calendars
  • Registering building of calendar reminder index as background job
    • Repair step already executed
  • Register a background job to update rooms and resources
  • Queue jobs to clean up orphan event and contact data
  • Remove activity entries of private events
    • Removed 0 activity entries
  • Clean up old calendar subscriptions from deleted users that were not cleaned-up
    0 [----->----------------------]
    • 0 calendar subscriptions without an user have been cleaned up
  • Copy default images to the app data directory
    • Icon external.svg already exists
    • Icon external-dark.svg already exists
    • Icon settings.svg already exists
    • Icon settings-dark.svg already exists
  • Mark JWT token private key as sensitive
  • Fix the share type of guest shares when migrating from ownCloud
  • Copy the share password into the dedicated column
  • Set existing shares as accepted
  • Update OAuth token expiration times
  • init metadata
  • Switches from default updater server to the customer one if a valid subscription is available
    • Repair step already executed
  • Migrate some config values to lazy loading
  • Send an admin notification if monthly report is disabled
  • Copy the data into the new db structure
  • Fixing the sequence of the row-sleeves table
  • Force-reset all Text document sessions
  • Initialize migration of background images from dashboard to theming app
  • Add background job to check for backup codes
  • Insert UUIDFix background job for user and group in batches
  • Remove deprecated refresh time markers for LDAP user records
  • Populating added database structures for workflows
    root@syncloud:~#

I will try to make this better as this is a known Nextcloud issue, did anything unusual happen before this, like a power outage?

Dear Boris,

We are encountering a persistent issue with the admin account in Nextcloud, which is not being recognised as an administrator. We have reviewed several posts here and implemented the suggested solutions, but to no avail. We remain committed to resolving this matter; however, it appears that a fresh installation of Nextcloud may be the only viable solution. Given that our Nextcloud instance supports our wine bar and serves a large number of users, we have continually postponed this action.

Best regards,
Rudy

Let me check that, I may be able to fix it. I will come back soon

Can you actually start a new thread please on that.

Update 924 should be available in an hour or so, could you upgrade please and let me know if admin users are admins again In Nextcloud.

Also could you confirm that admin user can login to Users apps and is part of Syncloud admin group?

Greetings, Boris. Regrettably, I am unable to initiate the update on any of my three devices, all of which are Raspberry Pis. Furthermore, Nextcloud has become inaccessible without a restart.

Sorry are you saying latest Nextcloud update broke it? What error do you see?

yes the last version, had no error message; it simply stop update

.

Right I found the issue my attempt to sync admin roles did not always work, fix is coming asap.

1 Like

A brief update: Nextcloud operates on our business device, although no updates can be performed. On my personal device, Nextcloud appears to have disappeared.

root@syncloud:~# snap run nextcloud.occ maintenance:repair
An unhandled exception has been thrown:
Doctrine\DBAL\Exception: Failed to connect to the database: An exception occurred in t
he driver: SQLSTATE[08006] [7] could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket “/var/snap/nextcloud/current/database/.s.PGS
QL.5436”? in /snap/nextcloud/906/nextcloud/lib/private/DB/Connection.php:238
Stack trace:
#0 /snap/nextcloud/906/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(458): OC\DB
\Connection->connect()
#1 /snap/nextcloud/906/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(416): Doctr
ine\DBAL\Connection->getDatabasePlatformVersion()
#2 /snap/nextcloud/906/nextcloud/3rdparty/doctrine/dbal/src/Connection.php(323): Doctr
ine\DBAL\Connection->detectDatabasePlatform()
#3 /snap/nextcloud/906/nextcloud/lib/private/DB/Connection.php(922): Doctrine\DBAL\Con
nection->getDatabasePlatform()
#4 /snap/nextcloud/906/nextcloud/lib/private/DB/ConnectionAdapter.php(243): OC\DB\Conn
ection->getDatabaseProvider(false)
#5 /snap/nextcloud/906/nextcloud/lib/private/DB/QueryBuilder/QueryBuilder.php(96): OC\
DB\ConnectionAdapter->getDatabaseProvider()
#6 /snap/nextcloud/906/nextcloud/lib/private/AppConfig.php(1352): OC\DB\QueryBuilder\Q
ueryBuilder->expr()
#7 /snap/nextcloud/906/nextcloud/lib/private/AppConfig.php(284): OC\AppConfig->loadCon
fig(NULL, false)
#8 /snap/nextcloud/906/nextcloud/lib/private/AppConfig.php(1832): OC\AppConfig->search
Values(‘installed_versi…’, false, 4)
#9 /snap/nextcloud/906/nextcloud/lib/private/Memcache/Factory.php(121): OC\AppConfig->
getAppInstalledVersions(true)
#10 /snap/nextcloud/906/nextcloud/lib/private/Memcache/Factory.php(160): OC\Memcache\F
actory->getGlobalPrefix()
#11 /snap/nextcloud/906/nextcloud/lib/private/Server.php(936): OC\Memcache\Factory->cr
eateLocking(‘lock’)
#12 /snap/nextcloud/906/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php
(169): OC\Server->OC\{closure}(Object(OC\Server))
#13 /snap/nextcloud/906/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(122)
: OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}(Object(Pi
mple\Container))
#14 /snap/nextcloud/906/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php
(136): Pimple\Container->offsetGet(‘OCP\\Lock\\ILocki…’)
#15 /snap/nextcloud/906/nextcloud/lib/private/ServerContainer.php(154): OC\AppFramewor
k\Utility\SimpleContainer->query(‘OCP\\Lock\\ILocki…’, true)
#16 /snap/nextcloud/906/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php
(45): OC\ServerContainer->query(‘OCP\\Lock\\ILocki…’)
#17 /snap/nextcloud/906/nextcloud/lib/private/Files/View.php(76): OC\AppFramework\Util
ity\SimpleContainer->get(‘OCP\\Lock\\ILocki…’)
#18 /snap/nextcloud/906/nextcloud/lib/private/Server.php(423): OC\Files\View->__constr
uct()
#19 /snap/nextcloud/906/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php
(169): OC\Server->OC\{closure}(Object(OC\Server))
#20 /snap/nextcloud/906/nextcloud/3rdparty/pimple/pimple/src/Pimple/Container.php(122)
: OC\AppFramework\Utility\SimpleContainer->OC\AppFramework\Utility\{closure}(Object(Pi
mple\Container))
#21 /snap/nextcloud/906/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php
(136): Pimple\Container->offsetGet(‘OC\\Files\\Node\\H…’)
#22 /snap/nextcloud/906/nextcloud/lib/private/ServerContainer.php(154): OC\AppFramewor
k\Utility\SimpleContainer->query(‘OC\\Files\\Node\\H…’, true)
#23 /snap/nextcloud/906/nextcloud/lib/private/AppFramework/Utility/SimpleContainer.php
(45): OC\ServerContainer->query(‘OC\\Files\\Node\\H…’)
#24 /snap/nextcloud/906/nextcloud/lib/private/Server.php(1272): OC\AppFramework\Utilit
y\SimpleContainer->get(‘OC\\Files\\Node\\H…’)
#25 /snap/nextcloud/906/nextcloud/lib/base.php(635): OC\Server->boot()
#26 /snap/nextcloud/906/nextcloud/lib/base.php(1192): OC::init()
#27 /snap/nextcloud/906/nextcloud/console.php(31): require_once(‘/snap/nextcloud…’)
#28 /snap/nextcloud/906/nextcloud/occ(33): require_once(‘/snap/nextcloud…’)
#29 {main}root@syncloud:~#

This is probably justt attempting to upgrade in the background, do not try to fix it for now, the fix is coming I the few hours.

Could you upgrade now please?

I have attempted the process, and the outcome is as follows: the download on my device indicates an upgrade, which is aborted after a few minutes. I try again

Can you show refresh log or send device logs?