![[PukiWiki]](image/pukiwiki.png "[PukiWiki]")
CONTENTS
Lastmodified 2020-12-29 (火) 03:50:01
# 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
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 #
Total access 811：本日 1：昨日 1
