search

cadenkriese / Thirst

Thirst plugin for Spigot. Adds a thirst mechanic into minecraft!
GNU General Public License v3.0
1 stars 2 forks source link

Database mismatch #25

Open x1p opened 6 years ago

x1p commented 6 years ago

When 2 servers use the same database, players suffer from differences in thirst. Example: Server 1: player has 60 percent, drinks thus percentage is 80. Goes to server 2: thirst is 60 again. But there are more differences that are not understandable that are unexplainable.

cadenkriese commented 6 years ago

Hey there, I've made a snapshot jar with an attempted fix for this issue, I don't have multiple servers to test this with right now so If you could test the snapshot, it would be greatly appreciated. You can download the snapshot here.

x1p commented 6 years ago

Multiple errors PLUGIN MESSAGE: Error occurred while running query 'SELECT * FROM thirst WHERE uuid = 'here was the uuid of a player'

java.lang.NullPointerException

org.bukkit.event.EventException: null

java.sql.SQLTransientConnectionException: HikariPool-4 - Connection is not available, request timed out after 30000ms.

java.lang.NullPointerException

etc etc. Crashes completely. Full error log: https://hastebin.com/iropoqayar.sql

cadenkriese commented 6 years ago

I'll fix the crashing part as soon as I get a chance, but I'm fairly certain that the server is unable to connect to your database. Could you double check you have your credentials correct?

x1p commented 6 years ago

I'm quite sure that our credentials are correct.

cadenkriese commented 6 years ago

Alright, it could very well be on my end I'll look into this in a few hours when I can.

cadenkriese commented 6 years ago

Hey there, I've been quite busy over the past few weeks, I've set a due date on the trello saying I aim to get the fix for this out by next Sunday.