IntellectualSites / IntellectualSites/PlotSquared
Database-purger removes valid entries of a partial plot area when minimum plot ID X or Z is set to a negative value
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.20.4
Describe the bug
I have a survival world set up with a partial plot area. The minimum plot ID is -1;-4 and the maximum plot ID is 3;0. When a player claims a plot, it is stored in the MySQL database. However, the entries are removed when the server closes.
Entries are not removed if database-purger is disabled.
Entries are not removed if a partial plot area is set up with a minimum plot ID that only has X and Z values of 0 or higher.
I tested without other plugins (only FastAsyncWorldEdit and PlotSquared).
I tested with different databases, servers and configurations, each time getting the same results.
To Reproduce
- Enable database-purger
- Run /p setup to create a partial plot area with a minimum plot ID that has negative values (for example: -1;-1)
- Restart the server.
- Claim one of the new plots. It should show in the database.
- Close the server. The database entry is now removed.
Expected behaviour
Correct entries not being removed by database purger.
Screenshots / Videos
No response
Error log (if applicable)
No response
Plot Debugpaste
https://athion.net/ISPaster/paste/view/2afa1aa88c59427cbf65c49b0a00f4b5
PlotSquared Version
PlotSquared-7.3.3-Premium
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?
English is not my native language, I hope you understand my bug report :) thank you for reading
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 tracing the database-purger behavior for plots created by /p setup with negative minimum X or Z IDs, using the provided debugpaste and reproduction steps. Done means valid claimed-plot entries remain in the MySQL database after the server closes and are not removed by the purger.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- java, mysql
- Domain
- backend, database
- Issue type
- Bug
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 35/100