Nextcloud 15 - Configurer le support des emojis

Logo Nextcloud

Environnement

Configuration

Trouver le fichier de configuration de MariaDB :

grep -r "\[mysqld\]" /etc/

MariaDB étant en version 10.1, ajouter les paramètres suivants au fichier /etc/mysql/mariadb.conf.d/50-server.cnf :

cp -p /etc/mysql/mariadb.conf.d/50-server.cnf /etc/mysql/mariadb.conf.d/50-server.cnf.bak
nano /etc/mysql/mariadb.conf.d/50-server.cnf
[mysqld]
innodb_file_per_table=1
innodb_large_prefix=true
innodb_file_format=barracuda

Redémarrer MariaDB :

systemctl restart mariadb.service

Ouvrir MariaDB et vérifier si le format de fichier a été modifié vers Barracuda :

mariadb -u root -p
SELECT NAME, SPACE, FILE_FORMAT FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME like "nextcloud%";
+------------------------------------------+-------+-------------   +
| NAME                                     | SPACE | FILE_FORMAT    |
+------------------------------------------+-------+-------------   +
| nextcloud_db/oc_accounts                 |   140 | Antelope       |
| nextcloud_db/oc_activity                 |   141 | Antelope       |
| nextcloud_db/oc_activity_mq              |   142 | Antelope       |
| nextcloud_db/oc_addressbookchanges       |   143 | Antelope       |
| nextcloud_db/oc_addressbooks             |   144 | Antelope       |
| nextcloud_db/oc_appconfig                |   145 | Antelope       |
| nextcloud_db/oc_authtoken                |   146 | Antelope       |
| nextcloud_db/oc_bruteforce_attempts      |   147 | Antelope       |
| nextcloud_db/oc_calendar_invitations     |   153 | Antelope       |
| nextcloud_db/oc_calendar_resources       |   154 | Antelope       |
| nextcloud_db/oc_calendar_rooms           |   155 | Antelope       |
| nextcloud_db/oc_calendarchanges          |   148 | Antelope       |
| nextcloud_db/oc_calendarobjects          |   149 | Antelope       |
| nextcloud_db/oc_calendarobjects_props    |   150 | Antelope       |
| nextcloud_db/oc_calendars                |   151 | Antelope       |
| nextcloud_db/oc_calendarsubscriptions    |   152 | Antelope       |
| nextcloud_db/oc_cards                    |   156 | Antelope       |
| nextcloud_db/oc_cards_properties         |   157 | Antelope       |
| nextcloud_db/oc_comments                 |   158 | Antelope       |
| nextcloud_db/oc_comments_read_markers    |   159 | Antelope       |
| nextcloud_db/oc_credentials              |   160 | Antelope       |
| nextcloud_db/oc_dav_shares               |   161 | Antelope       |
| nextcloud_db/oc_directlink               |   162 | Antelope       |
| nextcloud_db/oc_federated_reshares       |   163 | Antelope       |
| nextcloud_db/oc_file_locks               |   166 | Antelope       |
| nextcloud_db/oc_filecache                |   164 | Antelope       |
| nextcloud_db/oc_files_trash              |   165 | Antelope       |
| nextcloud_db/oc_flow_checks              |   167 | Antelope       |
| nextcloud_db/oc_flow_operations          |   168 | Antelope       |
| nextcloud_db/oc_group_admin              |   170 | Antelope       |
| nextcloud_db/oc_group_user               |   171 | Antelope       |
| nextcloud_db/oc_groups                   |   169 | Antelope       |
| nextcloud_db/oc_jobs                     |   172 | Antelope       |
| nextcloud_db/oc_migrations               |   173 | Antelope       |
| nextcloud_db/oc_mimetypes                |   174 | Antelope       |
| nextcloud_db/oc_mounts                   |   175 | Antelope       |
| nextcloud_db/oc_news_feeds               |   205 | Antelope       |
| nextcloud_db/oc_news_folders             |   204 | Antelope       |
| nextcloud_db/oc_news_items               |   206 | Antelope       |
| nextcloud_db/oc_notes_meta               |   176 | Antelope       |
| nextcloud_db/oc_notifications            |   177 | Antelope       |
| nextcloud_db/oc_notifications_pushtokens |   178 | Antelope       |
| nextcloud_db/oc_oauth2_access_tokens     |   179 | Antelope       |
| nextcloud_db/oc_oauth2_clients           |   180 | Antelope       |
| nextcloud_db/oc_preferences              |   181 | Antelope       |
| nextcloud_db/oc_privatedata              |   182 | Antelope       |
| nextcloud_db/oc_properties               |   183 | Antelope       |
| nextcloud_db/oc_schedulingobjects        |   184 | Antelope       |
| nextcloud_db/oc_share                    |   185 | Antelope       |
| nextcloud_db/oc_share_external           |   186 | Antelope       |
| nextcloud_db/oc_spreedme_tps             |   187 | Antelope       |
| nextcloud_db/oc_storages                 |   188 | Antelope       |
| nextcloud_db/oc_systemtag                |   189 | Antelope       |
| nextcloud_db/oc_systemtag_group          |   190 | Antelope       |
| nextcloud_db/oc_systemtag_object_mapping |   191 | Antelope       |
| nextcloud_db/oc_talk_guests              |   192 | Antelope       |
| nextcloud_db/oc_talk_participants        |   193 | Antelope       |
| nextcloud_db/oc_talk_rooms               |   194 | Antelope       |
| nextcloud_db/oc_talk_signaling           |   195 | Antelope       |
| nextcloud_db/oc_trusted_servers          |   196 | Antelope       |
| nextcloud_db/oc_twofactor_backupcodes    |   197 | Antelope       |
| nextcloud_db/oc_twofactor_providers      |   198 | Antelope       |
| nextcloud_db/oc_twofactor_totp_secrets   |   199 | Antelope       |
| nextcloud_db/oc_users                    |   200 | Antelope       |
| nextcloud_db/oc_vcategory                |   201 | Antelope       |
| nextcloud_db/oc_vcategory_to_object      |   202 | Antelope       |
| nextcloud_db/oc_whats_new                |   203 | Antelope       |
+------------------------------------------+-------+-------------   +
67 rows in set (0.01 sec)

Le format étant toujours Antelope, il faut migrer le système de fichier manuellement :

USE INFORMATION_SCHEMA;

Générer les commandes à appliquer pour modifier chaque table :

SELECT CONCAT("ALTER TABLE ", TABLE_SCHEMA,".", TABLE_NAME, " ROW_FORMAT=DYNAMIC;") AS MySQLCMD FROM TABLES WHERE TABLE_SCHEMA = "nextcloud_db";
+------------------------------------------------------------------------------+
| MySQLCMD                                                                     |
+------------------------------------------------------------------------------+
| ALTER TABLE nextcloud_db.oc_accounts ROW_FORMAT=DYNAMIC;                 |
| ALTER TABLE nextcloud_db.oc_activity ROW_FORMAT=DYNAMIC;                 |
| ALTER TABLE nextcloud_db.oc_activity_mq ROW_FORMAT=DYNAMIC;              |
| ALTER TABLE nextcloud_db.oc_addressbookchanges ROW_FORMAT=DYNAMIC;       |
| ALTER TABLE nextcloud_db.oc_addressbooks ROW_FORMAT=DYNAMIC;             |
| ALTER TABLE nextcloud_db.oc_appconfig ROW_FORMAT=DYNAMIC;                |
| ALTER TABLE nextcloud_db.oc_authtoken ROW_FORMAT=DYNAMIC;                |
| ALTER TABLE nextcloud_db.oc_bruteforce_attempts ROW_FORMAT=DYNAMIC;      |
| ALTER TABLE nextcloud_db.oc_calendar_invitations ROW_FORMAT=DYNAMIC;     |
| ALTER TABLE nextcloud_db.oc_calendar_resources ROW_FORMAT=DYNAMIC;       |
| ALTER TABLE nextcloud_db.oc_calendar_rooms ROW_FORMAT=DYNAMIC;           |
| ALTER TABLE nextcloud_db.oc_calendarchanges ROW_FORMAT=DYNAMIC;          |
| ALTER TABLE nextcloud_db.oc_calendarobjects ROW_FORMAT=DYNAMIC;          |
| ALTER TABLE nextcloud_db.oc_calendarobjects_props ROW_FORMAT=DYNAMIC;    |
| ALTER TABLE nextcloud_db.oc_calendars ROW_FORMAT=DYNAMIC;                |
| ALTER TABLE nextcloud_db.oc_calendarsubscriptions ROW_FORMAT=DYNAMIC;    |
| ALTER TABLE nextcloud_db.oc_cards ROW_FORMAT=DYNAMIC;                    |
| ALTER TABLE nextcloud_db.oc_cards_properties ROW_FORMAT=DYNAMIC;         |
| ALTER TABLE nextcloud_db.oc_comments ROW_FORMAT=DYNAMIC;                 |
| ALTER TABLE nextcloud_db.oc_comments_read_markers ROW_FORMAT=DYNAMIC;    |
| ALTER TABLE nextcloud_db.oc_credentials ROW_FORMAT=DYNAMIC;              |
| ALTER TABLE nextcloud_db.oc_dav_shares ROW_FORMAT=DYNAMIC;               |
| ALTER TABLE nextcloud_db.oc_directlink ROW_FORMAT=DYNAMIC;               |
| ALTER TABLE nextcloud_db.oc_federated_reshares ROW_FORMAT=DYNAMIC;       |
| ALTER TABLE nextcloud_db.oc_file_locks ROW_FORMAT=DYNAMIC;               |
| ALTER TABLE nextcloud_db.oc_filecache ROW_FORMAT=DYNAMIC;                |
| ALTER TABLE nextcloud_db.oc_files_trash ROW_FORMAT=DYNAMIC;              |
| ALTER TABLE nextcloud_db.oc_flow_checks ROW_FORMAT=DYNAMIC;              |
| ALTER TABLE nextcloud_db.oc_flow_operations ROW_FORMAT=DYNAMIC;          |
| ALTER TABLE nextcloud_db.oc_group_admin ROW_FORMAT=DYNAMIC;              |
| ALTER TABLE nextcloud_db.oc_group_user ROW_FORMAT=DYNAMIC;               |
| ALTER TABLE nextcloud_db.oc_groups ROW_FORMAT=DYNAMIC;                   |
| ALTER TABLE nextcloud_db.oc_jobs ROW_FORMAT=DYNAMIC;                     |
| ALTER TABLE nextcloud_db.oc_migrations ROW_FORMAT=DYNAMIC;               |
| ALTER TABLE nextcloud_db.oc_mimetypes ROW_FORMAT=DYNAMIC;                |
| ALTER TABLE nextcloud_db.oc_mounts ROW_FORMAT=DYNAMIC;                   |
| ALTER TABLE nextcloud_db.oc_news_feeds ROW_FORMAT=DYNAMIC;               |
| ALTER TABLE nextcloud_db.oc_news_folders ROW_FORMAT=DYNAMIC;             |
| ALTER TABLE nextcloud_db.oc_news_items ROW_FORMAT=DYNAMIC;               |
| ALTER TABLE nextcloud_db.oc_notes_meta ROW_FORMAT=DYNAMIC;               |
| ALTER TABLE nextcloud_db.oc_notifications ROW_FORMAT=DYNAMIC;            |
| ALTER TABLE nextcloud_db.oc_notifications_pushtokens ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_oauth2_access_tokens ROW_FORMAT=DYNAMIC;     |
| ALTER TABLE nextcloud_db.oc_oauth2_clients ROW_FORMAT=DYNAMIC;           |
| ALTER TABLE nextcloud_db.oc_preferences ROW_FORMAT=DYNAMIC;              |
| ALTER TABLE nextcloud_db.oc_privatedata ROW_FORMAT=DYNAMIC;              |
| ALTER TABLE nextcloud_db.oc_properties ROW_FORMAT=DYNAMIC;               |
| ALTER TABLE nextcloud_db.oc_schedulingobjects ROW_FORMAT=DYNAMIC;        |
| ALTER TABLE nextcloud_db.oc_share ROW_FORMAT=DYNAMIC;                    |
| ALTER TABLE nextcloud_db.oc_share_external ROW_FORMAT=DYNAMIC;           |
| ALTER TABLE nextcloud_db.oc_spreedme_tps ROW_FORMAT=DYNAMIC;             |
| ALTER TABLE nextcloud_db.oc_storages ROW_FORMAT=DYNAMIC;                 |
| ALTER TABLE nextcloud_db.oc_systemtag ROW_FORMAT=DYNAMIC;                |
| ALTER TABLE nextcloud_db.oc_systemtag_group ROW_FORMAT=DYNAMIC;          |
| ALTER TABLE nextcloud_db.oc_systemtag_object_mapping ROW_FORMAT=DYNAMIC; |
| ALTER TABLE nextcloud_db.oc_talk_guests ROW_FORMAT=DYNAMIC;              |
| ALTER TABLE nextcloud_db.oc_talk_participants ROW_FORMAT=DYNAMIC;        |
| ALTER TABLE nextcloud_db.oc_talk_rooms ROW_FORMAT=DYNAMIC;               |
| ALTER TABLE nextcloud_db.oc_talk_signaling ROW_FORMAT=DYNAMIC;           |
| ALTER TABLE nextcloud_db.oc_trusted_servers ROW_FORMAT=DYNAMIC;          |
| ALTER TABLE nextcloud_db.oc_twofactor_backupcodes ROW_FORMAT=DYNAMIC;    |
| ALTER TABLE nextcloud_db.oc_twofactor_providers ROW_FORMAT=DYNAMIC;      |
| ALTER TABLE nextcloud_db.oc_twofactor_totp_secrets ROW_FORMAT=DYNAMIC;   |
| ALTER TABLE nextcloud_db.oc_users ROW_FORMAT=DYNAMIC;                    |
| ALTER TABLE nextcloud_db.oc_vcategory ROW_FORMAT=DYNAMIC;                |
| ALTER TABLE nextcloud_db.oc_vcategory_to_object ROW_FORMAT=DYNAMIC;      |
| ALTER TABLE nextcloud_db.oc_whats_new ROW_FORMAT=DYNAMIC;                |
+------------------------------------------------------------------------------+

Exécuter les commandes :

ALTER TABLE nextcloud_db.oc_accounts ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_activity ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_activity_mq ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_addressbookchanges ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_addressbooks ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_appconfig ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_authtoken ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_bruteforce_attempts ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_calendar_invitations ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_calendar_resources ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_calendar_rooms ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_calendarchanges ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_calendarobjects ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_calendarobjects_props ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_calendars ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_calendarsubscriptions ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_cards ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_cards_properties ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_comments ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_comments_read_markers ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_credentials ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_dav_shares ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_directlink ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_federated_reshares ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_file_locks ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_filecache ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_files_trash ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_flow_checks ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_flow_operations ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_group_admin ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_group_user ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_groups ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_jobs ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_migrations ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_mimetypes ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_mounts ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_news_feeds ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_news_folders ROW_FORMAT=DYNAMIC; 
ALTER TABLE nextcloud_db.oc_news_items ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_notes_meta ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_notifications ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_notifications_pushtokens ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_oauth2_access_tokens ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_oauth2_clients ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_preferences ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_privatedata ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_properties ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_schedulingobjects ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_share ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_share_external ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_spreedme_tps ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_storages ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_systemtag ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_systemtag_group ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_systemtag_object_mapping ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_talk_guests ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_talk_participants ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_talk_rooms ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_talk_signaling ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_trusted_servers ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_twofactor_backupcodes ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_twofactor_providers ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_twofactor_totp_secrets ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_users ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_vcategory ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_vcategory_to_object ROW_FORMAT=DYNAMIC;
ALTER TABLE nextcloud_db.oc_whats_new ROW_FORMAT=DYNAMIC;

Redémarrer MariaDB :

systemctl restart mariadb.service

Ouvrir MariaDB et modifier les caracter set et collation :

mariadb -u root -p
ALTER DATABASE nextcloud_db CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;

Vérifier que le format de fichier a été modifié vers Barracuda :

SELECT NAME, SPACE, FILE_FORMAT FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE NAME like "nextcloud%";
+------------------------------------------+-------+-------------+
| NAME                                     | SPACE | FILE_FORMAT |
+------------------------------------------+-------+-------------+
| nextcloud_db/oc_accounts                 |   207 | Barracuda   |
| nextcloud_db/oc_activity                 |   208 | Barracuda   |
| nextcloud_db/oc_activity_mq              |   209 | Barracuda   |
| nextcloud_db/oc_addressbookchanges       |   210 | Barracuda   |
| nextcloud_db/oc_addressbooks             |   211 | Barracuda   |
| nextcloud_db/oc_appconfig                |   212 | Barracuda   |
| nextcloud_db/oc_authtoken                |   213 | Barracuda   |
| nextcloud_db/oc_bruteforce_attempts      |   214 | Barracuda   |
| nextcloud_db/oc_calendar_invitations     |   215 | Barracuda   |
| nextcloud_db/oc_calendar_resources       |   216 | Barracuda   |
| nextcloud_db/oc_calendar_rooms           |   217 | Barracuda   |
| nextcloud_db/oc_calendarchanges          |   218 | Barracuda   |
| nextcloud_db/oc_calendarobjects          |   219 | Barracuda   |
| nextcloud_db/oc_calendarobjects_props    |   220 | Barracuda   |
| nextcloud_db/oc_calendars                |   221 | Barracuda   |
| nextcloud_db/oc_calendarsubscriptions    |   222 | Barracuda   |
| nextcloud_db/oc_cards                    |   223 | Barracuda   |
| nextcloud_db/oc_cards_properties         |   224 | Barracuda   |
| nextcloud_db/oc_comments                 |   225 | Barracuda   |
| nextcloud_db/oc_comments_read_markers    |   226 | Barracuda   |
| nextcloud_db/oc_credentials              |   227 | Barracuda   |
| nextcloud_db/oc_dav_shares               |   228 | Barracuda   |
| nextcloud_db/oc_directlink               |   229 | Barracuda   |
| nextcloud_db/oc_federated_reshares       |   230 | Barracuda   |
| nextcloud_db/oc_file_locks               |   231 | Barracuda   |
| nextcloud_db/oc_filecache                |   232 | Barracuda   |
| nextcloud_db/oc_files_trash              |   233 | Barracuda   |
| nextcloud_db/oc_flow_checks              |   234 | Barracuda   |
| nextcloud_db/oc_flow_operations          |   235 | Barracuda   |
| nextcloud_db/oc_group_admin              |   236 | Barracuda   |
| nextcloud_db/oc_group_user               |   237 | Barracuda   |
| nextcloud_db/oc_groups                   |   238 | Barracuda   |
| nextcloud_db/oc_jobs                     |   239 | Barracuda   |
| nextcloud_db/oc_migrations               |   240 | Barracuda   |
| nextcloud_db/oc_mimetypes                |   241 | Barracuda   |
| nextcloud_db/oc_mounts                   |   242 | Barracuda   |
| nextcloud_db/oc_news_feeds               |   243 | Barracuda   |
| nextcloud_db/oc_news_folders             |   244 | Barracuda   |
| nextcloud_db/oc_news_items               |   245 | Barracuda   |
| nextcloud_db/oc_notes_meta               |   246 | Barracuda   |
| nextcloud_db/oc_notifications            |   247 | Barracuda   |
| nextcloud_db/oc_notifications_pushtokens |   248 | Barracuda   |
| nextcloud_db/oc_oauth2_access_tokens     |   249 | Barracuda   |
| nextcloud_db/oc_oauth2_clients           |   250 | Barracuda   |
| nextcloud_db/oc_preferences              |   251 | Barracuda   |
| nextcloud_db/oc_privatedata              |   252 | Barracuda   |
| nextcloud_db/oc_properties               |   253 | Barracuda   |
| nextcloud_db/oc_schedulingobjects        |   254 | Barracuda   |
| nextcloud_db/oc_share                    |   255 | Barracuda   |
| nextcloud_db/oc_share_external           |   256 | Barracuda   |
| nextcloud_db/oc_spreedme_tps             |   257 | Barracuda   |
| nextcloud_db/oc_storages                 |   258 | Barracuda   |
| nextcloud_db/oc_systemtag                |   259 | Barracuda   |
| nextcloud_db/oc_systemtag_group          |   260 | Barracuda   |
| nextcloud_db/oc_systemtag_object_mapping |   261 | Barracuda   |
| nextcloud_db/oc_talk_guests              |   262 | Barracuda   |
| nextcloud_db/oc_talk_participants        |   263 | Barracuda   |
| nextcloud_db/oc_talk_rooms               |   264 | Barracuda   |
| nextcloud_db/oc_talk_signaling           |   265 | Barracuda   |
| nextcloud_db/oc_trusted_servers          |   266 | Barracuda   |
| nextcloud_db/oc_twofactor_backupcodes    |   267 | Barracuda   |
| nextcloud_db/oc_twofactor_providers      |   268 | Barracuda   |
| nextcloud_db/oc_twofactor_totp_secrets   |   269 | Barracuda   |
| nextcloud_db/oc_users                    |   270 | Barracuda   |
| nextcloud_db/oc_vcategory                |   271 | Barracuda   |
| nextcloud_db/oc_vcategory_to_object      |   272 | Barracuda   |
| nextcloud_db/oc_whats_new                |   273 | Barracuda   |
+------------------------------------------+-------+-------------+
67 rows in set (0.00 sec)

Appliquer les commandes suivantes pour terminer la conversion :

cd /var/www/html/nextcloud/
sudo -u www-data php occ config:system:set mysql.utf8mb4 --type boolean --value="true"
System config value mysql.utf8mb4 set to boolean true
sudo -u www-data php occ maintenance:repair
     - Change row format for oc_notes_meta ...
     - Change collation for oc_notes_meta ...
     - Change row format for oc_notifications ...
     - Change collation for oc_notifications ...
     - Change row format for oc_notifications_pushtokens ...
     - Change collation for oc_notifications_pushtokens ...
     - Change row format for oc_oauth2_access_tokens ...
     - Change collation for oc_oauth2_access_tokens ...
     - Change row format for oc_oauth2_clients ...
     - Change collation for oc_oauth2_clients ...
     - Change row format for oc_preferences ...
     - Change collation for oc_preferences ...
     - Change row format for oc_privatedata ...
     - Change collation for oc_privatedata ...
     - Change row format for oc_properties ...
     - Change collation for oc_properties ...
     - Change row format for oc_schedulingobjects ...
     - Change collation for oc_schedulingobjects ...
     - Change row format for oc_share ...
     - Change collation for oc_share ...
     - Change row format for oc_share_external ...
     - Change collation for oc_share_external ...
     - Change row format for oc_spreedme_tps ...
     - Change collation for oc_spreedme_tps ...
     - Change row format for oc_storages ...
     - Change collation for oc_storages ...
     - Change row format for oc_systemtag ...
     - Change collation for oc_systemtag ...
     - Change row format for oc_systemtag_group ...
     - Change collation for oc_systemtag_group ...
     - Change row format for oc_systemtag_object_mapping ...
     - Change collation for oc_systemtag_object_mapping ...
     - Change row format for oc_talk_guests ...
     - Change collation for oc_talk_guests ...
     - Change row format for oc_talk_participants ...
     - Change collation for oc_talk_participants ...
     - Change row format for oc_talk_rooms ...
     - Change collation for oc_talk_rooms ...
     - Change row format for oc_talk_signaling ...
     - Change collation for oc_talk_signaling ...
     - Change row format for oc_trusted_servers ...
     - Change collation for oc_trusted_servers ...
     - Change row format for oc_twofactor_backupcodes ...
     - Change collation for oc_twofactor_backupcodes ...
     - Change row format for oc_twofactor_providers ...
     - Change collation for oc_twofactor_providers ...
     - Change row format for oc_twofactor_totp_secrets ...
     - Change collation for oc_twofactor_totp_secrets ...
     - Change row format for oc_users ...
     - Change collation for oc_users ...
     - Change row format for oc_vcategory ...
     - Change collation for oc_vcategory ...
     - Change row format for oc_vcategory_to_object ...
     - Change collation for oc_vcategory_to_object ...
     - Change row format for oc_whats_new ...
     - Change collation for oc_whats_new ...
     - Change row format for oc_federated_reshares ...
     - Change collation for oc_federated_reshares ...
 - Repair mime types
 - Clean tags and favorites
     - 0 tags of deleted users have been removed.
     - 0 tags for delete files have been removed.
     - 0 tag entries for deleted tags have been removed.
     - 0 tags with no entries have been removed.
 - Repair invalid shares
 - Remove shares of a users root folder
 - Move .step file of updater to backup location
 - Fix potential broken mount points
     - No mounts updated
 - Repair invalid paths in file cache
 - Add log rotate job
 - Clear frontend caches
     - Image cache cleared
     - SCSS cache cleared
     - JS cache cleared
 - Clear every generated avatar on major updates
 - Add preview background cleanup job
 - Queue a one-time job to cleanup old backups of the updater
 - Repair pending cron jobs
     - No need to repair pending cron jobs.
 - Extract the vcard uid and store it in the db
 - Fix component of birthday calendars
     - 2 birthday calendars updated.
 - Fix broken values of calendar objects
    0 [>---------------------------]
 - Registering building of calendar search index as background job
     - Repair step already executed
 - Registering background jobs to update cache for webcal calendars
     - Added 0 background jobs to update webcal calendars
 - Remove activity entries of private events
     - Removed 0 activity entries
 - Fix the share type of guest shares when migrating from ownCloud
 - Copy the share password into the dedicated column
 - Migrate binary status into separate boolean fields
 - Update OAuth token expiration times
 - Add background job to check for backup codes

Sources

https://docs.nextcloud.com/server/15/admin_manual/configuration_database/mysql_4byte_support.html