Unable to save the whole content of a big field
News and General
We have a text field were we want to put quite big HTML content (955 lines). We were able to do it without problem a few weeks ago, but now it’s cutting the content, apparently always at the same point (around 65.000 characters).
EE let’s you copy all the content, but when you save the page, it cuts it.
We haven’t changed anything in our EE installation lately, but we made some changes to our PHP configuration for other reasons (so I guess it could be PHP related, but we are not sure and don’t know how to fix it).
We’ve tried “pasting into the field and selecting another field”, as suggested in https://expressionengine.com/forums/archive/topic/229708/problems-cutting-pasting-to-textarea-channel-fields, without luck. I haven’t found more articles regarding this problem.
We are using version 2.10.1 - Build Date: 20150501.
Any clues?
This isn’t so much an ExpressionEngine issue as it’s a database issue. You have hit the 64k character limit of the MySQL db TEXT field. You can increase the limit by going in to your DB and changing the content field from TEXT to MEDIUMTEXT. Make sure you back everything up first and be aware that this is not officially supported by EllisLab, but it shouldn’t cause any issues.
You could also create a second content field for when this happens and combine them within the template.
Beyond that it may be worth evaluating how you are managing your content. That seems like a large amount of content for one field. It can’t be better divided up? Additionally your mention HTML content. Your not including any HTML layout in your content are you? Just formatting? If so, any layout should be done from templates and only the actual content placed in the field(s).
Thanks Jeremy, we’ve changed to MEDIUMTEXT, but the problem persists. Content still gets cut at the same point. Any other ideas?
Yes, they were in my previous post. 😊