Jump to content

Change TABLE row format from COMPACT to DYNAMIC - Tutorial

Recommended Posts

While doing the upgrade on a client's forums from IPS 4.4 to 4.5, I encountered following MySQL error:


Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs

For the benefit to all, here is an easy fix to alter the table row format:


1. Login to your MySQL/phpMyAdmin.
2. Select your forums database.
3. Open the SQL tab and execute the following query:


Note: Edit/change the core_groups table to your desired table.

Here is a quick video tutorial:


Link to comment
Share on other sites

Thats is what I have got during upgrade yesterday and thanks to a previous post (below) which saved the day. We can overcome upgrade error just like you have shown in your video but there may be more tables ( I had mode than 150 in my case) which causes a warning each time you run Support Tool.

Since I did not want to put a script on the server which was suggested on the other post, I had to do them in batches as you have shown in video which of course took a while.

By the way you can get a list of the tables if you have SSH access to MYSQL



> SHOW TABLE STATUS  WHERE Row_format="Compact";



Link to comment
Share on other sites

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...