[SOLVED] Problem: Row size too large

What MySQL version are you using? Sorry, I don't have much to suggest beyond what's already in the linked thread. I'm not database expert or server admin and you may want to consider contacting your host regarding your issue as it sounds like there's still a configuration problem (likely wrong file format). Recommend reading though the below for possible solutions.

dba.stackexchange.com/questions/6598/innodb-create-table-error-row-size-too-large

If configured correctly using the following then text columns should be small 20 byte pointers and easily be able to have hundreds of them without issue.

phpmyadmin settings:
Storage Engine: InnoDB
ROW_FORMAT: DYNAMIC

database settings:
innodb_large_prefix = 1
innodb_file_per_table = 1
innodb_file_format = Barracuda

Eventually we'll be completely redoing how fields are stored. Ideally we'll use a separate table that is just joined together with _comprofiler and in theory would allow for unlimited fields, but that won't be until at least CB 3.0.

I'm using MariaDB 10.2.17, with settings as mentioned. I did ask my host to change the innodb_page_size to 64k. Maybe that helps.

Really looking forward to CB3.0 now

Thanks,
Peter

MariaDB is not a supported database engine. So there's nothing more I can advise. It is not officially supported by Joomla and thus not supported by CB. We do not test on MariaDB either so you may or may not run into other issues.

Nick,

this morning we replaced mariadb with mysql. I have been able to add a few fields. So it seems to work now with InnoDB_page_size still at 16.
Based on a tip from Tobius I have made the following changes in php.ini before (i didn't change them back):
max_input_nesting_level = 120
max_input_vars = 5000
memory_limit = 128M
Thanks for your patience.

Regards,
Peter

Hello all,

Replacing mariadb with mysql alone was not enough to do what we want. We now had more than 300 fields of which about 30 textarea fields. Initially it was possible to have these fields in the database but as soon as text was entered we received the 1118 error message again.
Reducing the number of textarea fields to six was not a solution. Even then we got the message when entering text in these fields.

A new mysql instance has now been installed with the following innodb parameters:
- innodb_page_size = 64k
- innodb_log_buffer_size = 32M
- innodb_buffer_pool_size = 512M

After that I entered as much as an A4 lorum ipsum text in all six textarea fields, without experiencing any problems until now.
Of course we will continue testing because it concerns a lot of sensitive information. That MUST be good. Hopefully we will not encounter any more problems because Community Builder is a very nice solution, also for this type of application.

Thanks for posting back your progress/solution for others reading to benefit from.