Database cleanup

Discussion in 'Development News' started by Afr0, Dec 30, 2014.

  1. Afr0

    Afr0 Well-Known Member

    I went through and deleted over 80 useless accounts tonight, and it annoyed me to the point where I realized that I need to implement checks so it'll be impossible to create accounts that contains "username" or only numbers etc.
    Anyway, in this process I, unfortunately, managed to delete most of the chars in the login DB. This forced me to do a merge from the city server DB. In the process, some characters may have been lost. I also deleted duplicate characters (I.E characters belonging to accounts that already had three characters.)
    I also discovered that, somehow, all the number of characters for accounts had vanished into thin air!!
    This means that I had to start adding them manually. I did for some accounts, but doing it for all of them would take me a good month or two. So until I can find a way to automate this process, most accounts won't be able to access their characters. I apologize for this!

    In the meantime, I can report that the servers are more stable than ever. :)
    RainCloud likes this.
  2. AquilaSim

    AquilaSim Administrator Staff Member Moderator

    "TSOClient has stopped working" when I try to login to my account now.
  3. RainCloud

    RainCloud Active Member

    Awesome ... mine are still there and it's working great!
    Blayer98 likes this.
  4. Afr0

    Afr0 Well-Known Member

    Offredo, delete your character cache.
  5. AquilaSim

    AquilaSim Administrator Staff Member Moderator

    I have already done and yet again, this did not solve the problem so the cache is not the problem. :/
  6. Afr0

    Afr0 Well-Known Member

    Ugh, I really should make the client produce a stack dump when crashing.
  7. liinor

    liinor Member

    When tries to go into City Screen it pop up Loading Screen and loads character menu again, but music changes and city screen loading button doesn't do anything so it supposed to show city screen at this moment. But It does not show it for me.

    And "cancel" and " "continue" buttons in Sim creating screen aint doing anything.
    Last edited: Dec 31, 2014
  8. Afr0

    Afr0 Well-Known Member

  9. Afr0

    Afr0 Well-Known Member

    Actually, I know why client is crashing for francot. It's cos his account doesn't have number of characters in DB.
    liinor, I'm not sure what causes your issues unfortunately. :/
  10. SodaDog

    SodaDog Member

    I still cannot create my sim.
  11. Afr0

    Afr0 Well-Known Member

    Fixed char creation, I can now go back to working on the chat system.
  12. AquilaSim

    AquilaSim Administrator Staff Member Moderator

    Would it be possible if you have enough time to delete my account Offredo95 from servers please ? Reason : he crash every connection attempt.
  13. Afr0

    Afr0 Well-Known Member

    I fixed your account, you should be able to log in now!
  14. AquilaSim

    AquilaSim Administrator Staff Member Moderator

    There definitely has nothing to do, TSOslient crash always... :(
    (Note : I deleted the cache for try, but it does not matter) :/
  15. Verion

    Verion New Member

    I still cannot create a Sim :(. The Accept button isn`t working...
    Timothy and SodaDog like this.
  16. SodaDog

    SodaDog Member

    On the same boat as him...
  17. Afr0

    Afr0 Well-Known Member

    Offredo95, please install latest version from Github, it will produce a log and show you the specific error in a messagebox!
  18. AquilaSim

    AquilaSim Administrator Staff Member Moderator

    This version on Github install is the 0.1.22.0 not 0.1.23.0 + I can't update and when I try, I get the message "has stopped to working.", so I can't join the servers. :/
  19. Afr0

    Afr0 Well-Known Member

    Sorry, I fixed the release, should work now! :)
  20. AquilaSim

    AquilaSim Administrator Staff Member Moderator

    Still does not work, I tried everything... its not working right when I try to login to my account not with a other, only with my account Offredo95.

    Notes : I sent you the last report of error register in my computer on Skype.

Share This Page