Raspi NC Update 30.0.10 to 31.0.4 log error wrong Linie format

[buzzzz]

Hi,

I did an update from 30.0.10 to 31.0.4.
My ncp was installed via install script on buster and later updated to raspi os bookworm.

The Basics

• Nextcloud Server version (e.g., 29.x.x):
  • 31.0.4
• Operating system and version (e.g., Ubuntu 24.04):
  • raspios bookworm
• Web server and version (e.g, Apache 2.4.25):
  • replace me
• PHP version (e.g, 8.3):
  • 8.3
• Is this the first time you’ve seen this error? (Yes / No):
  • yes
• When did this problem seem to first start?
  • No, at the protocol
• Installation method (e.g. AlO, NCP, Bare Metal/Archive, etc.)
  • NCP
• Are you using CloudfIare, mod_security, or similar? (Yes / No)
  • no

Summary of the issue you are facing:

Sorry itś in german:
Es gibt einige Warnungen in der Systemkonfiguration.

• 1871 Fehler in den Protokollen seit 12. April 2025, 13:53:50
• Falsches Zeilenformat in deiner Datenbank gefunden. ROW_FORMAT=Dynamic bietet die beste Datenbankleistung für Nextcloud. Bitte aktualisiere das Zeilenformat in der folgenden Liste: oc_health_sleepdata, oc_calendarsubscriptions, oc_ratelimit_entries, oc_bookmarks_root_folders, oc_cospend_shares, oc_text_steps, oc_calendarobjects, oc_cospend_projects, oc_jobs, oc_cards_properties, oc_talk_sessions, oc_vcategory, oc_addressbooks, oc_calendar_reminders, oc_richdocuments_direct, oc_user_status, oc_group_folders_groups, oc_accounts_data, oc_oauth2_clients, oc_talk_bridges, oc_bruteforce_attempts, oc_systemtag_group, oc_richdocuments_assets, oc_phonetrack_points, oc_phonetrack_geofences, oc_circles_circle, oc_bookmarks, oc_notifications_settings, oc_deck_board_acl, oc_known_users, oc_dav_cal_proxy, oc_authorized_groups, oc_phonetrack_devices, oc_group_folders, oc_webauthn, oc_mounts, oc_calendarobjects_props, oc_bookmarks_tree, oc_flow_operations, oc_talk_attendees, oc_files_trash, oc_phonetrack_shares, oc_bookmarks_folders, oc_phonetrack_filtersb, oc_reader_bookmarks, oc_flow_checks, oc_talk_commands, oc_storages_credentials, oc_groups, oc_properties, oc_deck_attachment, oc_calendars, oc_health_feelingdata, oc_circles_member, oc_health_persons, oc_calendar_rooms_md, oc_notifications_pushhash, oc_circles_mountpoint, oc_notifications, oc_dav_shares, oc_carnet_metadata, oc_authtoken, oc_health_activitiesdata, oc_bookmarks_shared_to_shares, oc_activity, oc_text_sessions, oc_twofactor_providers, oc_deck_assigned_labels, oc_news_items, oc_talk_invitations, oc_circles_membership, oc_calendar_invitations, oc_health_smokingdata, oc_calendar_appt_bookings, oc_circles_mount, oc_deck_assigned_users, oc_user_transfer_owner, oc_circles_event, oc_calendar_resources_md, oc_bookmarks_tags, oc_filecache, oc_cospend_currencies, oc_deck_stacks, oc_richdocuments_template, oc_appconfig, oc_group_folders_manage, oc_share_external, oc_talk_internalsignaling, oc_bookmarks_folders_public, oc_mimetypes, oc_storages, oc_reader_prefs, oc_twofactor_backupcodes, oc_group_admin, oc_preferences, oc_weather_city, oc_calendarchanges, oc_users, oc_circles_share_lock, oc_addressbookchanges, oc_cookbook_names, oc_news_feeds, oc_health_weightdata, oc_circles_token, oc_oauth2_access_tokens, oc_collres_accesscache, oc_cospend_bills, oc_cookbook_categories, oc_filecache_extended, oc_bookmarks_shared_folders, oc_group_folders_trash, oc_direct_edit, oc_file_locks, oc_schedulingobjects, oc_cards, oc_vcategory_to_object, oc_phonetrack_sessions, oc_notes_meta, oc_calendar_rooms, oc_login_flow_v2, oc_group_folders_acl, oc_flow_operations_scope, oc_whats_new, oc_calendar_resources, oc_cospend_bill_owers, oc_collectives_shares, oc_accounts, oc_directlink, oc_twofactor_totp_secrets, oc_richdocuments_wopi, oc_deck_labels, oc_bookmarks_shares, oc_profile_config, oc_talk_rooms, oc_ncdownloader_info, oc_circles_remote, oc_deck_boards, oc_federated_reshares, oc_cospend_members, oc_collres_resources, oc_cospend_paymentmodes, oc_migrations, oc_text_documents, oc_group_user, oc_deck_cards, oc_activity_mq, oc_collectives_pages, oc_trusted_servers, oc_weather_config, oc_share, oc_privacy_admins, oc_phonetrack_tileserver, oc_comments_read_markers, oc_news_folders, oc_collres_collections, oc_calendar_appt_configs, oc_collectives, oc_cospend_categories, oc_systemtag, oc_health_measurementdata, oc_recent_contact, oc_systemtag_object_mapping, oc_phonetrack_proxims, oc_cookbook_keywords, oc_comments, oc_preview_generation, oc_phonetrack_pubshares. Weitere Informationen findest du in der Dokumentation .

Does somebody have a solution for me?

Thanks in advance

[buzzzz]

@buzzzz

ROW_FORMAT=Dynamic

Sorry, I found this.

Upgrade to Nextcloud Hub 10 (31.0.0) Incorrect row format found in your database

I have the Linuxserver Nextcloud and MariaDB docker containers and today Nextcloud updated to Nextcloud Hub 10 (31.0.0). I am getting error messages: 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: (followed by a long list of files like oc_activity, oc_accounts_data, oc_activity_mq, oc_addressbookchanges and so on.) What do I need to do?

It was helping me

#!/bin/bash

# Prompt for database credentials
read -p "Enter Database Name: " DB_NAME
read -p "Enter Username: " DB_USER
read -s -p "Enter Password: " DB_PASS
echo

# Generate ALTER TABLE statements and execute them
mysql -u "$DB_USER" -p"$DB_PASS" -e "
SELECT CONCAT('ALTER TABLE \`', TABLE_NAME, '\` ROW_FORMAT=DYNAMIC;') 
FROM INFORMATION_SCHEMA.TABLES 
WHERE TABLE_SCHEMA = '$DB_NAME' 
AND ENGINE = 'InnoDB';
" -B -N | while read -r sql; do
    mysql -u "$DB_USER" -p"$DB_PASS" -e "$sql" "$DB_NAME"
done