Invision Community 4: SEO, prepare for v5 and dormant account notifications By Matt Monday at 02:04 PM
Aetherdan Posted January 22, 2018 Posted January 22, 2018 Would there be any serious repercussions from changing the post field type from mediumtext to text in the database?
bfarber Posted January 22, 2018 Posted January 22, 2018 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.
Aetherdan Posted January 22, 2018 Author Posted January 22, 2018 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.
bfarber Posted January 23, 2018 Posted January 23, 2018 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).
Aetherdan Posted January 24, 2018 Author Posted January 24, 2018 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.
Recommended Posts
Archived
This topic is now archived and is closed to further replies.