[Solved] Too much data in a content page?

[twwitt]

Hi --

I read a previous thread when this same problem was brought up previously --( http://forum.cmsmadesimple.org/index.ph ... 744.0.html)

I, too, pasted in a huge html table into a content page, but it gets cut off with the bulk of the last part of the table not showing up. Seems like there is a limit to the amount of data one can have in a content page.


I don't understand the answer that was given below or where to make this change:

[There is a MYSQL type field limit.
Table content_props have a content field:
TEXT type (64K character limit)
Try to change to MEDIUMTEXT type]


Can anyone explain in a more elementary way how to make this change?


Thanks,
-- Twwitt

[nhaack]

Hey twwitt,

per default, the fields in the Database tables that store the content can only carry a maximum of 64 kilobyte (I think thats 16.000 characters). Which is sufficient for most cases. If, for example, you have a lot of html or css mark-up in your content, it blows up the character count and even though you only see lesser characters, you reached the limit.

The answer indicates, that you should change the data fields type in the database. Check the mysql manual on how to do it, look for the table prefix_content_props. As a result, you will be able to store more text in each page.

Best
Nils

[Nullig]

You should read this in the wiki:

http://wiki.cmsmadesimple.org/index.php ... ent_Length

Nullig

[twwitt]

Thanks to you both. I've got it.