Educational

Author Topic: deleting accounts  (Read 1197 times)

0 Members and 1 Guest are viewing this topic.

Offline Jack

  • Reiterative Utterance of the Aspie Elite
  • Elder
  • Maniacal Postwhore
  • *****
  • Posts: 14550
  • Karma: 0
  • You don't know Jack.
Re: deleting accounts
« Reply #30 on: March 07, 2013, 04:24:22 PM »
Still not convinced this is what's occurring. If so, it would stand to reason this place would be fundamentally broken. It doesn't make sense; the search function shouldn't even work properly when searching by username for deleted accounts, though that's hard to say for certain without knowing exactly where the search looks. Can you query your user tables for deleted accounts, or can you only retrieve information from other tables for those users?

Do you think the aspie overlord is hiding something nefarious?

No. Only trying to assess my damage.

Offline Jack

  • Reiterative Utterance of the Aspie Elite
  • Elder
  • Maniacal Postwhore
  • *****
  • Posts: 14550
  • Karma: 0
  • You don't know Jack.
Re: deleting accounts
« Reply #31 on: March 07, 2013, 04:25:20 PM »
This place isn't fundamentally broken? ;)
What a bunch of crap. Should change my custom title to, Silent Destroyer of the Aspie Elite.
Don't get too far ahead of yourself. Wait until you have actually destroyed us.  :laugh:

:laugh:


midlifeaspie

  • Guest
Re: deleting accounts
« Reply #32 on: March 07, 2013, 04:28:07 PM »
Still not convinced this is what's occurring. If so, it would stand to reason this place would be fundamentally broken. It doesn't make sense; the search function shouldn't even work properly when searching by username for deleted accounts, though that's hard to say for certain without knowing exactly where the search looks. Can you query your user tables for deleted accounts, or can you only retrieve information from other tables for those users?

Do you think the aspie overlord is hiding something nefarious?

No. Only trying to assess my damage.

Seems somebody deletes an account every month or two.  I wouldn't worry too much about damage you caused this place, instead maybe the damage this place has caused you :)

Offline odeon

  • Witchlet of the Aspie Elite
  • Webmaster
  • Postwhore Beyond Repair
  • *****
  • Posts: 108879
  • Karma: 4482
  • Gender: Male
  • Replacement Despot
Re: deleting accounts
« Reply #33 on: March 07, 2013, 04:54:17 PM »
Still not convinced this is what's occurring. If so, it would stand to reason this place would be fundamentally broken. It doesn't make sense; the search function shouldn't even work properly when searching by username for deleted accounts, though that's hard to say for certain without knowing exactly where the search looks. Can you query your user tables for deleted accounts, or can you only retrieve information from other tables for those users?

Why would it be fundamentally broken? I don't follow you.
"Only two things are infinite, the universe and human stupidity, and I'm not sure about the former."

- Albert Einstein

Offline Jack

  • Reiterative Utterance of the Aspie Elite
  • Elder
  • Maniacal Postwhore
  • *****
  • Posts: 14550
  • Karma: 0
  • You don't know Jack.
Re: deleting accounts
« Reply #34 on: March 07, 2013, 06:09:30 PM »
You answer my questions first. It might not be; not convinced it is.

Offline Queen Victoria

  • Ruler of Aspie Universe
  • Elder
  • Almighty Postwhore
  • *****
  • Posts: 28244
  • Karma: 2805
  • Gender: Female
Re: deleting accounts
« Reply #35 on: March 07, 2013, 06:12:43 PM »
Instead of deleting their accounts we should simply chop off their heads.  Either way we hopefully won't hear from them again and the second way is easier on Odeon.
A good monarch is a treasure. A good politician is an oxymoron.

My brain is both uninhibited and uninhabited.

:qv:

Offline Jack

  • Reiterative Utterance of the Aspie Elite
  • Elder
  • Maniacal Postwhore
  • *****
  • Posts: 14550
  • Karma: 0
  • You don't know Jack.
Re: deleting accounts
« Reply #36 on: March 07, 2013, 06:14:35 PM »
:laugh: Nice jab.

P7PSP

  • Guest
Re: deleting accounts
« Reply #37 on: March 07, 2013, 06:48:59 PM »
Instead of deleting their accounts we should simply chop off their heads.  Either way we hopefully won't hear from them again and the second way is easier on Odeon.
:indeed: that would keep Jack from fucking with the database.  :viking:

Offline Jack

  • Reiterative Utterance of the Aspie Elite
  • Elder
  • Maniacal Postwhore
  • *****
  • Posts: 14550
  • Karma: 0
  • You don't know Jack.
Re: deleting accounts
« Reply #38 on: March 07, 2013, 09:00:41 PM »
In your database, breaking your connections.

Offline odeon

  • Witchlet of the Aspie Elite
  • Webmaster
  • Postwhore Beyond Repair
  • *****
  • Posts: 108879
  • Karma: 4482
  • Gender: Male
  • Replacement Despot
Re: deleting accounts
« Reply #39 on: March 08, 2013, 03:36:43 PM »
You answer my questions first. It might not be; not convinced it is.

No, I can't query a deleted account other than indirectly. Every account has a unique number (it's just a counter) and when the account is deleted, the number is lost. It won't be reused but you can't tell who it belonged to.

As for posts by deleted members, you may have noticed that the posts are authored by named guests. The setup is the same as it was when guests were allowed to post--the post is associated with a name that is really just a character string that is not associated with anything else than that particular post. Searching for posts by that deleted member simple gives you a series of unrelated posts where the named guest happens to use the same alias, every time. You can't use that to search for quoted replies other than by inference.

The quoted posts, on the other hand, display the nick used by the member at the time when the post was made. Again, this is similar to the guest setup. It's just a text string that once was the member's then-current nick.

All of the relations have been lost, see. Every single one, really.

There is an option to delete that member's posts when deleting the account, btw. There's no way I'd agree to anything like that because it would fuck up the db. I doubt the code would be able to handle a forum as large as this one, not if the member in question had posted more than a handful of posts.
"Only two things are infinite, the universe and human stupidity, and I'm not sure about the former."

- Albert Einstein

Offline odeon

  • Witchlet of the Aspie Elite
  • Webmaster
  • Postwhore Beyond Repair
  • *****
  • Posts: 108879
  • Karma: 4482
  • Gender: Male
  • Replacement Despot
Re: deleting accounts
« Reply #40 on: March 08, 2013, 03:37:25 PM »
Instead of deleting their accounts we should simply chop off their heads.  Either way we hopefully won't hear from them again and the second way is easier on Odeon.

Thanks. How nice of you to think of me.
"Only two things are infinite, the universe and human stupidity, and I'm not sure about the former."

- Albert Einstein

Offline Jack

  • Reiterative Utterance of the Aspie Elite
  • Elder
  • Maniacal Postwhore
  • *****
  • Posts: 14550
  • Karma: 0
  • You don't know Jack.
Re: deleting accounts
« Reply #41 on: March 08, 2013, 04:43:43 PM »
I see. Thanks. Then there's no need to explain how/why your data is broken. Though considering the information and who actually uses it, it's really mostly broken for you.

Offline odeon

  • Witchlet of the Aspie Elite
  • Webmaster
  • Postwhore Beyond Repair
  • *****
  • Posts: 108879
  • Karma: 4482
  • Gender: Male
  • Replacement Despot
Re: deleting accounts
« Reply #42 on: March 09, 2013, 02:28:53 AM »
I don't actually use that information either, but sometimes the broken relations cause problems with the database because the deleted member's posts are in threads populated by existing members, quoted by them and so on.
"Only two things are infinite, the universe and human stupidity, and I'm not sure about the former."

- Albert Einstein

Offline "couldbecousin"

  • Invincible Heisenweeble of the Aspie Elite
  • Elder
  • Postwhore Beyond Teh Stupid
  • *****
  • Posts: 53577
  • Karma: 2716
  • Gender: Female
  • You're goddamn right.
Re: deleting accounts
« Reply #43 on: March 09, 2013, 03:21:29 AM »
In your database, breaking your connections.

    Saucy Jack!  :laugh:
"I'm finding a lot of things funny lately, but I don't think they are."
--- Ripley, Alien Resurrection


"We are grateful for the time we have been given."
--- Edward Walker, The Village

People forget.
--- The Who, "Eminence Front"

Offline Callaway

  • Official Spokesperson for the Aspie Elite
  • Caretaker Admin
  • Almighty Postwhore
  • *****
  • Posts: 29267
  • Karma: 2488
  • Gender: Female
Re: deleting accounts
« Reply #44 on: March 09, 2013, 03:32:09 AM »
I don't really get it either, Jman.