![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
#author("2020-12-28T18:00:26+09:00","default:kuji","kuji") #author("2020-12-29T03:50:01+09:00","default:kuji","kuji") CONTENTS #contents ---- Lastmodified &lastmod; ---- *Nextcloud Upgrade error 19 to 20 [#a98e1c54] # sudo -u www php occ db:convert-filecache-bigint Following columns will be updated: * filecache_extended.fileid [#c52dacc4] This can take up to hours, depending on the number of files in your instance! Continue with the conversion (y/n)? [n] y root@sun1:/usr/local/www/nextcloud:20_12_28:17:41 # sudo -u www php sudo -u www php occ db:convert-filecache-bigint Could not open input file: sudo root@sun1:/usr/local/www/nextcloud:20_12_28:17:55 # sudo -u www php occ db:convert-filecache-bigint Following columns will be updated: * federated_reshares.share_id [#if3ae0b5] * share_external.id [#c155132d] * share_external.parent [#h2797c97] This can take up to hours, depending on the number of files in your instance! Continue with the conversion (y/n)? [n] y root@sun1:/usr/local/www/nextcloud:20_12_28:17:55 # sudo -u www php occ db:add-missing-primary-keys Check primary keys. Adding primary key to the federated_reshares table, this can take some time... federated_reshares table updated successfully. Adding primary key to the systemtag_object_mapping table, this can take some time... systemtag_object_mapping table updated successfully. Adding primary key to the comments_read_markers table, this can take some time... comments_read_markers table updated successfully. Adding primary key to the collres_resources table, this can take some time... collres_resources table updated successfully. Adding primary key to the collres_accesscache table, this can take some time... collres_accesscache table updated successfully. Adding primary key to the filecache_extended table, this can take some time... filecache_extended table updated successfully. root@sun1:/usr/local/www/nextcloud:20_12_28:17:56 # sudo -u www php occ dbadd-missing-indices Following columns will be updated: * filecache_extended.fileid [#c52dacc4] This can take up to hours, depending on the number of files in your instance! Continue with the conversion (y/n)? [n] y root@sun1:/usr/local/www/nextcloud:20_12_28:17:41 # sudo -u www php sudo -u www php occ db:convert-filecache-bigint Could not open input file: sudo root@sun1:/usr/local/www/nextcloud:20_12_28:17:55 # sudo -u www php occ db:convert-filecache-bigint Following columns will be updated: * federated_reshares.share_id [#if3ae0b5] * share_external.id [#c155132d] * share_external.parent [#h2797c97] This can take up to hours, depending on the number of files in your instance! Continue with the conversion (y/n)? [n] y root@sun1:/usr/local/www/nextcloud:20_12_28:17:55 # sudo -u www php occ db:add-missing-primary-keys Check primary keys. Adding primary key to the federated_reshares table, this can take some time... federated_reshares table updated successfully. Adding primary key to the systemtag_object_mapping table, this can take some time... systemtag_object_mapping table updated successfully. Adding primary key to the comments_read_markers table, this can take some time... comments_read_markers table updated successfully. Adding primary key to the collres_resources table, this can take some time... collres_resources table updated successfully. Adding primary key to the collres_accesscache table, this can take some time... collres_accesscache table updated successfully. Adding primary key to the filecache_extended table, this can take some time... filecache_extended table updated successfully. root@sun1:/usr/local/www/nextcloud:20_12_28:17:56 # sudo -u www php occ dbadd-missing-indices Command "dbadd-missing-indices" is not defined. Did you mean one of these? db:add-missing-columns db:add-missing-indices root@sun1:/usr/local/www/nextcloud:20_12_28:17:57 # 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. Check indices of the login_flow_v2 table. Check indices of the whats_new table. Check indices of the cards table. Adding cards_abiduri index to the cards table, this can take some time... cards table updated successfully. Check indices of the cards_properties table. Check indices of the calendarobjects_props table. Check indices of the schedulingobjects table. Check indices of the oc_properties table. root@sun1:/usr/local/www/nextcloud:20_12_28:17:57 # root@sun1:/usr/local/www/nextcloud:20_12_28:17:57 # 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. Check indices of the login_flow_v2 table. Check indices of the whats_new table. Check indices of the cards table. Adding cards_abiduri index to the cards table, this can take some time... cards table updated successfully. Check indices of the cards_properties table. Check indices of the calendarobjects_props table. Check indices of the schedulingobjects table. Check indices of the oc_properties table. root@sun1:/usr/local/www/nextcloud:20_12_28:17:57 # ---- Total access &counter(total);：本日 &counter(today);：昨日 &counter(yesterday); #counter([total|today|yesterday]);
