The content may not be greater than 65535 characters.

AhmedMohamedAbdElMajeed

When I try to post a big post content it's give me an error
"The content may not be greater than 65535 characters."

How to fix it

tankerkiller125

This is a limitation of the MySQL text field that we use to store content. While this could in theory be adjusted to a MEDIUMTEXT or LONGTEXT field it requires more store space (2KB overhead for TEXT, 3KB for Medium Text, 4KB for LONGTEXT) which adds up a lot with large numbers of post. Further it's incredibly rare for people to post that much data. For that reason it's not the default.

In theory an extension could add a migration to change the data field to a MEDIUMTEXT or LONGTEXT format, however dropping that migration to revert the changes could have very large negative impacts. Also changing that datatype via extension or manually could possible damage future Flarum upgrade migrations.

Note: UTF-8 characters can use 1 or more Bytes (Emoji often use 4) which further limits the amount of text allowed.

rob006

tankerkiller125 This is a limitation of the MySQL text field that we use to store content. While this could in theory be adjusted to a MEDIUMTEXT or LONGTEXT field it requires more store space (2KB overhead for TEXT, 3KB for Medium Text, 4KB for LONGTEXT) which adds up a lot with large numbers of post. Further it's incredibly rare for people to post that much data. For that reason it's not the default.

AFAIK this is 1 byte of overhead, not 1 kilobyte. So for one million posts you will get one extra megabyte of storage - it is negligible.

luceos

You can also manually modify the type of column in your own database. This does not impact how Flarum works (unless you make it something not text-like).

tankerkiller125

rob006 Ah yes, it would seem that I either read the information incorrectly or the place I found my information itself had it typed wrong.

fakruzaruret

I get his error but I calculated the text on https://www.charactercountonline.com/ and this website and other show less.

its output: CHARACTERS 58130 WORDS 6949 SENTENCES 1017 PARAGRAPHS 388 SPACES 10452

Does flarum calculate spaces too?

clarkwinkelmann

fakruzaruret yes, everything counts.

And if your text uses Unicode characters including emojis, one character might even be multiple bytes.