Just providing an update on my Row Size too large issue. I am happy to report it is now solved.
This was my solution in case it assists anyone else...
I actually had several issues. I couldn't update any fields due to the row size too large issue. And I couldn't change any fields in the database from varchar to text because it gave me an invalid date error in several fields or invalid default value when I tried to change those.
My host wasn't much assistance so I think I probably did it the hard way but this worked....
In the end the solution was to view the comprofiler table in phpMyAdmin then,,,
1. Disable Strict mode via this SQL query: SET GLOBAL sql_mode = '';
2. Then manually change most of the varchar fields to text type (I used the Community Builder tools to 'check Community Builder User Fields Database with strict column types' which gave me a list of the varchars in the database to change).
3. After I had changed a number of them I tried saving a field in Community Builder. Didn't work at first. Tried changing some more. Had to change quite a few but eventually I was able to save a field without the row size too large error.
Then I was able to run the various CB tools which fixed all the remaining fields.
Everything seems to be working fine now.
