Page 1 of 1

very long pages being cut off

Posted: Sat Apr 14, 2007 8:28 am
by miss_d_bus
I am having some problems with putting very long pages into the CMS. We are talking about maybe 70k or more in size.
They are that long because they are university lecture notes. I have grouped the notes by module taken and each section is broken down by weeks and using anchors for navigation.
Is there a known problem with long pages or is there a setting somewhere that I can change so the bottom of the text is not chopped off?

Thanks,
Catherine

Re: very long pages being cut off

Posted: Sat Apr 14, 2007 12:41 pm
by moorezilla
Make sure that the relational database field has a type long enough to handle the large pages. I can't imagine that it doesn't, but it's worth a check.

Make sure that your php has enough memory and time to execute.

Those are the only limitations I can think of off the top of my head. If you give more details about your hosting situation, people will be able to give you more specific help.

Re: very long pages being cut off

Posted: Sat Apr 14, 2007 3:04 pm
by miss_d_bus
Thanks for pointing me in the right direction - i was ready to blame my hosting solution.

The contents is stored in the table cms_content_props under the content field.
Its set as a TEXT field. MySQL TEXT fields have a limit of 65,000 bytes so that would explain why it chops the end off the text.
I changed it to MEDIUMTEXT and now it works.

Thanks!

Catherine

Re: very long pages being cut off

Posted: Thu Jul 19, 2007 4:31 pm
by Traill
Can someone explain in detail how to correct this again - I didn't understand the above post!
I'd be really grateful, thanks a million!

Re: very long pages being cut off

Posted: Thu Jul 19, 2007 4:42 pm
by tsw
mysq -u -p

ALTER TABLE _content_props CHANGE content MEDIUMTEXT;

change those things to reflect your settings.

Re: very long pages being cut off

Posted: Thu Jul 19, 2007 8:36 pm
by Pierre M.
Hello,

this fixes Catherine's 64k limit, but is it a solution ?
-she still may be hurt by a hosting PHP time/memory limit.
-it may brake CMSms upgrades (at least for Catherine).

Is this TEXT to MEDIUMTEXT going mainstream (feeded into SVN) ?
Shouldn't users make pages <50k ? (tokenizing thesis in 50k linked chunks)

Just my 0,02ยค your opinions are welcome of course.

Pierre M.

Re: very long pages being cut off

Posted: Thu Jul 19, 2007 8:39 pm
by calguy1000
I think 65,000 characters is a tad too small.... however you bring up valid points.

and we should make sure that this fix makes it into the 1.1 svn stream

However if pasting large files you could still be subject to timeouts, and theres very little we can do about that.