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.