the delphic expanse

Panyasan's Account

Report Bugs and make suggestions here.

Panyasan's Account

Postby Honeybee » Tue Feb 07, 2012 8:27 pm

Panyasan's, a long time member, account has gone poof! Disappeared. She can't log on and I can't find it in the ACP. I looked in the tables, but not too carefully and it's a long list.

But any ideas? Anyone?
User avatar
Honeybee
Site Admin
 
Posts: 5634
Joined: Sat Sep 11, 2010 2:37 pm

Re: Panyasan's Account

Postby Kotik » Tue Feb 07, 2012 8:41 pm

The account table is usually a primary table, meaning that if the account is gone (which it looks like according to the member list) the whole record is gone, meaning that a lot of foreign key entries are now orphaned. I tried to find some of her posts, but nada, confirming that a primary key entry is missing.

Since she's a long time member, an overwrite with an obsolete backup appears unlikely, which leaves an accidental DELETE or a corruption of the users table as the likely culprit.
User avatar
Kotik
Lieutenant JG
 
Posts: 64
Joined: Thu Oct 28, 2010 7:46 am

Re: Panyasan's Account

Postby Glory1863 » Tue Feb 07, 2012 8:42 pm

Honeybee, does it help at all that when you count how many members you can see on the member list, you get 110, but the member table itself says there are 111? Or is that what you just said?

I looked in one place where I knew she had posts because she fixed my Japanese in a drabble. Her original posts are gone, but where I've quoted them, the quote is still visible.
MR_Beautiful avatar by M&M (Mareel and Misplaced)
User avatar
Glory1863
Captain
 
Posts: 1001
Joined: Sat Sep 18, 2010 9:00 am
Location: Illinois

Re: Panyasan's Account

Postby Honeybee » Tue Feb 07, 2012 10:23 pm

That's very helpful Glory! I will look into that.
User avatar
Honeybee
Site Admin
 
Posts: 5634
Joined: Sat Sep 11, 2010 2:37 pm

Re: Panyasan's Account

Postby Kylah618 » Tue Feb 07, 2012 10:31 pm

If you can access the database, try running a query to see if you can pull up her account name that way. Also, you can sometimes search the table by email address and not username. Sometimes during a re-install of forum software usernames can be corrupted, so searching by email is a good backup.

That's all I got without physically looking at it.
Malcolm: The radio! Or is it just the galaxy, giggling at us again?
Trip: It can giggle all it wants. But the galaxy's not gettin' any of our burbon!
User avatar
Kylah618
Lt. Commander
 
Posts: 443
Joined: Tue Dec 06, 2011 12:10 am

Re: Panyasan's Account

Postby EntAllat » Tue Feb 07, 2012 11:15 pm

She's back!

This was another symptom of the previously mentioned mySQL server crashes. A table was corrupted and the "repair table" function that was used to fix it, deleted that record. Her record's been restored from the backups I have. All her posts are back and she's visible in the ACP too. She should be able to login again.
User avatar
EntAllat
Site Admin
 
Posts: 3720
Joined: Tue Jan 11, 2011 3:02 pm
Location: Texas

Re: Panyasan's Account

Postby panyasan » Wed Feb 08, 2012 1:04 am

EntAllat wrote:She's back!

I am! :lol: It was weird to log in and get the message "this login name doesn't exist" :shock: (like standing in front of the window of a house and seeing all the fun and shouting "I want in, I want in"). But I am back now. :cheering
Thanks everyone for your efforts! :hugs
Avatar by Bluetiger
User avatar
panyasan
Commander
 
Posts: 746
Joined: Mon Sep 13, 2010 10:12 am

Re: Panyasan's Account

Postby Glory1863 » Wed Feb 08, 2012 2:38 pm

Glad you're back, Panyasan! Your experience reminds me of a fic (which I can't find at the moment) where Malcolm goes through the tortures of the damned trying to prove to Starfleet that, contrary to popular belief and HR's computer, he isn't dead yet. :lol:
MR_Beautiful avatar by M&M (Mareel and Misplaced)
User avatar
Glory1863
Captain
 
Posts: 1001
Joined: Sat Sep 18, 2010 9:00 am
Location: Illinois

Re: Panyasan's Account

Postby Hummingbird2 » Wed Feb 08, 2012 3:54 pm

Glory1863, I think that this is what you were referring to: Written Off by Exploded Pen and The Libran Iniquity http://fiction.entstcommunity.org/views ... p?sid=3918
Icon by TwilightProwler.
User avatar
Hummingbird2
Commander
 
Posts: 567
Joined: Sat Oct 23, 2010 5:17 am

Re: Panyasan's Account

Postby Glory1863 » Wed Feb 08, 2012 7:52 pm

Yep, that's the one, Hummingbird2. Thanks! Hope everyone gets a chuckle out of it.
MR_Beautiful avatar by M&M (Mareel and Misplaced)
User avatar
Glory1863
Captain
 
Posts: 1001
Joined: Sat Sep 18, 2010 9:00 am
Location: Illinois


Return to Forum Issues

  • Who is online

    Users browsing this forum: No registered users and 1 guest