Habe ein Problem beim installieren der App Groupfolders.
Ich hoffe, jemand kann mir hierbei helfen. Wenn ich versuche sie zu installieren kommt folgende Meldung:
Blockquote
An exception occurred while executing ‘CREATE TABLE oc_group_folders_trash (trash_id BIGINT AUTO_INCREMENT NOT NULL, name VARCHAR(250) NOT NULL, original_location VARCHAR(4000) NOT NULL, deleted_time BIGINT NOT NULL, folder_id BIGINT NOT NULL, INDEX groups_folder_trash_folder (folder_id), INDEX groups_folder_name (folder_id, name), UNIQUE INDEX groups_folder_trash_unique (folder_id, name, deleted_time), PRIMARY KEY(trash_id)) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_bin ENGINE = InnoDB ROW_FORMAT = compressed’: SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes
Mir sagt das leider nichts und deshalb hoffe ich auf euch
I get the error message even though I did all the steps within the documentation. For all other plugins this worked correctly, but not for the groupfolder-plugin.
All tables are Barracuda, I set all variables:
SET GLOBAL innodb_file_format=Barracuda; SET GLOBAL innodb_large_prefix=true; SET GLOBAL innodb_file_per_table=1;
and rechecked the DB.
Afterwords:
ALTER DATABASE nextcloud CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci; sudo -u www-data php occ config:system:set mysql.utf8mb4 --type boolean --value="true" sudo -u www-data php occ maintenance:repair sudo -u www-data php occ db:convert-filecache-bigint
