Not sure. I will check it out.

Question now posted with my hosting provider and will await their reply before trying anything else.

Hi Eric,

My host provider have escalated the problem to their higher technical people who have tested the form with the same results that I have been getting.

They asked if there was an error log and I have downloaded it and sent it but I wondered if I attached it so that you could maybe look at it and see where there is anything wrong.

I had a quick look but its all beyond me but one thing I did notice was that it said that something was too long and "you have to change some columns to TEXT or BLOBs".

Does that mean anything to you?

Pete.

Try changing the filed names so they use an _ instead of a -

Unfortunately, I've already tried that one without success.

Hi Eric,

This seems to be the culprit :


`garden-length` varchar(255) NOT NULL DEFAULT '' is the issue. #1118 - Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs

Not sure how to correct it.

Pete

See if your host will alter your php ini file or you can do it.
Ask them about this
https://stackoverflow.com/a/25373052/1043630

Hi Eric,

Update. My hosting provider created a third table in the database and then tried the form with the same results.

After the test, they deleted the table.

As I am still awaiting a response to my support ticket, I didn't want to add anything to it i.e the error log as it would put me at the back of the support queue.

Pete

Great it will be awesome to hear more.

Hi Eric,

This is the latest response from my hosting provider:

Please note that your account is hosted on a shared server. So, I am afraid that we can not change the innodb_log_file_size.

I am still awaiting an update to my CoffeeCup support ticket, hoping that Scott can come up with answer asap.
It has to be something in the form that I can alter because having tested my other large forms, I get the same response in that they are submitted to me but they do not connect to the database.

I have even tried creating a second database but I still get the same response so this has been deleted.

Pete

It's probably the number of columns your form has.
https://dev.mysql.com/doc/refman/5.7/en … limit.html

Is there any way to trim down the number of questions tied to check boxes?
Another option is to break it into two forms.