v.0.9.1 breaks database from v.0.8 and earlier about flexiblelogin

[games647]

Do you had any errors on the first start of 0.9?

[GershonR]

No errors as far as I know, I can upload the database for you to test.

SpongeForge 1547

[games647]

Yeah good idea. If there was an error, the old database should be still there. So I could import it for you.

[GershonR]

-removed by games647 for security to the user passwords-

What SQL type ? H2? Or SQLite? Or...
The new version default sql type is H2, not SQLite...

[games647]

@sourcepowered They are different SQL storage system.

https://en.wikipedia.org/wiki/SQLite
https://en.wikipedia.org/wiki/H2_(DBMS)

[games647]

@GershonR Do you have multiple database files in your flexiblelogin folder too?

BTW I only need the .mv file.

EDIT: @GershonR I found 100 database records in your database. Is that correct?

@games647 YES, I know that, but I mean is, what Database version he used in old version of plugin, if he use "SQLite" in config, and update to new version, but new version's config setting is "H2", I think it will not work any more. So, I think he should to check his config file. Because he said "it deletes the current database and requires everyone to re-register again" and "No errors as far as I know, I can upload the database for you to test.".
My friend, what do you think about this?
May I was wrong... :P

[GershonR]

Here is the current config for the working one:
http://pastebin.com/8F4mAgaQ

and I think I have much more accounts than 100 records and I only have the trace and normal database in my folder that's it

[games647]

@sourcepowered Sorry, in the past I had some users who doesn't understand how to the ticket system.

If it was SQLite before I could export the old data as SQL inserts and import it in a new one.

@GershonR I browsed the database you sent me and there is only the new table, the old one doesn't exist anymore.

@games647 OK, sir, you've had a long day. I've never seen a developer so responsible.

[GershonR]

Here is another one, it's the latest one which the server uses, it should definitely have probably over 1,000 accounts.

[games647]

Ok there are already 1.800 accounts with the new database schema. and I couldn't find any duplicates.

[GershonR]

That's the original one, when it gets converted all of that gets deleted and a new file is made.

[GershonR]

Any news on this?

[games647]

No sorry, the old database is gone.

[GershonR]

Do you want me to reupload it then for you to test?

[games647]

No sorry, I couldn't find the old database table.

[GershonR]

Can you make a importer so it will load the old database and add the data to the new one?

[games647]

How if the old database doesn't exist anymore?

[GershonR]

I have the old database I backed it up before updating and when the plugin was deleting the database I downgraded back

[games647]

I could try it.

[GershonR]

I just decided to let it regenerate everything