Forums

I have a rather large form that no longer opens. All the other smaller forms open. I've set my php timeout to 10 minutes, but it doesn't even give a time-out warning like some other forms of mine have. It simply stops trying. I copied the text in the Views database entry into that of a blank form and same thing. There are 106511 characters no counting spaces - 107529 with spaces. I am not sure what longtext limits are in MySQL off the top of my head. But I was working on the form - the email template - saving just fine, but I refreshed the form and it no longer opens. Is there anything I can do in the database to fix this? A lot of time was spent putting this form together and people are waiting on me.

Check your javascript console for errors when it's trying to open.

Hi ipates,
​
"LONGTEXT - column with a maximum length of 4,294,967,295 or 4GB (232 - 1) characters. The effective maximum length is less if the value contains multi-byte characters. The effective maximum length of LONGTEXT columns also depends on the configured maximum packet size in the client/server protocol and available memory. Each LONGTEXT value is stored using a four-byte length prefix that indicates the number of bytes in the value."
​
I doubt that is the problem :-(
​
Bob

It never gets that far - Javascript console is useless in this case. Just a blank page. Something is choking it on the PHP-MySQL side.

Thanks, Bob. I did notice that on the Sections entry, there was a notice from PHPMyadmin: " Because of its length, this column might not be editable" and wondered if similar was happening for the Views entry. It's odd - the Sections only has 23k in it, and is supposed to handle nearly three times that much. So I'm wondering if there's a difference between the actual limits of MySQL, and perhaps applied/implied limits thanks to PHP settings or something.

Hi Ipates,
​
Can you still take a form backup? If so please post a copy here (or PM me with a download link).
​
Bob

PM'd. Thanks.