IntellectualSites / IntellectualSites/PlotSquared

Plot Greeting with <rainbow> ecceeds limit of value field in database

Open
#3,237 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Bug
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

https://pastebin.com/5ZGjCVLa

Error log (if applicable)

https://pastebin.com/5ZGjCVLa

Plot Debugpaste

not needed

PlotSquared Version

PlotSquared-Bukkit-6.0.10-SNAPSHOT

Checklist
Anything else?

No response

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.