Personal tools
FAQ/Content Length
From CMSMS
This page in: English - Deutsch - Français - Svenska - Русский - Norsk - Polski - Nederlands - Español - Lietuvių
- Installation
- Upgrading
- Layout and Design
- General Help
- Errors with {} characters
- Who is that Smarty guy?
- How to add multiple content blocks
- How to add php code in a page
- How to find out username and password
- How to get HTTPS to work
- Support for non-standard ports
- Increasing the maximum length of your content
Increasing the maximum length of your content
MySQL TEXT fields have a limit of 64K. If you insert anything larger than that in to a normal TEXT field MySQL will silently truncate your data without telling you. MEDIUMTEXT will store 16MB and LONGTEXT can handle 4GB.
To change the maximum length of your content fields you need to use PhpMyAdmin, or some other database utility, to change the field type from TEXT to MEDIUMTEXT or LONGTEXT. In PhpMyAdmin, select your CMSMS database and click on the "cms_content_props" table (assuming a table prefix of cms_). Click on the edit icon next to the "content" field. Then, in the "Type" dropdown menu, select MEDIUMTEXT or LONGTEXT, depending on what you want, then click on the "Save" button.
This will update your field to the new type and allow you to enter more data into your pages.
NOTE: Longer pages will take longer to load, so keep this in mind.
This page in: English - Deutsch - Français - Svenska - Русский - Norsk - Polski - Nederlands - Español - Lietuvių
