Zrips / CMI

116 stars 97 forks source link

Database Update Not Working #8133

Closed mufugo closed 11 months ago

mufugo commented 1 year ago

Description of Issue

I use this query: UPDATE CMI_users SET Balance = Balance * 0.01 WHERE username = 'mufugo' IDE I am using: DataGrip MySQL - SQLite both tried the same I also check after UPDATE and see that the record has been updated

I updated the server when no one was on and used /cmi reload - didn't work I updated while the server was down and it didn't work I tried with the server open and the player (i.e. me) in the game and it still didn't work.

Version Information

[00:29:46 INFO]: --------------------------------------------------
[00:29:46 INFO]: CMI: 9.6.3.0 BungeeCord  MySQL
[00:29:46 INFO]: CMILib: 1.4.1.1 
[00:29:46 INFO]: Server: Paper(794) 1.16.5-R0.1-SNAPSHOT
[00:29:46 INFO]: CMI economy: Etkin Vault: 1.7.3-CMI CMI Chat: Etkin 
[00:29:46 INFO]: Modules -> 54 enabled 5 disabled: flightCharge, chatBubble, tablist, moneyCheque, timedCommands
[00:29:46 INFO]: --------------------------------------------------

Errors

No response

Relevant Config Sections

No response

Relevant Plugins

CMI Economy

Agreements

Zrips commented 11 months ago

Player data is being cached, aka loaded on server startup, we are not reloading it when performing /cmi reload, that one is only for save/config files. That said, it could take effect only when server is down at the moment you modified values or have specialized small plugin to force load players new data from database.