![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
Nextcloud internal server error
CONTENTS
Lastmodified 2019-05-21 (火) 16:41:49
Nextcloud 16.0.1へアップグレードしたら、DBのインデクスが無い言われた。
The database is missing some indexes. Due to the fact that adding indexes on big tables could take some time they were not added automatically. By running "occ db:add-missing-indices" those missing indexes could be added manually while the instance keeps running. Once the indexes are added queries to those tables are usually much faster. テーブル "oc_twofactor_providers"のインデックス "twofactor_providers_uid"が見つかりません。 テーブル "oc_whats_new"のインデックス "version"が見つかりません。 テーブル "oc_cards"のインデックス "cards_abid"が見つかりません。 テーブル "oc_cards_properties"のインデックス "cards_prop_abid"が見つかりません。
つくる。
# cd /usr/local/www/nextcloud # sudo -u www php occ db:add-missing-indices Check indices of the share table. Check indices of the filecache table. Check indices of the twofactor_providers table. Adding additional twofactor_providers_uid index to the twofactor_providers table, this can take some time... Twofactor_providers table updated successfully. Check indices of the login_flow_v2 table. Check indices of the whats_new table. Adding version index to the whats_new table, this can take some time... whats_new table updated successfully. Check indices of the cards table. Adding cards_abid index to the cards table, this can take some time... cards table updated successfully. Check indices of the cards_properties table. Adding cards_prop_abid index to the cards_properties table, this can take some time... cards_properties table updated successfully. # apachectl restart Performing sanity check on apache24 configuration: Syntax OK Stopping apache24. Waiting for PIDS: 687. Performing sanity check on apache24 configuration: Syntax OK Starting apache24. #
Total access 1333：本日 1：昨日 0
