Not sure. I will check it out.
Question now posted with my hosting provider and will await their reply before trying anything else.
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.
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 -
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.
This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
It's easy to overlook something you're not looking for.
This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
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
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
Ask them about this
https://stackoverflow.com/a/25373052/1043630
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.
This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
It's easy to overlook something you're not looking for.
This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
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
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.
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.
This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
It's easy to overlook something you're not looking for.
This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
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
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.
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.
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.
This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
It's easy to overlook something you're not looking for.
This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
Have something to add? We’d love to hear it!
You must have an account to participate. Please Sign In Here, then join the conversation.