Warning about ROW_FORMAT=Dynamic with long list of entries

[Simon2018]

Indeed thank you. There is a script here to overcome the issue:

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…

It happends only for long-term nextcloud user as it seems.