#author("2020-09-12T14:02:06+09:00","default:kuji","kuji") [[Nextcloud Upgrade error]] CONTENTS #contents ---- Lastmodified &lastmod; ---- *Nextcloud 19.0.3 [#yce75cb2] •データベースにいくつかのインデックスがありません。 大きなテーブルにインデックスを追加すると、自動的に追加されないまでに時間がかかる可能性があるためです。 "occ db:add-missing-indices"を実行することによって、インスタンスが実行し続けている間にそれらの欠けているインデックスを手動で追加することができます。 root@g7:~:20_09_11:14:30 # cd /usr/local/www/nextcloud root@g7:/usr/local/www/nextcloud:20_09_11:14:32 # su -m www -c "php /usr/local/www/nextcloud/occ db:add-missing-columns" Check columns of the comments table. Adding additional reference_id column to the comments table, this can take some time... Comments table updated successfully. root@g7:/usr/local/www/nextcloud:20_09_11:14:32 # https://matoken.org/blog/2020/06/05/upgrade-from-nextcloud-18-to-19-with-beta-channel/ ** テーブル “oc_properties”のインデックス “properties_path_index”が見つかりません。 [#k4139b7a] phpmyadmin で、properties_path_index ちうindex を「新規作成」した ** Step 4 is currently in process. Please reload this page later. [#qa0dc1c8] https://nc.suzunet.info/blogs/blog_entries/view/5/c694d127b8f7018e7f68c35a5ca6fa0e root@sun1:~:20_09_12:8:12 # cd /usr/local/www/nextcloud root@sun1:/usr/local/www/nextcloud:20_09_12:8:12 # sudo -u www php occ maintenance:repair - Repair MySQL collation - All tables already have the correct collation -> nothing to do - Repair mime types - 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 - .step file exists - .step-previous-update removed - .step file moved to .step-previous-update - Fix potential broken mount points - No mounts updated - Add log rotate job - Clear frontend caches - Image cache cleared - SCSS cache cleared - JS cache cleared - Clear every generated avatar on major updates - 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 - Switches from deprecated "production" to "stable" update channel - Sets the enterprise logo - Repair step already executed - Reset generated avatar flag - Fix component of birthday calendars - 1 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 - 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 - Clean up orphan event and contact data - 0 events without a calendar have been cleaned up - 0 properties without an events have been cleaned up - 0 changes without a calendar have been cleaned up - 0 cached events without a calendar subscription have been cleaned up - 0 changes without a calendar subscription have been cleaned up - 0 contacts without an addressbook have been cleaned up - 0 properties without a contact have been cleaned up - 0 changes without an addressbook have been cleaned up - Remove activity entries of private events - Removed 0 activity entries - 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 - Switches from default updater server to the customer one if a valid subscription is available - Repair step already executed - Add background job to check for backup codes - Populating added database structures for workflows ** PHPを7.2>7.3へ [#z0969dd9] https://piano2nd.smb.net/PukiWiki/index.php?PHP%205.6%20%E3%81%8B%E3%82%89%20PHP%207%20%E3%81%B8%E3%82%A2%E3%83%83%E3%83%97%E3%82%B0%E3%83%AC%E3%83%BC%E3%83%89 pkg set -o lang/php72:lang/php73 pkg remove '*php72*' portinstall lang/php73 portinstall lang/php73-extensions portinstall devel/pecl-APCu portinstall /usr/ports/graphics/pecl-imagick ---- Total access &counter(total);:本日 &counter(today);:昨日 &counter(yesterday); #counter([total|today|yesterday]);