Change TABLE row format from COMPACT to DYNAMIC - Tutorial

[EmXaN]

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

Quote

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
/home/***/public_html/community/system/Application/Application.php::1667

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

Quote

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

ALTER TABLE core_groups ROW_FORMAT=DYNAMIC;

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

Here is a quick video tutorial:

 

[ABGenc]

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

>MYSQL

>USE <DBNAME> ;

> SHOW TABLE STATUS  WHERE Row_format="Compact";