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
Error if article text is longer than 4000 words - News Module
-
- Forum Members
- Posts: 62
- Joined: Wed Aug 08, 2018 4:59 pm
Re: Error if article text is longer than 4000 words - News Module
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
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