Storing very long text.

Rayman3_tk

Hi there!

I've build a forum that works fine, except when you try to post very long texts. For example: the forum isn't store new posts that are 10 or more pages long.

Why would anyone want to store such long texts you say? The truth is I don't know. All I know that my client wants it that way, so....

Could you tell me where the problem lies? Database, php, webserver?

Thanks!

bad76

Hi,
i think you have to check:

1 - max post length
2 - max time of execution
3 - kind of field in database

And you must use POST method and not GET, that is more limited.

Rayman3_tk

Hi!

I haven't defined a Max Post length, so that won't cause the problem.

The max execution time is 30 seconds, the same amount of time I've got at another server, where I'm able to post long text, in contradiction to this server.

The fieldtype is TEXT, as you would expect.

I'm using the post method.

Maybe someone could take a look at a phpinfo script on the server where it doesn't work:

http://www.dinky.net/Forum/test.php

and a server where it does work:

http://www.randtronics.org/Forum/test.php

Thanks!

bad76

Don't have you in php.ini this lines?

; Maximum size of POST data that PHP will accept.
post_max_size = 8M

[edit]
i'm right: work server has post_max_size=50M !!!

Rayman3_tk

Does M stand for megabite or megabit? 😉

Rayman3_tk

Guess it's megabite, but the other server has 8 M max posting size, so this can't be the problem. Any other suggestions?

Tnx! 🙂

bad76

Not other ideas...

Are there some particular char in text? like newline or other?

Try to urlencode before send (with javascript escape()...).

p.s:Any trouble is upload_max_filesize , is 2M vs 50M...

Sxooter

Ummm. What database is this?

Sxooter

A couple of differences:

The nonworking server is running 4.2.3 php, the working one is running 4.3.2, could be a bug in 4.2.3

the nonworking server has memory limit of 8 meg, and has a max upload file size of 2 meg. One of those might be getting in the way, especially if it's an attachment that's being uploaded, not just text in the editor.

It would also appear the non-working server is running an older flavor of MySQL (judging from the connect lib version, but this could just be what was included with PHP back then.)

It could be an issue with the version of MySQL you're running not accepting large text types.

Rayman3_tk

Thanks guys, I'll try to contact the webhost of my client, see what they have to say about this.

Luiz_Guilherme

Hi.

Probably you solved this question already, but just in case you didn't, the problem is usually the blob type you are using in MySQL.

I know you are probably not even near the mysql blob size limit, but i am researching about some php limits and I found lots of people solving problems like yours by changing from blob to longblob.

try it...