suriyun-production / mmorpg-kit-docs

This is document for MMORPG KIT project (https://www.assetstore.unity3d.com/#!/content/110188?aid=1100lGeN)
https://suriyun-production.github.io/mmorpg-kit-docs
48 stars 11 forks source link

Database issue after newest update #1820

Closed Jay12134 closed 1 year ago

Jay12134 commented 1 year ago

Hello, When I updated to the newest version players are unable to login to old accounts only can make new account.

I noticed lots of errors in yellow on console do you know why this might be happening? everything is the same and all passwords are right.

Thank you for your help!

1057b5882a82c442d21e81d8122b087f

19a3799c8efa8ad51b42bbc82b948d19

insthync commented 1 year ago

Those warning may be shown because you've set up for client build, so server codes will be excluded.

insthync commented 1 year ago

How did you update, just change codes or re-create new database tables? are you using MySQL or SQLite?

Jay12134 commented 1 year ago

Thanks for your response.

I updated with the same method as in the document to delete some folders and update. I did nothing to the database and also didn't overwrite my scenes.

Was there maybe something new I need to add to my scenes? Very weird that the database didn't connect after updating. I'm using MySQL. I've updated before it's not my first time but was wondering if maybe something changed with database that I needed to do.

Thanks!

insthync commented 1 year ago

May I see your mySqlConfig.json ?

Jay12134 commented 1 year ago

I don't use a config file as it never worked for me, I use the inspector in the network scene.

insthync commented 1 year ago

Then when you change some settings you have to rebuild and rerun the server.

Jay12134 commented 1 year ago

Alright I'll try again, last I checked all the settings are correct since it worked before the last update I didn't change any settings.

I just wanted to check and make sure I didn't need to do anything with the new update and MySQL. I just updated code was wondering if I needed to do anything with the database or init scene.

Thanks

Jay12134 commented 1 year ago

{"mySqlAddress":"127.0.0.1","mySqlPort":3306,"mySqlUsername":"admin","mySqlPassword":"changedpass","mySqlDbName":"mmorpg_kit"}

^so I tried to go back to the old version I was using and still a problem, I cant connect to the mysql database.. All the settings are the same and match exact.

This is so weird because I don't see anything in the boot console about mysql even though its set to mysql, I've rebuilt server too. I am so lost with this it was working perfect for 8 months then all of a sudden when I updated to newest it wont connect to any mysql it just falls back on sqlite. :(

sorry to be a pain in the ass, but you are my only hope for help on this. All the settings are the same as before and its exactly right.

insthync commented 1 year ago

I want to check it by using AnyDesk

insthync commented 1 year ago

No responding, so I will close this