Home

Welcome Guest ( Log In | Register )

 
Reply to this topicStart new topic
Cleaning Up The Database, Get rid of old members
fozzy_wozzy_woo
post May 11 2006, 09:48 AM
Post #1


Fish Addict
Group Icon

Group: Members
Posts: 991
Joined: 6-February 04
From: Kudelstaart (Amsterdam) (The Netherlands)
Member No.: 3870



All,

I was just thinking as I was trying to find a member in the list.

If i am right you had a massive crash some time ago.. I know this as all my posts from a long time ago is no longer there.

When i came back I had to change my email account and change all my details as my account was frozen and i couldnt use my old email address. as the database said it was being used by another member.

I see that we have 1750 pages of members.. Nice but how many are still active and howmany have re registered.

I was only able to get to my account as i remembered my password i used back then (well after a day of trying)
I tried to get my password from the system but it didnt work as it didnt send the password to my old email account.

So if i didnt remember my password my account would be dead now as i would have had to re register with a different name.

So is it possible to scavenge the records of the data base to clear out all members who have not come back since the big crash.
This will save room in the database and also it will close off a back door in the database.

I say this as I run 5 other database forums and one had a sinular crash and i found later that members that came back had different admin rights although they didnt have them before. This could have been from updating over a period of time the database got confused (poor migration) and usernames and admin rights were mixed up. As i say this was only with names from before the crash.

Also in the admin window you couldnt see that these people had admin rights so this is where the back door is.
Go to the top of the page
 
+Quote Post
Bloo
post May 11 2006, 10:01 AM
Post #2


~ I learn something new ~ ~~~~ every day ~~~~
Group Icon

Group: Newsletter Team
Posts: 9044
Joined: 31-March 05
From: London, UK
Member No.: 12822



Here's a previous thread about Active / Incative memberships smile.gif

And perhaps another that might help explain.

This post has been edited by Bloo: May 11 2006, 10:04 AM
Go to the top of the page
 
+Quote Post
juanveldez
post May 11 2006, 07:28 PM
Post #3


The Claw Chooses....
Group Icon

Group: Moderators
Posts: 2383
Joined: 8-December 02
From: UPPER Michigan
Member No.: 390



fuzzy this arguement has come and gone in many forms as bloo pointed out. and imo it really isn't going to gain much ground for ya.
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
2 User(s) are reading this topic (2 Guests and 0 Anonymous Users)
0 Members:

Collapse

> Similar Topics

  Topic Replies Topic Starter Views Last Action
No New Posts Starting Up The Hobby Again! - My 28 Gal Bow-front Tank!
11 Dr. Bogger 591 27th June 2008 - 10:57 PM
Last post by: Jim Curtis
No New Posts Another Is My Platy Up The Duff Thread :)
2 robert.sadler 92 16th May 2008 - 02:37 AM
Last post by: geer head
No New Posts Temperature After Cleaning Out The Tank
4 dem0nz 124 23rd May 2008 - 12:41 AM
Last post by: Tokis-Phoenix
No New Posts Cories Cleaning Up
5 nicnak 135 19th May 2008 - 11:54 AM
Last post by: jollysue
No New Posts Is My Fish Up The Duff?
Do i need to isolate them?
2 Sharkey&George 68 11th June 2008 - 08:09 PM
Last post by: Sharkey&George


 

RSS Lo-Fi Version Time is now: 6th September 2008 - 11:19 PM