Row Format Update Fails

ℹ️ Support
1
Support intro

Sorry to hear you’re facing problems. :slightly_frowning_face:

The community help forum (help.nextcloud.com) is for home and non-enterprise users. Support is provided by other community members on a best effort / “as available” basis. All of those responding are volunteering their time to help you.

If you’re using Nextcloud in a business/critical setting, paid and SLA-based support services can be accessed via portal.nextcloud.com where Nextcloud engineers can help ensure your business keeps running smoothly.

Getting help

In order to help you as efficiently (and quickly!) as possible, please fill in as much of the below requested information as you can.

Before clicking submit: Please check if your query is already addressed via the following resources:

(Utilizing these existing resources is typically faster. It also helps reduce the load on our generous volunteers while elevating the signal to noise ratio of the forums otherwise arising from the same queries being posted repeatedly).

Greetings, folks. Been a longtime OC→NC user. I’ve been incrementally updating to v32 and ran into the SQL Row Format (Dynamic) error after kicking the can down the road for a while for fear of blowing myself up. I’ve tried multiple times to use the advice in this forum but to no avail, likely because I don’t have SQL or ‘ix chops so I’m in need of a ‘for dummies’ approach.

I’m running on a shared server (Siteground) so I have somewhat limited access since the server is not fully in my control, but attempted various commands (such as below) via phpMyAdmin with no luck. At least a few times, it seems to have applied but the error in the admin panel continues to show. Hoping one of you folks can lend a hand.

Thanks in advance for your help!

SELECT CONCAT(‘ALTER TABLE `’, TABLE_NAME, ‘` ROW_FORMAT=DYNAMIC;’)
FROM INFORMATION_SCHEMA.TABLES
WHERE TABLE_SCHEMA = ‘dbgocngebj2ngp’
AND ENGINE = ‘InnoDB’
AND ROW_FORMAT != ‘DYNAMIC’;

2

The main recent thread on the topic was this one:.

When attempting post the output received.

1 Like
3

Thanks for the help. I did see and follow that thread with no success, hence my new post.

Turns out I finally got it done, but not without a lot of hoop-jumping. For those of you who are late to making the change and need help, here’s what I did:

  • Copy the list of tables reported in the admin cp and paste it into notepad
  • Manually add a carriage return after each table name to separate each to its own line
  • Copy & past that result into Excel
  • Use Find & Replace to strip the comma and space at the end of each table name
    • NOTE: Your tables may be different than mine, do not use my list as a reference, copy and past your own per the warning in the admin control panel!
  • Paste the ALTER TABLE statement in each cell before each table name
  • Paste the ROW_FORMAT=DYNAMIC; statement in one cell after each table name
  • Use the CONCAT command to ‘stitch them together adding a space between each value
    • In my case it was =CONCAT(A1," “,B1,” ",C1)
  • Copy and paste the results into the SQL command window in phpMyAdmin

I hope this helps others who are having the same issue but unsure about how to fix it.

image
image1327×894 105 KB