[SOLVED] Row size too large when adding/deleting field...

Hi Kyle,
Just tried to delete a CB field and got this message: " 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"

First time I have ever seen this notification and it was on a site which is actually several factors smaller than my main one. Just checked though, I am also having this problem on my main site.

Any solutions to this?

Imho, first step is to check all the collations of your database (connection, tables, columns) and fix them to be consistent. They should all be utf8 or utf8mb4. We had recently such a case in another thread, and fixing them fixed the issue.

Worked I think. For those who have similar problems, it is very easy to change the collation. Simply go into phpmyadmin, click on Operations, scroll down and tick the box that says that it should change it for every table and every column. Takes only a couple of seconds.