- Incorrect row format found in your database. ROW_FORMAT=Dynamic offers the best database performances for Nextcloud. Please update row format on the following list: oc_comments_read_markers, oc_text_documents, oc_audioplayer_artists, oc_circles_token, oc_calendar_resources_md, oc_addressbooks, oc_systemtag_object_mapping, oc_dav_shares, oc_duplicatefinder_finfo, oc_audioplayer_whats_new, oc_login_flow_v2, oc_accounts_data, oc_flow_checks, oc_calendarsubscriptions, oc_systemtag, oc_calendar_appt_bookings, oc_profile_config, oc_properties, oc_maps_apikeys, oc_groups, oc_mounts, oc_calendarobjects_props, oc_circles_share_lock, oc_oauth2_clients, oc_systemtag_group, oc_ratelimit_entries, oc_storages_credentials, oc_activity, oc_collres_accesscache, oc_group_user, oc_schedulingobjects, oc_files_trash, oc_preferences, oc_circles_membership, oc_privacy_admins, oc_maps_address_geo, oc_file_locks, oc_authtoken, oc_dav_cal_proxy, oc_whats_new, oc_collres_collections, oc_migrations, oc_share_external, oc_trusted_servers, oc_federated_reshares, oc_circles_remote, oc_circles_mountpoint, oc_calendarchanges, oc_bruteforce_attempts, oc_audioplayer_playlists, oc_activity_mq, oc_oauth2_access_tokens, oc_calendar_resources, oc_mimetypes, oc_notifications_pushhash, oc_maps_devices, oc_text_sessions, oc_cards, oc_calendars, oc_storages, oc_group_admin, oc_maps_photos, oc_calendar_rooms_md, oc_flow_operations, oc_direct_edit, oc_audioplayer_stats, oc_comments, oc_filecache_extended, oc_vcategory_to_object, oc_text_steps, oc_user_transfer_owner, oc_twofactor_backupcodes, oc_authorized_groups, oc_accounts, oc_recent_contact, oc_webauthn, oc_audioplayer_streams, oc_jobs, oc_calendar_appt_configs, oc_circles_mount, oc_notifications_settings, oc_audioplayer_albums, oc_directlink, oc_users, oc_audioplayer_tracks, oc_audioplayer_playlist_tracks, oc_calendar_reminders, oc_cards_properties, oc_maps_favorites, oc_circles_member, oc_vcategory, oc_notifications, oc_preview_generation, oc_appconfig, oc_calendar_rooms, oc_filecache, oc_user_status, oc_share, oc_flow_operations_scope, oc_circles_circle, oc_calendarobjects, oc_addressbookchanges, oc_maps_device_points, oc_maps_tracks, oc_maps_favorite_shares, oc_circles_event, oc_audioplayer_genre, oc_twofactor_providers, oc_duplicatefinder_dups_f, oc_duplicatefinder_dups, oc_known_users, oc_collres_resources, oc_calendar_invitations. For more details see the documentation ↗.
docker exec -it cloud-db /bin/bash
based on post, but removed MYSQL password promt since it is already in docker environment variables. May take minutes..
mysql -u "$MYSQL_USER" -p"$MYSQL_PASSWORD" -e "
SELECT CONCAT('ALTER TABLE \`', TABLE_NAME, '\` ROW_FORMAT=DYNAMIC;')
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = '$MYSQL_DATABASE'
AND ENGINE = 'InnoDB';
" -B -N | while read -r sql; do
mysql -u "$MYSQL_USER" -p"$MYSQL_PASSWORD" -e "$sql" "$MYSQL_DATABASE"
done
