nextcloud upgrade 후 데이터베이스 오류 해제

아파치(apache)

sudo -u apache php occ db:add-missing-indices

sudo -u apache php occ db:add-missing-columns

Encryption migration

sudo -u apache php occ encryption:scan:legacy-format

sudo -u apache php occ db:add-missing-primary-keys

sudo -u apache php occ db:convert-filecache-bigint

Encryption migration

sudo -u apache php occ encryption:scan:legacy-format

엔진엑스(nginx)

sudo -u nginx php occ db:add-missing-indices

sudo -u nginx php occ db:add-missing-columns

sudo -u nginx php occ db:add-missing-primary-keys

sudo -u nginx php occ db:convert-filecache-bigint

Encryption migration

sudo -u nginx php occ encryption:scan:legacy-format

config.php 추가

‘encryption.legacy_format_support’ => true,
‘encryption.key_storage_migrated’ => false,

나

‘encryption.legacy_format_support’ => false,
‘encryption.key_storage_migrated’ => false,

sudo -u nginx php occ config:list system

nginx

chown nginx:nginx /var/lib/php/session/
chown root:nginx /var/lib/php/wsdlcache/
chown root:nginx /var/lib/php/opcache/

apache

chown apache:apache /var/lib/php/session/
chown root:apache /var/lib/php/wsdlcache/
chown root:apache /var/lib/php/opcache/