I keep getting a permission error when I try to add a lot of text to a "longtext" box in my database table.
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.
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.
Try it as text. it done the same to me when i used longtext
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.