Data not saving in MySQL

[nyvlunx]

Greeting ! I got a problem with saneeconomy not saving players balance into MySQL, it connect properly to it without error message. This happen when i restart the server and when i reload the saneeco database

Spigot version : CraftBukkit version git-Spigot-90f61bc-83a9dbd (MC: 1.10.2) SaneEco version : SaneEconomyCore-0.6.6-SNAPSHOT SaneEco config.yml : http://pastebin.com/QmghU6cM

SaneEconomy connection to database : http://pastebin.com/NrbEicaZ (Everytime the same "Performing initial data load..." message at server restart) Database-reload command proof : http://pastebin.com/Lh5JGjML

Nevertheless, flatfile is working perfectly Sadly, i also get the same problem with version 0.6.4

[AppleDash]

That's an interesting problem. Can you check your database, and see if there is actually any SaneEconomy tables in your database, and any data in the tables?

(Also, the "Performing initial data load" message is expected - it needs to load all the data at server startup, so it does so.)

[nyvlunx]

The SaneEconomy table is present : http://prntscr.com/c1zgcd Saneeconomy_balance is empty : http://prntscr.com/c1zh5i But Saneeconomy_shema is not empty : http://prntscr.com/c1zhcm

Ah ok, it was just the "itinial' word that i do comprehend differently! Also i test with different player and same problem of not saving at db reload

[AppleDash]

Hmm, that's interesting! Do you have any errors in console when you do /eco give your_minecraft_name 1000 ?

On 08/05/2016 10:20 AM, Noiknez wrote:

The SaneEconomy table is present : http://prntscr.com/c1zgcd Saneeconomy_balance is empty : http://prntscr.com/c1zh5i But Saneeconomy_shema is not empty : http://prntscr.com/c1zhcm

Ah ok, it was just the "itinial' word that i do comprehend differently! Also i test with different player and same problem of not saving at db reload

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/AppleDash/SaneEconomy/issues/9#issuecomment-237862987, or mute the thread https://github.com/notifications/unsubscribe-auth/AB2ZLThckJvnRRT3ruOeJPdFAgqedO0aks5qc0aXgaJpZM4JdU_K.

[nyvlunx]

No error :

[16:24:30] [INFO] [Economy] Added 1000,00 units to naeliks. Their balance is now 1000,00 units.

[AppleDash]

And after you do that... Nothing in the database still?

On 08/05/2016 10:24 AM, Noiknez wrote:

No error :

[16:24:30] [INFO] [Economy] Added 1000,00 units to naeliks. Their
balance is now 1000,00 units.

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/AppleDash/SaneEconomy/issues/9#issuecomment-237864318, or mute the thread https://github.com/notifications/unsubscribe-auth/AB2ZLYip2HyygfK61WClnL2JcdGhgodfks5qc0e3gaJpZM4JdU_K.

[nyvlunx]

Nothing in the database balance table after setting a balance to a player, me or someone sadly : http://prntscr.com/c202h3

[AppleDash]

That is very interesting... I will get back to you, hopefully by tomorrow. In the mean time, use Flatfile - once I solve this, I will add a command to convert Flatfile to MySQL.

On 08/05/2016 11:02 AM, Noiknez wrote:

Nothing in the database balance table after setting a balance to a player, me or someone sadly : http://prntscr.com/c202h3

— You are receiving this because you commented. Reply to this email directly, view it on GitHub https://github.com/AppleDash/SaneEconomy/issues/9#issuecomment-237874466, or mute the thread https://github.com/notifications/unsubscribe-auth/AB2ZLe9dLjXw1-8unnei6KfEI07OPP8jks5qc1CdgaJpZM4JdU_K.

[AppleDash]

This is a very weird issue... I'm having problems finding the cause. I know it has to do with the fact you are in France (or Quebec), however.

[nyvlunx]

No problem, i surely can wait; its a french server, if you need more information about my host or the mysql host, i can give you that

[jack-the-cat]

Hey AppleDash (and Noiknez, sorry to crash your thread :) ). I've got the same issue on my server too... Your plugin functions normally with no error messages, but doesn't add data to the database at all. It creates the tables as normal, but doesn't enter any data.

[AppleDash]

Fixed it now @Noiknez and @twaitsey !

Try this release: https://github.com/AppleDash/SaneEconomy/releases/tag/0.7.1

To convert data from Flatfile to MySQL, configure MySQL as normal and then add a section like this:

old-backend
  type: flatfile

Conversion will automatically happen on server restart.

[AppleDash]

Please reopen this if the problem persists :)

[nyvlunx]

Hi again, with this version i got this error http://pastebin.com/0bTYmnDc No problem to connect to the mysql therefore ^^