search

CoreNetwork / Mantle

The main plugin powering majority of features on Flatcore
1 stars 1 forks source link

Hydration still resetting on server reboot #349

Closed riddle closed 9 years ago

riddle commented 9 years ago

Sorry @matejdro :(

matejdro commented 9 years ago

Mantle db pls.

riddle commented 9 years ago

https://www.dropbox.com/s/bvokl77srz2jr6w/mantle-data.sqlite?dl=0

matejdro commented 9 years ago

DB looks fine... Is it resetting for everyone everytime or just some people sometimes?

eliadil commented 9 years ago

Spctr reported few times that after the restart he starts with ~15 hydration. Every time after a restart.

matejdro commented 9 years ago

Hm nevermind looks like I was looking at wrong database, it DOES use old table format.

@riddle you will have to run this:

CREATE TEMPORARY TABLE hydration_backup(PlayerUUID STRING, Hydration REAL, Saturation REAL, FatigueLevel INTEGER, FatigueLevelStart INTEGER, DeliveredMessages STRING);
INSERT INTO hydration_backup SELECT * FROM hydration;
DROP TABLE hydration;
CREATE TABLE hydration (PlayerUUID STRING PRIMARY KEY, Hydration REAL, Saturation REAL, FatigueLevel INTEGER, FatigueLevelStart INTEGER, DeliveredMessages STRING);
INSERT INTO hydration SELECT * FROM hydration_backup GROUP BY PlayerUUID;
DROP TABLE hydration_backup;