PlotSquared
PlotSquared copied to clipboard
Published
20 hours ago •
IntellectualSites
IntellectualSites
Database error when setting too many use flags.
Server Implementation
Paper
Server Version
1.20.1
Describe the bug
When setting many use materials in flags, the database error occurs.
To Reproduce
Just add as many materials in the Use flag.
Expected behaviour
MySQL value limited to varchar 512
Screenshots / Videos
No response
Error log (if applicable)
No response
Plot Debugpaste
https://paste.gg/p/anonymous/3f819349c91048e5813e3b1a53c95f88
PlotSquared Version
PlotSquared-7.0.0 RC3
Checklist
- [X] I have included a Plot debugpaste.
- [X] I am using the newest build from https://www.spigotmc.org/resources/77506/ and the issue still persists.
Anything else?
No response
https://github.com/IntellectualSites/PlotSquared/issues/2686
Seems like it was not fixed in v5 lol (or just implemented again). The create statement still assigns a VARCHAR(512) for the flag value
Well since we used 512 not 511 anyway, we've got almost an entire byte of space we're not using
