Failed to execute database statement.

RockinChaos / ItemJoin

Get custom items on join.

https://www.craftationgaming.com/

GNU Lesser General Public License v3.0

137 stars 35 forks source link

Failed to execute database statement. #584

Closed sagaciousness2022 closed 2 months ago

sagaciousness2022 commented 4 months ago

Server Version

Paper 1.20.2

Resource Version

ItemJoin-6.0.6-SNAPSHOT-b977

Dump Information

https://ci.craftationgaming.com/dump?id=labeyucedu

Describe The Bug

Error displayed in administrator chat and console mysql:https://mclo.gs/NxZ4q9i sqlite:https://mclo.gs/WbHdAgD

Expected Behavior

Can be hidden or fixed.

Steps To Reproduce

1.Player synchronizes inventory from server A to server B, then returns from B to A.

Additional Info

mysql M89IWZ3FY}L`87WMZVE~ESA

Checklist

[X] I am running latest version of this resource.
[X] I have read the wiki to make sure it's not an issue with configuration.
[ ] I ticked all of these boxes without actually reading them.
[X] I have checked that my bug report is unique and a previous report does not exist.

RockinChaos commented 4 months ago

Confirmed, the issue was due to a tweak I made to database handling. Link; https://ci.craftationgaming.com/downloads Remember to remove your old ItemJoin.jar file

Let me know!~

sagaciousness2022 commented 4 months ago

I have already installed version 6.0.6-SNAPSHOT-b978. The console is no longer displaying, but the OP chat is still visible. 93a00d55085d2c2f32582bb9e88d955

RockinChaos commented 4 months ago

Could you enable debugging in ItemJoin's config.yml and then /itemjoin reload and produce the error again? It should list something in the console after doing that.

sagaciousness2022 commented 4 months ago

I tried enable debugging and reload, and the error hasn't occurred since then. I tested it for two days, including several sub-servers, and it's been the same situation. https://mclo.gs/L31YMYD

RockinChaos commented 4 months ago

Is this including the OP chat as well or is it still showing the error in the chat?

sagaciousness2022 commented 4 months ago

Include OP chatting, and the console won't throw errors even when debug mode is not enabled.

RockinChaos commented 4 months ago

Ah okay, in that case, it's likely the previous issue after updating was a residual message from when it was fixing the database due to the incorrect formatting in the previous version.

I'll keep this issue open for a bit, let me know if the issue occurs again. I recommend keeping debugging enabled in the meantime in case the issue occurs so we can get the stack trace.

EDIT: Offical release is now available; Link; https://www.spigotmc.org/resources/itemjoin.12661/download?version=542784