[Resolved] News System

fean0r

I've used longblob to store information from a textarea on a forum

but for some reason if I make a big'ish post it wont save the information, whats the largest text storage with mysql?

Thanks

stolzyboy

how big'ish are you talking, longblob can hold

roughly 4,294,967,296 bytes

fean0r

http://forums.actiongames.co.uk/viewtopic.php?t=4143

thats the post I wanted on my site but everytime i click submit to my save to database page it said page unavialable but when i reduced the size it work!?

Hope thats links ok if now let me know and I'll remove it

stolzyboy

do you have the field limited at all, can we see a screeny of your table

fean0r

My textarea:

echo "<form action='ad_newsed.php' method='POST'>";
echo "Title:<BR><input type='text' $formc name='title' size='80'><BR><BR>";
echo "News:<BR><TEXTAREA COLS='114' ROWS='16' WRAP='hard' $formc NAME='post'></TEXTAREA><BR><BR>";
echo "<input type='submit' value='Add News'>";
echo " <a href='admin.php'>Back to Admin</a>";

My record to table:

$sql = "INSERT INTO " . "news" . " VALUES('','$user', '$date', '$sdate', '" . addslashes($POST['title']) . "', '" . addslashes($POST['post']) . "')";

Pic of mysql:

stolzyboy

hmmm, can't really see what the problem may be, have you tried changing it to just text, or longtext

fean0r

yes tried longtext no luck there either, I'll keep trying I'll let you know if I get sorted..

fean0r

this is doing my nut!!

When I post the news I just get

The page cannot be displayed

🙁

anyone got any other ideas why this is happening?

stolzyboy

can you give us a url, so we can see it live

fean0r

its an admin function and the site is live right now I would be willing to pm you a test account if you like?

stolzyboy

fean0r

try making a big post it wont work 🙁

stolzyboy

i posted the same text from the link on the other site you gave me and it worked fine, i went to the main link and there it was

testing-stolzyboy

blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah, blah

fean0r

wtf thats weird maybe a setting on my IE ?

fean0r

or something todo with my router cause my other pc cant post it either...

stolzyboy

i'm not sure, have you tried it with other browsers, i am using IE 6 SP1

fean0r

http://www.annoyances.org/exec/show/article04-107

all sorted now it was the mtu settings!

Cheers for the help