Hi
I am using CB 2.0.10
I am wondering, I get this error, 500 from the server.
I am running a sql command
$query
->select($inputnames)
->from('#__comprofiler')
->where('user_id='.$user->id);
Error
1118
Row size too large (> 8126). Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED may help. In current row format, BLOB prefix of 768 bytes is stored inline. SQL=UPDATE `_comprofiler` SET cb_s4p8q5="" WHERE user_id=672
I have alot of fields in the table _comprofiler.
233 fields when i use phpMyAdmin.
All the fields were created in community builder.
I believe my problem is I have to many columns/fields in that table.
Am i right?
I have tried all the options in tools, all fields are green and there is no fix button, because I believe all the fields are text.
I have put the fields into different tabs but does move those fields into a new table.
What do you suggest?