Problem Inserting into SQL Database

[TWTCommish]

Hi,

I've got a simple HTML form that submits basic articles into an SQL database - it works fine, except when I enter one article inparticular. It contains a few weird characters in it - however even removing them does not work.

I find it can add data into the SQL database, but once it reaches a paragraph or two, it doesn't work anymore. It really isn't making any sense to me.

Anyone have any ideas on what might be wrong?

[arpith]

What is the *exact* SQL error that you receive?

Maybe you're not escaping some of the chars like " or ? or ' etc.. ??

Arpith

[TWTCommish]

My mistake - I'm not getting any error at all. Instead, the page just sits there, taking forever to load. I've tried it on multiple computers. I wait awhile, hit stop, and once I remove a certain amount of text, it submits within a second or two.

One of the things I wonder about is the fact that part of the form has me uploading an image - however this hasn't been a problem in the past, and I've tried this without uploading an image at all.

It seems if I try to add more than, say, 2 paragraphs of the article, it just doesn't process - it just hangs there. Could there be some odd command in my script that's causing this? I figured I must've screwed up somewhere, but I don't see how this could be so if less text in the textarea solves the problem.

[Elledan]

This problem only occurs with one article? You might want to give a link to it (save it as .txt) and if you could give a link (or post it here) to the script (this one too in .txt format) we could help you much faster

[TWTCommish]

Well then, of course, people would get to read the article before I release it. Not a big deal or anything. The weirdest thing is that If I take away SOME text, it works - but add a bit more, and it doesn't.

I'm gonna try it again - hopefully SQL was just acting up.

[jrap]

What column type are you using? Maybe the article is too large for the column type you are using?

[TWTCommish]

Plain old TEXT - no way it's too large, I'm sure I've used much larger.

[jrap]

Try using LONGTEXT, that may help?

[Elledan]

I'm certain that a normal TEXT column can contain much more than just two lines of text.

It must be something different, I think.

[freddydoesphp]

You are using MySQL right?
A TEXT field in MySQL can hold 65535 characters easily can fit a whole page of text.

From The MySQL manual:
TEXT
A BLOB or TEXT column with a maximum length of 65535 (2^16 - 1) characters. See section 7.7.1 Silent Column Specification Changes.

[TWTCommish]

Yup, MySQL - I havn't the faintest idea of what might be wrong. I'm gonna try it on another computer or two and see if that works. I'm totally stumped for the most part, though.

[freddydoesphp]

Have you tried

htmlentities()

or

htmlspecialchars()

On your data before inserting it.

[TWTCommish]

No, I have not - I honestly am thinking now that the script is just fine, because I've having problems submitting forms with large amounts of text with other scripts as well - such as vBulletin, for example.

This is likely a problem with my computer or web browser - I tried another computer, but it *IS* networked to this one.

I'll try one seperate from the others and using a different connection tomorrow and see what happens - I think that will fix it.

[arpith]

I had no problems submitting extremely large amounts of data into the 'blob' type column. Of course, I tested this offline in 'localhost' so the possibility of a server timeout does not come in.

Maybe its taking too long to submit the text?

Arpith