Error if article text is longer than 4000 words - News Module

For questions and problems with the CMS core. This board is NOT for any 3rd party modules, addons, PHP scripts or anything NOT distributed with the CMS made simple package itself.
Post Reply
Sendlingur
Forum Members
Forum Members
Posts: 62
Joined: Wed Aug 08, 2018 4:59 pm

Error if article text is longer than 4000 words - News Module

Post by Sendlingur »

I am trying to post an article that contains more than 4000 words.
I always get this error when I post it(see below).
why do I get this error? Is there a text limit? I havn't set any text limit.

DEBUG: SQL = INSERT INTO cms_module_news ....................Data too long for column 'news_data' at row 1

Thank you
User avatar
rotezecke
Power Poster
Power Poster
Posts: 411
Joined: Fri Apr 18, 2008 9:34 pm
Location: Nimbin, Australia

Re: Error if article text is longer than 4000 words - News Module

Post by rotezecke »

I think the column type is "text" which has a maximum length of 65,535 bytes.
https://stackoverflow.com/questions/676 ... -type-text
if you are familiar with SQL, you could modify the column. i would expect that future module updates will not change this back. it is however a deviation from the module's design; so I am not sure if I am breaching forum rules for even thinking out loud...
Edit: here's a little tool i just found:
https://mothereff.in/byte-counter
Post Reply

Return to “CMSMS Core”