ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Is there a limit to how much text you can place in a text area custom field?

January 15, 2010 3:49pm

Subscribe [3]
  • #1 / Jan 15, 2010 3:49pm

    Brad Haynes

    105 posts

    This is from the client:

    “I was attempting to insert the body from the attached html file into a new page through the EE CMS, but had issues rendering all of the content. The body of the attached page comprises roughly 18k lines of markup as it contains significant amounts of data for College Course Equivalencies. When I save the page in the CMS and view it, the table of data abruptly cuts off between the listing for Education courses (when I view source, I also see that it cuts off in the middle of a closing tr tag displaying “</tr” with no ending bracket.) and the footer breaks as well. It displays above the content instead of below it. After measuring the point where it breaks, it seems that the page is cutting off at around 4k lines of code.

    Is there a limit to the amount of code that we can put onto a new page through the Expression Engine? If so, is there a way to increase this limit?”

    Anyone deal with this before? Is there a workaround?

    Any help is greatly appreciated.

    Best.
    Brad

  • #2 / Jan 15, 2010 5:43pm

    Ingmar

    29245 posts

    Is there a limit to the amount of code that we can put onto a new page through the Expression Engine?

    Well, there is a built-in limit for all custom fields: They are defined as TEXT, so that means no more than 2^16-1 characters.

    If so, is there a way to increase this limit?

    If you need more, you must manually change the fieldtype to MEDIUMTEXT, which gives you 2^24-1 chars to work with. You can do this in phpMyAdmin, or by running a query like

    ALTER TABLE exp_weblog_data MODIFY field_id_10 MEDIUMTEXT

    Just make sure to specify the right field_id_ , and do keep a db backup just in case 😉

  • #3 / Jan 17, 2010 5:33pm

    Brad Haynes

    105 posts

    Thanks Ingmar!

  • #4 / Jan 18, 2010 3:25am

    John Henry Donovan

    12339 posts

    Glad Ingmar was able to help. Feel free to start a new thread if you have any more questions.

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases