Nextcloud 31: Hub 10 Released - integrations champion

I couldn’t reproduce on Rocky or Debian but it seems to be a Nextcloud update issue and the solution is a script, see Upgrade to Nextcloud Hub 10 (31.0.0) Incorrect row format found in your database - #13 by YannicK_SupRavII - ℹ️ Support - Nextcloud community

I adapted the script and tested it without affected tables so a backup is always a good idea before doing manual db changes.

Enter nextcloud-db container:

runagent -m nextcloud1 podman exec -ti nextcloud-db sh

Set the rows to dynamic. If there’s no output it should have worked.

mysql -u nextcloud -pnextcloud nextcloud -Bse "
SELECT CONCAT('ALTER TABLE \`', TABLE_NAME, '\` ROW_FORMAT=DYNAMIC;') 
FROM INFORMATION_SCHEMA.TABLES 
WHERE TABLE_SCHEMA = 'nextcloud' 
AND ENGINE = 'InnoDB'
" | mysql -u nextcloud -pnextcloud nextcloud

Exit container:

exit