Truenas app : update required via CLI

[janot]

Hi everyone,
I’m curently running nextcloud on my truenas server and it has been running just fine for the past few months.
Recently the webpage became locked with this text on the screen : “please use the command line to update because updating via web browser is disabled”.

After running a few commands i could find online (occ maintenance:repair / occ maintenance:mode --off, occ app:update --all) and looking at the config.php, i couldn’t find any obvious reason to why my server is bricked.

My config.php looks like that :
"

Citation
'<?php
$CONFIG = array (
‘htaccess.RewriteBase’ => ‘/’,
‘memcache.local’ => ‘\OC\Memcache\APCu’,
‘apps_paths’ =>
array (
0 =>
array (
‘path’ => ‘/var/www/html/apps’,
‘url’ => ‘/apps’,
‘writable’ => false,
),
1 =>
array (
‘path’ => ‘/var/www/html/custom_apps’,
‘url’ => ‘/custom_apps’,
‘writable’ => true,
),
),
‘memcache.distributed’ => ‘\OC\Memcache\Redis’,
‘memcache.locking’ => ‘\OC\Memcache\Redis’,
‘redis’ =>
array (
‘host’ => ‘nextcloud-redis’,
‘password’ => ‘xxxxxxxxxxxxxxxx’,
‘port’ => 6379,
),
‘upgrade.disable-web’ => false,
‘passwordsalt’ => ‘xxxxxxxxxxxx’,
‘secret’ => ‘xxxxxxxxxxx’,
‘trusted_domains’ =>
array (
0 => ‘xxxxxxxxx’,
1 => ‘172.17.128.192’,
2 => ‘192.168.69.76’,
),
‘overwrite.cli.url’ => ‘xxxxxxxxx’,
‘overwriteprotocol’ => ‘https’,
‘datadirectory’ => ‘/var/www/html/data’,
‘dbtype’ => ‘pgsql’,
‘version’ => ‘30.0.0.14’,
‘dbname’ => ‘nextcloud’,
‘dbhost’ => ‘nextcloud-postgres:5432’,
‘dbport’ => ‘’,
‘dbtableprefix’ => ‘oc_’,
‘dbuser’ => ‘oc_admin’,
‘dbpassword’ => ‘xxxxxxxxx’,
‘installed’ => true,
‘instanceid’ => ‘xxxxxxx’,
‘memories.exiftool’ => ‘/var/www/html/custom_apps/memories/bin-ext/exiftool-amd64-glibc’,
‘memories.vod.path’ => ‘/var/www/html/custom_apps/memories/bin-ext/go-vod-amd64’,
‘loglevel’ => 2,
‘maintenance’ => false,
‘memories.gis_type’ => 2,
‘maintenance_window_start’ => 1,
‘default_phone_region’ => 250,
‘default_timezone’ => ‘Europe/Paris’,
‘trashbin_retention_obligation’ => ‘auto, 30’,
‘memories.index.mode’ => ‘3’,
‘memories.index.path’ => ‘/photos’,
‘enabledPreviewProviders’ =>
array (
0 => ‘OC\Preview\Image’,
1 => ‘OC\Preview\Movie’,
),
‘memories.vod.ffmpeg’ => ‘/usr/bin/ffmpeg’,
‘memories.vod.ffprobe’ => ‘/usr/bin/ffprobe’,
‘app_install_overwrite’ =>
array (
0 => ‘camerarawpreviews’,
1 => ‘epubviewer’,
),
‘ldapProviderFactory’ => ‘OCA\User_LDAP\LDAPProviderFactory’,
);

I’m in way over my head and could use a little help.

[janot]

update, found the app causing the issue using “occ upgrade” :

Citation
occ upgrade
Nextcloud or one of the apps require upgrade - only a limited number of commands are available
You may use your browser or the occ upgrade command to do the upgrade
Setting log level to debug
Turned on maintenance mode
Updating database schema
Updated database
Updating gpxpop …
Exception: Database error when running migration 070002Date20241020160425 for app gpxpod
An exception occurred while executing a query: SQLSTATE[42803]: Grouping error: 7 ERROR: column “oc_gpxpod_directories.id” must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: SELECT “id”, “user”, “path”, COUNT(*) FROM "oc_gpxpod_direct…
^
Update failed
Maintenance mode is kept active
Resetting log level

so i disabled the gpxpod app and redid the “occ upgrade”, disable maintenance mode and now everything is fine.

Hope that helps someone in the future.