IntellectualSites / IntellectualSites/PlotSquared
Plot Greeting with <rainbow> ecceeds limit of value field in database
Nobody has claimed this yet.
- Dominant language
- Java
- Stars
- 653
- Forks
- 975
- Avg merge
- 2m
- Merged PRs (30d)
- 6
Description
Server Implementation
Paper
Server Version
1.17.1
Describe the bug
A Long Plot Greeting message with causes Data truncation: Data too long for column 'value'
Example:
So if i do /p flag set greeting Hello this is a Rainbow test
Its already over the limit because it generates 880 chars and tries to save it to db.
Only workaround it to set value field in db to text?
To Reproduce
/p flag set greeting Hello this is a Rainbow test
Expected behaviour
it should not make an error.
Fix would be to set the value field in plot flags to text (unlimited chars).
Screenshots / Videos
Error log (if applicable)
Plot Debugpaste
not needed
PlotSquared Version
PlotSquared-Bukkit-6.0.10-SNAPSHOT
Checklist
- I have included a Plot debugpaste.
- I am using the newest build from https://www.spigotmc.org/resources/77506/ and the issue still persists.
Anything else?
No response
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by reproducing /p flag set greeting <rainbow>Hello this is a Rainbow test on PlotSquared-Bukkit 6.0.10-SNAPSHOT, then trace where plot flags are persisted and inspect the database column named value. Done means the greeting saves without a data-truncation error and can be retrieved correctly from the database.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java
- Domain
- database
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 45/100