After update to 20.0.5 the status page tell me that I must call:
occ db:convert-filecache-bigint
because this 3 tables must converted:
federated_reshares.share_id
share_external.id
share_external.parent
But the php ./occ db:convert-filecache-bigint run fails with:
In SchemaException.php line 85:
There is no column with name ‘auto_id’ on table ‘oc_files_trash’.
What can I do?
In the occ tool, I don’t have find an “schema check” or something.
As an workaround, because the table was empty:
show create table oc_files_trash;
drop table oc_files_trash;
run occ db:convert-filecache-bigint
CREATE TABLE oc_files_trash
(
id
varchar(250) COLLATE utf8mb4_bin NOT NULL DEFAULT ‘’,
user
varchar(64) COLLATE utf8mb4_bin NOT NULL DEFAULT ‘’,
timestamp
varchar(12) COLLATE utf8mb4_bin NOT NULL DEFAULT ‘’,
location
varchar(512) COLLATE utf8mb4_bin NOT NULL DEFAULT ‘’,
type
varchar(4) COLLATE utf8mb4_bin NOT NULL DEFAULT ‘’,
mime
varchar(255) COLLATE utf8mb4_bin NOT NULL DEFAULT ‘’,
KEY id_index
(id
),
KEY timestamp_index
(timestamp
),
KEY user_index
(user
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin ROW_FORMAT=COMPRESSED;
And now no messages about table needs maintenance.