Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted January 22, 20187 yr Would there be any serious repercussions from changing the post field type from mediumtext to text in the database?
January 22, 20187 yr Why would you want to do that? Yes, the big immediate downside is that instead of storing up to 16MB worth of textual data you will now only be able to store up to 65535 characters. Someone submitting a very large heavily formatted post will potentially see an SQL error when submitting their post because the post is too large to store in the database.
January 22, 20187 yr Author I have someone being malicious and posting extremely long posts with asian or arabic characters (literally thousands and thousands over and over.) Which seems to crash the website as it takes a long time to load. My goal with this question is to try and limit the length of posts, so that they cant try and crash the database/forum.
January 23, 20187 yr I believe it would be more prudent to find a way to block the person who is being malicious (banning their account, or if necessary blocking them at the server level).
January 24, 20186 yr Author 16 hours ago, bfarber said: I believe it would be more prudent to find a way to block the person who is being malicious (banning their account, or if necessary blocking them at the server level). They constantly use new vpn's. I'm just gonna have to take the risk at this point.
Archived
This topic is now archived and is closed to further replies.