ROW_FORMAT in your screenshot should be set to DYNAMIC. If it's not available then InnoDB with may not be configured with innodb_large_prefix and you'll need to contact your host if unsure how to configure that.

The SiteGround is shared so they can't change the DB to innodb_large_prefix

That's quite a lot of fields. Each field with storage (e.g. Custom HTML fields do not count) adds a column to _comprofiler so depending on the type of the field you may hit limits. With a properly configured InnoDB we estimate the limit to be 1000 fields, but that is dependent on a lot of factors (fieldtypes, if the field even has storage, etc..).

Well there are about 64 checkbox fields and 64 text editor area fields and a handful of custom html fields. Are you saying this is not going to work or I need different hosting to make it work?

Will 100+ users all filling in some of the checkboxes and some of the text area fields have some bearing on this too? Or is it just simply the amount of fields not the amount of users filling them in?

This is quite concerning at this point in my setup.

Please let me know if I am going to be able to use this and if so what server settings I will need to find to make this work? SiteGround cannot change the InnoDB to dynamic. They changed it to Myisam and dynamic but I still get the error.

Surely there is some way to figure this out? I'll remain hopeful for now.

Thank you

I think we are going to get a VPS hosting account for our site. I don't want limitations that may cause problems.

Do you feel confident that a good VPS can accommodate this better and have 200 fields if the database is configured correctly? I found a good hosting company that will help set this how we need it.

Thank you for all your help with everything. It's been very good working with you and your extensions. One of the best I have used.

Hello, we are moving to a VPS that can be configured as we like. I'll try it like it comes by default and see if there are any problems but do you have any specific recommendations for the setup?

Should I tell them to start with this first?

InnoDB with innodb_large_prefix and ROW_FORMAT set to DYNAMIC

or go with this too?

innodb_file_per_table=1
innodb_file_format = Barracuda

I just purchased the new VPS and would like to send the support team the configuration request. I get 2 hour of free configuration time on the new account.

What can you tell me to tell them for the site, database, etc?

Much appreciated, as always!