萌萌の初音
萌萌の初音
发布于 2025-07-03 / 19 阅读
0

升级到nextcloud hub 10(31.0.x)提示数据库不正确的行格式问题

问题描述:

升级nextcloud 到31.0.x,管理设置里提示“数据库中找到了不正确的行格式”,如图:

解决方案:

不管的话没什么问题,强迫症可以通过以下脚本解决:

#!/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 all ALTER TABLE statements in one query
mysql -u "$DB_USER" -p"$DB_PASS" "$DB_NAME" -Bse "
SELECT CONCAT('ALTER TABLE \`', TABLE_NAME, '\` ROW_FORMAT=DYNAMIC;') 
FROM INFORMATION_SCHEMA.TABLES 
WHERE TABLE_SCHEMA = '$DB_NAME' 
AND ENGINE = 'InnoDB'
" | mysql -u "$DB_USER" -p"$DB_PASS" "$DB_NAME"

该解决方案转自:

https://help.nextcloud.com/t/upgrade-to-nextcloud-hub-10-31-0-0-incorrect-row-format-found-in-your-database/218366/13