Cleaning Up The Database, Get rid of old members |
![]() |
![]() ![]() |
Cleaning Up The Database, Get rid of old members |
May 11 2006, 09:48 AM
Post
#1
|
|
![]() Fish Addict 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. |
|
|
|
May 11 2006, 10:01 AM
Post
#2
|
|
![]() ~ I learn something new ~ ~~~~ every day ~~~~ Group: Newsletter Team Posts: 9044 Joined: 31-March 05 From: London, UK Member No.: 12822 |
Here's a previous thread about Active / Incative memberships
And perhaps another that might help explain. This post has been edited by Bloo: May 11 2006, 10:04 AM |
|
|
|
May 11 2006, 07:28 PM
Post
#3
|
|
![]() The Claw Chooses.... 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.
|
|
|
|
![]() ![]() |
Similar Topics
| Topic | Replies | Topic Starter | Views | Last Action | |
|---|---|---|---|---|---|
![]() |
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 |
![]() |
Another Is My Platy Up The Duff Thread :) | 2 | robert.sadler | 92 | 16th May 2008 - 02:37 AM Last post by: geer head |
![]() |
Temperature After Cleaning Out The Tank | 4 | dem0nz | 124 | 23rd May 2008 - 12:41 AM Last post by: Tokis-Phoenix |
![]() |
Cories Cleaning Up | 5 | nicnak | 135 | 19th May 2008 - 11:54 AM Last post by: jollysue |
![]() |
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 |
|
Lo-Fi Version | Time is now: 6th September 2008 - 11:19 PM |