The submission could not be updated

[harmony]

I'm trying to edit a form submission in the form tools admin area. The form has 18 fields that I've set as (MEDIUMTEXT) fields.

I can enter large amounts of text on the first 9 of these large fields. On the 10th field, I can only enter 738 characters. It seems I can only enter less characters on each successive large field (I haven't checked how many characters exactly). If I try to submit the same amount of characters as the first 9 I get this error:

The submission could not be updated.

Any idea what's going on?

[Ben]

Neat...!

Well, first off, there's no limitation in the code on the amount of data that can be submitted and processed by Form Tools, so most likely this is a server restriction.

I'd suggest looking at your phpinfo file (to create one, just upload a .php file to your server with this content:

PHP Code:

<?php phpinfo(); ?>

Then look over that file for post_max_size or anything else that looks likely. If you can find something that looks restrictive, fire off an email to your hosting provider to ask if they can increase it.

How much data are you posting, by the way? I think the default max size is like 2MB of info, which is plenty for most cases.

- Ben

[harmony]

Hi Ben,

It turns out that there's a general 8000k limit per row of data in MySQL (according to mysql). Is that possible?

My form had 18 large fields that were getting completely filled. The form size was large!

So I've had to break the form into pieces. Drat!

[Ben]

Interesting...! I didn't think of that.

Wow, that's a lot of data per submission. Sorry you had to split up the form, though... what a nuisance!

- Ben