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.
Change TABLE row format from COMPACT to DYNAMIC - Tutorial
in Classic self-hosted technical help
Posted
While doing the upgrade on a client's forums from IPS 4.4 to 4.5, I encountered following MySQL error:
For the benefit to all, here is an easy fix to alter the table row format:
Here is a quick video tutorial: