[SOLVED] Problem: Row size too large

Hello Kyle,

I have a similar problem as mentioned in this thread . I have read the thread carefully and compared all database settings with what you advise. All settings are similar.
There are currently 248 comprofiler fields in the database, mainly text. That should be possible according to the content of the thread i guess.
Can I solve this? I'm going to end up with about 350 comprofiler fields.
For example, is it possible to split the columns in the comprofiler table into two tables, ___comprofiler and ___comprofiler1. E.g. by manually editing the reference to the column in comprofiler_fields?

Kind regards,
Peter

Checked the average row size in mysql workbench this morning. The comprofiler table was nowhere near the 8k (about half the size).
Would increasing the innodb page size to 32k, or even 64k, be a solution for this?

Hey, try to set

max_input_vars = 1000000000000
max_input_nesting_level = 120

in php settings. This helped us a lot with many field problems.

We're using about 330 fields without any problems.

Regards.

Tobias

Tobias,

Unfortunately no succes here. Changed the settings in php.ini but adding another column results in error:

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.

Thanks for the suggestion though.

Regards,
Peter

There are currently 248 comprofiler fields in the database, mainly text. That should be possible according to the content of the thread i guess.
Can I solve this? I'm going to end up with about 350 comprofiler fields.

You should be able to hit around 1000 fields before hitting the Innodb limit if they're all just text fields. Are you sure CBs table has its storage engine set to Innodb? You can check this within phpmyadmin after selecting _comprofiler and clicking the Operations tab. Beyond that you may have a configuration problem for Innodb. Specifically innodb_large_prefix needs to be configured. See the below for configuration recommendations.

www.joomlapolis.com/forum/153-professional-member-support/237990-database-error-message-1118-row-size-too-large?start=12#299701

For example, is it possible to split the columns in the comprofiler table into two tables, ___comprofiler and ___comprofiler1. E.g. by manually editing the reference to the column in comprofiler_fields?

No

Storage engine is set to Innodb. I double checked. The configuration of Innodb is done accoring to the thread you mentioned.
Most of the fields are text field, some (10 or so) mediumtext and a few system fields (CB system fields). I also use some field groups (great!) b.t.w..