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

Open
#4,326 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Requires Testing
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
  1. Enable database-purger
  2. Run /p setup to create a partial plot area with a minimum plot ID that has negative values (for example: -1;-1)
  3. Restart the server.
  4. Claim one of the new plots. It should show in the database.
  5. 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
Anything else?

English is not my native language, I hope you understand my bug report :) thank you for reading

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 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.