Important: when posting, please provide your Club Number at a minimum, and as many details as possible.
For further info, please read This page before posting.

Membership Data Corrupted

  • crinella
  • crinella's Avatar
  • Offline
  • New Member
  • New Member
  • Posts: 1
  • Thanks: 0

Re: Membership Data Corrupted

11 years 2 months ago
#48352
I can also verify that membership data was corrupted for our site. I logged in as an administrator and noticed that half of our members seem to be missing (including myself). Moments before logging in as a site admin, I had just logged in to my personal account and updated a meeting agenda.

I'm using the latest version of Google Chrome and have cleared my browsing history/cache.
The topic has been locked.
  • d_j_liu
  • d_j_liu's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 14
  • Thanks: 4

Re: Membership Data Corrupted

11 years 2 months ago
#48353
Do we have a backup copy of the data before changes in the server code? If so, there is hope that we can roll back these changes and restore operation, and all we lose is perhaps one day of changes. Otherwise it would be very difficult to make the system usable again, because I can only access as administrator, I cannot find my own records, and we are missing records of other members as well.,
David J. Liu, ACS ALB
Club 907017, Goleta, CA
The topic has been locked.
  • SteveTheTechie
  • SteveTheTechie's Avatar
  • Offline
  • Emeritus
  • Emeritus
  • Posts: 11492
  • Thanks: 3057

Re: Membership Data Corrupted

11 years 2 months ago - 11 years 2 months ago
#48354
Please be patient. We can roll back the data changes. However, only Brian can do that.

Restoring a db table affects *everyone*, so I don't take that lightly either.
Last edit: 11 years 2 months ago by SteveTheTechie.
The topic has been locked.
  • d_j_liu
  • d_j_liu's Avatar Topic Author
  • Offline
  • New Member
  • New Member
  • Posts: 14
  • Thanks: 4

Re: Membership Data Corrupted

11 years 2 months ago
#48355
The root cause of recent problems is almost certainly in the database on the server. There is nothing users can do at this moment. Administrators of individual clubs should be warned against trying to fix membership lists because this will likely make things worse, as members are stored with unique numbers not accessible to club officers, and trying to update the list can cause more mismatching.
David J. Liu, ACS ALB
Club 907017, Goleta, CA
The topic has been locked.
  • SteveTheTechie
  • SteveTheTechie's Avatar
  • Offline
  • Emeritus
  • Emeritus
  • Posts: 11492
  • Thanks: 3057

Re: Membership Data Corrupted

11 years 2 months ago - 11 years 2 months ago
#48356
Hey, David, I am the system developer. I caused the problem... I have already fixed the cause of the problem. Just have to handle the data damage now, which I need Brian for. (he Is the db admin)

Patience please.
Last edit: 11 years 2 months ago by SteveTheTechie.
The topic has been locked.
  • SteveTheTechie
  • SteveTheTechie's Avatar
  • Offline
  • Emeritus
  • Emeritus
  • Posts: 11492
  • Thanks: 3057

Re: Membership Data Corrupted

11 years 2 months ago
#48361
Ok, we have restored a db backup. Please check your roster information.
The following user(s) said Thank You: d_j_liu
The topic has been locked.
Moderators: BrianHeniPamrhtaylor3marc33NotLiableNSBjgavinLcala305peterb323DebbieT
Time to create page: 0.152 seconds