FRIHOSTFORUMSSEARCHFAQTOSBLOGSCOMPETITIONS
You are invited to Log in or Register a free Frihost Account!


Cannot add txt to "longtext" column





Shike
I keep getting a permission error when I try to add a lot of text to a "longtext" box in my database table.

(EDIT)
I am trying to put a lengthy description into this field. I also doubled up ont the longtext fields so I could split up the text and that didn't work either.
(/edit)
AftershockVibe
Firstly, check that your database user has write access to that table.

Secondly, try writing something small and see if that works (a sentence).

If for some bizarre reason you are still having trouble, try to define your field as as Char(XX) where XX is your length. MySQL should automatically covert this for you into the required length text field.
johanfh
That's strange. I looked in my manual and it told me the only restriction could be the message buffer on either the server or the client.
The size of the message buffer is defined by the max_allowed_packet variable. At http://dev.mysql.com/doc/refman/5.0/en/blob.html you can read more about it (at the end of the article).

JohanFH
DanielXP
Try it as text. it done the same to me when i used longtext
Shike
It seems as though it is only doing it with the particular row. Not even the whole table.

I think I'll try deleting the row and then re entering it.

BTW I'm also adding html into the text assuming that it is necessary for the display (say for paragraphs etc) once the record is pulled from the db table.
Related topics
Windows Tips&tricks!
Selling Sigs
Header("Location: PROBLEM");
My Signatures
The godfather part I, II, III
science vs. religion
phpBB nasýl kurulur yardým lütfen
5+2=1
Capturing user's data
Autoresponder unlimited(New Problem)!!!!
Help! Windows Media Player Problems
cannot add data to mysql from PHP form
cannot add addon domain
Can I Add a 2nd Free Website on Frihost?
Reply to topic    Frihost Forum Index -> Scripting -> Php and MySQL

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.