« previous next »
Pages: [1]

Author Topic: Server problems possible stats lose!  (Read 5268 times)

[TNM]Roban

  • Administrator
  • Hero Member
  • ********
  • Posts: 1176
  • Reputation: 1384
  • Me playing sa-mp..
    • The web of carnage
Server problems possible stats lose!
« on: July 26, 2010, 22:31:06 pm »
Today my user database got corrupted. So it was impossible to join the server in like 5 hours before I found out this. I did repair the database but it seems like 3000 user accounts got lost! I have backups so if someone have lost the stats just ask me and I will fix it. 3000 accounts doesn't need to be so bad but maybe it is we will see.
Logged

[TNM]Roban

  • Administrator
  • Hero Member
  • ********
  • Posts: 1176
  • Reputation: 1384
  • Me playing sa-mp..
    • The web of carnage
Re: Server problems possible stats lose!
« Reply #1 on: July 26, 2010, 22:36:11 pm »
A note to all players if it stands "Server closed the connection" all the time when you join then there is a problem with the user database. So tell me if it happens and I will fix it..
Logged

[TNM]Roban

  • Administrator
  • Hero Member
  • ********
  • Posts: 1176
  • Reputation: 1384
  • Me playing sa-mp..
    • The web of carnage
Re: Server problems possible stats lose!
« Reply #2 on: July 26, 2010, 23:47:22 pm »
Seems like the data lose only is for new users from user id 8058 to 11335 have been lost:/ in this users there are unregistered and unused accounts so I hope there is not so many that needs to be restored but we will see...
Logged

[TNM]Roban

  • Administrator
  • Hero Member
  • ********
  • Posts: 1176
  • Reputation: 1384
  • Me playing sa-mp..
    • The web of carnage
Re: Server problems possible stats lose!
« Reply #3 on: July 27, 2010, 01:05:13 am »
Tomorrow I maybe will be able to restore like 50% of the lost accounts automatically but the rest will I need to restore on request... Also i'm 90% sure that this stats lost only affects new users like 15 days or never accounts.
Logged

[TNM]Roban

  • Administrator
  • Hero Member
  • ********
  • Posts: 1176
  • Reputation: 1384
  • Me playing sa-mp..
    • The web of carnage
Re: Server problems possible stats lose!
« Reply #4 on: July 27, 2010, 01:06:43 am »
One sad thing was that the server was full when it happened and that no one emailed or pmed me here about it. I'm away from home so I can't play sa-mp so it was just luck that I found out that the server got some big problems.
Logged

[TNM]Roban

  • Administrator
  • Hero Member
  • ********
  • Posts: 1176
  • Reputation: 1384
  • Me playing sa-mp..
    • The web of carnage
Re: Server problems possible stats lose!
« Reply #5 on: July 27, 2010, 01:18:56 am »
I'm so fucking smart.. I didn't take an backup of the damaged database before I repaired it and now I did read the information about repair... It stands sometimes the repair fails and some data gets lost so make an backup before repairing the database... Damn that's why you should always read the information available before doing anything-_-
Logged

EDEN

  • Global Moderator
  • Full Member
  • *****
  • Posts: 151
  • Reputation: 193
Re: Server problems possible stats lose!
« Reply #6 on: July 27, 2010, 13:27:50 pm »
My password is not valid anymore for all my accounts :/

I am kinda glad I'm not a daily reg player anymore tbh..this would be very annoying if so.
Logged

[TNM]Roban

  • Administrator
  • Hero Member
  • ********
  • Posts: 1176
  • Reputation: 1384
  • Me playing sa-mp..
    • The web of carnage
Re: Server problems possible stats lose!
« Reply #7 on: July 27, 2010, 13:53:52 pm »
I will do a total user rollback when I come home in some hours..
Logged

[TNM]Roban

  • Administrator
  • Hero Member
  • ********
  • Posts: 1176
  • Reputation: 1384
  • Me playing sa-mp..
    • The web of carnage
Re: Server problems possible stats lose!
« Reply #8 on: July 27, 2010, 13:57:40 pm »
I think that I wont add score to pll this time so ALL players will lose 3-5 days of game play. I'm sorry for this and I will add a auto backup system as fast as I can.. So I got more updated backups.
Logged

[TNM]Roban

  • Administrator
  • Hero Member
  • ********
  • Posts: 1176
  • Reputation: 1384
  • Me playing sa-mp..
    • The web of carnage
Re: Server problems possible stats lose!
« Reply #9 on: July 29, 2010, 13:32:39 pm »
I have made a small auto backup cron job today. so from now on there will be 2 userstats backup made everyday.
Logged
Pages: [1]
« previous next »