MySQL hangs... over 100 characters

[jstrybis]

ok, i posted a similar message earlier in another forum, but we've narrowed the problem down a bit.

a little bit of prefix first:
we just recently moved our old webserver's hard drive to a new one, and then proceeded to install php and mysql on the new box. all of the same scripts that used to work fine, no longer work because it seems mysql will not submit a form or insert into the table if the data is more than 100 characters... it will insert up to 99, but 100 seems to be the limit.

i'm using the same my.ini, my.cnf that was on the other webserver, i believe and i've setup mysql a number of times on different machines with no problems like this.

is there something i'm missing? seems like a pretty easy error to fix.. some configuration error somewhere.. any ideas?

thanks,
jay

[[deleted]]

"it seems mysql will not submit a form "

Exactly what happens? exactly

Any error messages? what do the logfiles say?

[jstrybis]

well, there's no errors given to the browser, but when looking in the system's error logs, there are a lot of script timeouts (me trying to submit a form that adds info into a database)

although there is a new development now...
i can post fine using mozilla, but internet explorer gives everyone problems.. perhaps this is a better clue?

[[deleted]]

Well that does suggest that the problem is not at all database related, but has something to do with how your webserver deals with the incoming request... do you use POST or GET for the submit?

[jstrybis]

thanks for the reply..

i actually just realized that 😉

I can, indeed, submit large amounts of info using POST, but i believe forums mainly use GET (for obvious reasons) and that is causing the problem.

do you happen to know what to do about this? i'm not sure how to change how the server reacts to GET submissions.

Thanks again,
jay

[[deleted]]

GET has a size limit of 2kbyte usually, but it may be different per server.
This limit exists because GET uses the URL to send the data and an URL of more than 500 bytes is quite insane, let alone a URL of 2000 bytes 🙂

POST is meant for large amounts of data and you'll find that the size of a POST is almost limitless.

[jstrybis]

Hmm, well i guess the form really is POST, actually... The one that is most troubling is IkonBoard, but there are also phpbb's and invisionboard's on the same server that are also having troubles...

i'm really rather stumped as to why it would work in mozilla and netscape, but IE fails.

if you'd like to checkout somewhere that fails to work:
http://www.xgameservers.com/cgi-bin/ikonboard/ikonboard.cgi

i was going to update ikonboard to some other message board as well, but the install procedure hangs! 😕

I'm going crazy here hehe, but thanks for your help so far 🙂

[jstrybis]

well, i figured i may as well post the resolution.

It seems that it was actually the DRIVE that was causing problems.

sigh of relief it wasn't my fault!! 😃

anyhoo, thanks for trying to help vincente 🙂