Incorrect row format found in your database after update to 31.0.2

ℹ️ Support
,
1

Hi,

I’ve ran into this issue after upgrading to 31.0.2:

“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”

and is followed by a long list of tables:

“oc_collres_collections, oc_mail_local_messages, oc_dav_cal_proxy, oc_richdocuments_assets, oc_users, oc_calendar_appt_configs, oc_share_external, oc_login_flow_v2, oc_preferences, …”

It seems almost everyone here is running nextcloud with docker.

I don’t use docker, I have a machine with linux 22.04.5, apache 2.4.52 and mariaDB 10.6.21.
I’m using webmin 2.303 for a comfortable administration.

How exactly could I solve this issue to update that database? (in terminal?) What commands do I need to use? Could someone drive me step-by-step as I’m a linux/mariadb very beginner?

Thank you,

1 Like
2

try this thread Upgrade to Nextcloud Hub 10 (31.0.0) Incorrect row format found in your database - #10 by wivaku

there’s a script marked as the solution that you might find useful. be sure to backup your machine or database at least before running it.

3

Thank you, I know that thread and I’ve also already posted there.

There is no explanation how could I use that script in my situation, because it’s only explained for docker installations, or, maybe, I did not understand how to use that script.

A step-by-step would be very useful for me.

Thank you,

4

you backup everything, you then save the script into a .sh file, you mark that file as executable (chmod +x scriptfilename) then you run it with .\ in front. i ran it on my nextcloud instance (ubuntu 2404, mariadb)