Page 1 of 1

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

Posted: Wed Aug 25, 2021 10:23 am
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

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

Posted: Thu Aug 26, 2021 2:22 pm
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