Max length of a form field?

hobbitg

I am having problems with a field being cut off in an app i'm working on. It appears to me that there is some kind of limit on how large a field can be when posting data, but i find no mention of that anywhere, save for the "memory_limit" and "post_max_size" vars in the php.ini, both of which are set much higher than the size of the data being submitted. Also the database field it's being inserted into is a MEDIUMTEXT size, and the data gets nowhere near that limit before being cutoff.

So i'm trying to figure out if it's a problem with the browser, or with a strange setting in php. I'm running Firefox 2.0.0.2, connecting to php 5.1.6 running on apache 2.0.58 with mysql 5.0.26

Has anyone come across an issue like this, and have any solutions other than splitting it into multiple fields? Thanks for the help in advance!

laserlight

Is your form using method="post" or method="get"? I do not remember the details offhand, but passing by the query string (GET) does have a maximum length limit that you can conceivably break.

hobbitg

It's using POST, but it seems i've found the solution. It was an issue with the maximum length of a query to mysql. By default the maximum size of a query is 1MB, but by running

shell> mysql --max_allowed_packet=32M

on the mysql server, the problem seems to be fixed.

So if anyone is having a problem, check that out.

Thanks for the reply!

bradgrafelman

There's also the post_max_size PHP directive to think about as well.

Don't forget to mark this thread resolved.