Actions
Anomalie #4165
fermévalise.april.org – Avertissement de configuration sur l'absence de support de l'unicode 4 octets pour la base de données
Ajouté par Christian P. Momon il y a presque 5 ans. Mis à jour il y a plus de 4 ans.
Début:
09/01/2020
Echéance:
% réalisé:
0%
Temps estimé:
Difficulté:
2 Facile
Description
Avec le compte admin, dans la page « Paramètres > Administration > Vue d'ensemble », on peut lire :
MySQL est utilisée comme base de données mais ne supporte pas les caractères codés sur 4 octets.
Pour pouvoir manipuler les caractères sur 4 octets (comme les émoticônes) sans problème dans les
noms de fichiers ou les commentaires par exemple, il est recommandé d'activer le support 4 octets dans MySQL.
Pour plus de détails, lisez la page de documentation à ce sujet
Actions
#1
Mis à jour par Christian P. Momon il y a presque 5 ans
- Tracker changé de Demande à Anomalie
Actions
#2
Mis à jour par François Poulain il y a presque 5 ans
Attention en général ça ne fonctionne pas « as is ».
Extrait d'un CR d'install :
https://docs.nextcloud.com/server/15/admin_manual/configuration_database/mysql_4byte_support.html MariaDB [(none)]> ALTER DATABASE nextcloud_db CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci; Query OK, 1 row affected (0.03 sec) bling@web:~/www/nextcloud$ php occ config:system:set mysql.utf8mb4 --type boolean --value="true" System config value mysql.utf8mb4 set to boolean true bling@web:~/www/nextcloud$ php occ maintenance:repair - Repair MySQL collation - Change row format for oc_accounts ... - Change collation for oc_accounts ... - Change row format for oc_activity ... - Change collation for oc_activity ... - Change row format for oc_activity_mq ... - Change collation for oc_activity_mq ... - Change row format for oc_addressbookchanges ... - Change collation for oc_addressbookchanges ... - Change row format for oc_addressbooks ... - Change collation for oc_addressbooks ... ... Forcément ça plante. J'ai eu une erreur résolue par ça : https://help.nextcloud.com/t/solved-syntax-error-or-access-violation-1071-specified-key-was-too-long-max-key-length-is-767-bytes/34740 MariaDB [(none)]> use nextcloud_db; Database changed MariaDB [nextcloud_db]> set global innodb_large_prefix=on; Query OK, 0 rows affected (0.00 sec) MariaDB [nextcloud_db]> set global innodb_file_format=Barracuda; Query OK, 0 rows affected (0.00 sec) php occ maintenance:repair ... php occ maintenance:mode --off
Actions
#3
Mis à jour par Quentin Gibeaux il y a presque 5 ans
- Version cible changé de Janvier 2020 à Février 2020
Actions
#4
Mis à jour par Quentin Gibeaux il y a plus de 4 ans
- Version cible changé de Février 2020 à Mars 2020
Actions
#5
Mis à jour par François Poulain il y a plus de 4 ans
- Statut changé de Nouveau à Résolu
- Assigné à mis à François Poulain
Fait.
# sudo -u www-data php -f /var/www/valise-new.april.org/occ config:system:set mysql.utf8mb4 --type boolean --value="true" System config value mysql.utf8mb4 set to boolean true # sudo -u www-data php -f /var/www/valise-new.april.org/occ maintenance:repair - Repair MySQL collation - Change row format for oc_group_admin ... - Change collation for oc_group_admin ... - Change row format for oc_systemtag ... - Change collation for oc_systemtag ... - Change row format for oc_talk_participants ... - Change collation for oc_talk_participants ... - Change row format for oc_migrations ... - Change collation for oc_migrations ... - Change row format for oc_calendar_rooms ... - Change collation for oc_calendar_rooms ... - Change row format for oc_oauth2_clients ... - Change collation for oc_oauth2_clients ... - Change row format for oc_comments_read_markers ... - Change collation for oc_comments_read_markers ... - Change row format for oc_flow_operations_scope ... - Change collation for oc_flow_operations_scope ... - Change row format for oc_authtoken ... - Change collation for oc_authtoken ... - Change row format for oc_login_flow_v2 ... - Change collation for oc_login_flow_v2 ... - Change row format for oc_preferences ... - Change collation for oc_preferences ... - Change row format for oc_calendarobjects ... - Change collation for oc_calendarobjects ... - Change row format for oc_text_steps ... - Change collation for oc_text_steps ... - Change row format for oc_collres_accesscache ... - Change collation for oc_collres_accesscache ... - Change row format for oc_groups ... - Change collation for oc_groups ... - Change row format for oc_calendar_invitations ... - Change collation for oc_calendar_invitations ... - Change row format for oc_comments ... - Change collation for oc_comments ... - Change row format for oc_talk_signaling ... - Change collation for oc_talk_signaling ... - Change row format for oc_directlink ... - Change collation for oc_directlink ... - Change row format for oc_dav_cal_proxy ... - Change collation for oc_dav_cal_proxy ... - Change row format for oc_trusted_servers ... - Change collation for oc_trusted_servers ... - Change row format for oc_systemtag_group ... - Change collation for oc_systemtag_group ... - Change row format for oc_cards_properties ... - Change collation for oc_cards_properties ... - Change row format for oc_accounts ... - Change collation for oc_accounts ... - Change row format for oc_systemtag_object_mapping ... - Change collation for oc_systemtag_object_mapping ... - Change row format for oc_appconfig ... - Change collation for oc_appconfig ... - Change row format for oc_vcategory ... - Change collation for oc_vcategory ... - Change row format for oc_calendar_resources ... - Change collation for oc_calendar_resources ... - Change row format for oc_file_locks ... - Change collation for oc_file_locks ... - Change row format for oc_mimetypes ... - Change collation for oc_mimetypes ... - Change row format for oc_activity_mq ... - Change collation for oc_activity_mq ... - Change row format for oc_oauth2_access_tokens ... - Change collation for oc_oauth2_access_tokens ... - Change row format for oc_cards ... - Change collation for oc_cards ... - Change row format for oc_text_documents ... - Change collation for oc_text_documents ... - Change row format for oc_mounts ... - Change collation for oc_mounts ... - Change row format for oc_user_transfer_owner ... - Change collation for oc_user_transfer_owner ... - Change row format for oc_schedulingobjects ... - Change collation for oc_schedulingobjects ... - Change row format for oc_calendar_rooms_md ... - Change collation for oc_calendar_rooms_md ... - Change row format for oc_twofactor_backupcodes ... - Change collation for oc_twofactor_backupcodes ... - Change row format for oc_filecache_extended ... - Change collation for oc_filecache_extended ... - Change row format for oc_calendarchanges ... - Change collation for oc_calendarchanges ... - Change row format for oc_activity ... - Change collation for oc_activity ... - Change row format for oc_whats_new ... - Change collation for oc_whats_new ... - Change row format for oc_jobs ... - Change collation for oc_jobs ... - Change row format for oc_share ... - Change collation for oc_share ... - Change row format for oc_collres_collections ... - Change collation for oc_collres_collections ... - Change row format for oc_calendar_reminders ... - Change collation for oc_calendar_reminders ... - Change row format for oc_talk_guests ... - Change collation for oc_talk_guests ... - Change row format for oc_notifications ... - Change collation for oc_notifications ... - Change row format for oc_talk_rooms ... - Change collation for oc_talk_rooms ... - Change row format for oc_twofactor_providers ... - Change collation for oc_twofactor_providers ... - Change row format for oc_addressbookchanges ... - Change collation for oc_addressbookchanges ... - Change row format for oc_share_external ... - Change collation for oc_share_external ... - Change row format for oc_flow_operations ... - Change collation for oc_flow_operations ... - Change row format for oc_credentials ... - Change collation for oc_credentials ... - Change row format for oc_flow_checks ... - Change collation for oc_flow_checks ... - Change row format for oc_privacy_admins ... - Change collation for oc_privacy_admins ... - Change row format for oc_calendars ... - Change collation for oc_calendars ... - Change row format for oc_calendarsubscriptions ... - Change collation for oc_calendarsubscriptions ... - Change row format for oc_direct_edit ... - Change collation for oc_direct_edit ... - Change row format for oc_files_trash ... - Change collation for oc_files_trash ... - Change row format for oc_talk_commands ... - Change collation for oc_talk_commands ... - Change row format for oc_group_user ... - Change collation for oc_group_user ... - Change row format for oc_users ... - Change collation for oc_users ... - Change row format for oc_addressbooks ... - Change collation for oc_addressbooks ... - Change row format for oc_text_sessions ... - Change collation for oc_text_sessions ... - Change row format for oc_storages ... - Change collation for oc_storages ... - Change row format for oc_vcategory_to_object ... - Change collation for oc_vcategory_to_object ... - Change row format for oc_collres_resources ... - Change collation for oc_collres_resources ... - Change row format for oc_calendarobjects_props ... - Change collation for oc_calendarobjects_props ... - Change row format for oc_calendar_resources_md ... - Change collation for oc_calendar_resources_md ... - Change row format for oc_properties ... - Change collation for oc_properties ... - Change row format for oc_dav_shares ... - Change collation for oc_dav_shares ... - Change row format for oc_notifications_pushtokens ... - Change collation for oc_notifications_pushtokens ... - Change row format for oc_bruteforce_attempts ... - Change collation for oc_bruteforce_attempts ... - Change row format for oc_filecache ... - Change collation for oc_filecache ... - 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 - Move .step file of updater to backup location - Fix potential broken mount points - No mounts updated - 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 - Cleanup invalid photocache files for carddav - Add background job to cleanup login flow v2 tokens - Remove potentially over exposing share links - No need to remove link shares. - Clear access cache of projects - Switches from deprecated "production" to "stable" update channel - Sets the enterprise logo - Repair step already executed - Reset generated avatar flag - Update name of the stored view - Fix component of birthday calendars - 4 birthday calendars updated. - Regenerating birthday calendars to use new icons and fix old birthday events without year - Repair step already executed - 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 - Registering building of calendar reminder index as background job - Repair step already executed - Clean up orphan event and contact data - 0 events without a calendar have been cleaned up - 0 properties without an events have been cleaned up - 0 changes without a calendar have been cleaned up - 0 cached events without a calendar subscription have been cleaned up - 0 changes without a calendar subscription have been cleaned up - 0 contacts without an addressbook have been cleaned up - 0 properties without a contact have been cleaned up - 0 changes without an addressbook have been cleaned up - 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 - Set existing shares as accepted - Update OAuth token expiration times - Create help command - Invalidate access cache for projects conversation provider - Invalidation not required - Add background job to check for backup codes - Populating added database structures for workflows
Actions