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:

[Spinning8429]

After upgrade to version 31.0.5 . I see 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:

command ./occ_convert_charset
report :
All tables already have the correct collation → nothing to do

database query report :

select table_name, row_format from information_schema.tables where table_schema = ‘nextcloud’ AND ROW_FORMAT <> ‘Dynamic’;
Empty set (0.001 sec)

[zomtec2311]

@Spinning8429

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

hello @Spinning8429,
maybe this could help you:

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

Hello, Your script changes the ROW_FORMAT of the InnoDB tables to DYNAMIC, but it has a problem: it generates the queries in a first mysql -e and then executes them separately in a loop, which can be problematic if the password is asked for each query. Here is an optimized version that executes everything in one command: #!/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 # Execute…