Mailing List Archive

Chuck,

First, find the user_id for the account you wish to delete e.g.
select user_id from user where user_name = 'old_user_name';

Assuming they have no contributions, you can just delete the user record. e.g.
delete from user where user_name = 'old_user_name';

However, if the reason you are deleting is because you have two user accounts for the same person, and the old user account has already been used to make edits, and you want to merge the two accounts, you also need to fix several other tables to point to the new username e.g. lets say the old user_id is 66, and the new user_id is 99:
update old set old_user_text = 'old_user_name' where old_user = 66;
update cur set cur_user_text = 'old_user_name' where cur_user = 66;
update recentchanges set rc_user_text = 'old_user_name' where rc_user = 66;
update archive set ar_user_text = 'old_user_name' where ar_user = 66;
update image set img_user_text = 'old_user_name' where img_user = 66;
update old set old_user = 99 where old_user = 66;
update cur set cur_user = 99 where cur_user = 66;
update recentchanges set rc_user = 99 where rc_user = 66;
update archive set ar_user = 99 where ar_user = 66;
update image set img_user = 99 where img_user = 66;

Note that the user_id and user_name fields are duplicated in each of these five tables (for performance reasons).

There may be a script to do all this that I am unaware of. If so can someone please mention it.

If you just want to change the user name, then just update the user_name on the user table and the user_text on the other five tables. Again, there may be a script for this.

Michael Richards

-----Original Message-----
From: mediawiki-l-bounces@Wikimedia.org
[mailto:mediawiki-l-bounces@Wikimedia.org]On Behalf Of Chuck Bishop
Sent: Monday, October 04, 2004 3:30 PM
To: mediawiki-l@Wikimedia.org
Subject: [Mediawiki-l] Delete user account


Is there a way to delete a user login account?

Thanks,

Chuck

On Oct 4, 2004, at 12:29 PM, Chuck Bishop wrote:
> Is there a way to delete a user login account?

Not through the wiki interface, but you could delete the record from
the database. Then anyone could create a new account with the same
name, which may or may not be what you want and could cause unwanted
and confusing effects regarding attributions if there are existing
edits by the deleted user.

-- brion vibber (brion @ pobox.com)

If there is a User number referenced w/o the aproptiate user record,
what happens?


On Mon, 4 Oct 2004 13:13:44 -0700, Brion Vibber <brion@pobox.com> wrote:
> On Oct 4, 2004, at 12:29 PM, Chuck Bishop wrote:
> > Is there a way to delete a user login account?
>
> Not through the wiki interface, but you could delete the record from
> the database. Then anyone could create a new account with the same
> name, which may or may not be what you want and could cause unwanted
> and confusing effects regarding attributions if there are existing
> edits by the deleted user.
>
> -- brion vibber (brion @ pobox.com)
>
>
>
> _______________________________________________
> MediaWiki-l mailing list
> MediaWiki-l@Wikimedia.org
> http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
>
>
>
>
>



--
-------------------------------------------------------------------
http://endeavour.zapto.org/astro73/
Thank you to JosephM for inviting me to Gmail!

On Oct 4, 2004, at 2:22 PM, Jamie Bliss wrote:
> If there is a User number referenced w/o the aproptiate user record,
> what happens?

If a new user is created with the same name, it will no longer be
possible to look up the prior user's contributions in
Special:Contributions.

-- brion vibber (brion @ pobox.com)

Perhaps the original intent was simply to disable, not delete the
account? In that case, would it be enough to put garbage in the
password field and delete the email so they can't ask for a new password?

Chris

Brion Vibber wrote:

> On Oct 4, 2004, at 2:22 PM, Jamie Bliss wrote:
>
>> If there is a User number referenced w/o the aproptiate user record,
>> what happens?
>
>
> If a new user is created with the same name, it will no longer be
> possible to look up the prior user's contributions in
> Special:Contributions.
>
> -- brion vibber (brion @ pobox.com)
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> MediaWiki-l mailing list
> MediaWiki-l@Wikimedia.org
> http://mail.wikipedia.org/mailman/listinfo/mediawiki-l

--
Chris Phoenix cphoenix@CRNano.org
Director of Research
Center for Responsible Nanotechnology http://CRNano.org

Thank you to everyone who replied.

Thanks,
Chuck

-----Original Message-----
From: mediawiki-l-bounces@Wikimedia.org
[mailto:mediawiki-l-bounces@Wikimedia.org] On Behalf Of Chris Phoenix
Sent: Monday, October 04, 2004 6:13 PM
To: MediaWiki announcements and site admin list
Subject: Re: [Mediawiki-l] Delete user account

Perhaps the original intent was simply to disable, not delete the
account? In that case, would it be enough to put garbage in the
password field and delete the email so they can't ask for a new
password?

Chris

Brion Vibber wrote:

> On Oct 4, 2004, at 2:22 PM, Jamie Bliss wrote:
>
>> If there is a User number referenced w/o the aproptiate user record,
>> what happens?
>
>
> If a new user is created with the same name, it will no longer be
> possible to look up the prior user's contributions in
> Special:Contributions.
>
> -- brion vibber (brion @ pobox.com)
>
>
>
------------------------------------------------------------------------
>
> _______________________________________________
> MediaWiki-l mailing list
> MediaWiki-l@Wikimedia.org
> http://mail.wikipedia.org/mailman/listinfo/mediawiki-l

--
Chris Phoenix cphoenix@CRNano.org
Director of Research
Center for Responsible Nanotechnology http://CRNano.org
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l@Wikimedia.org
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l


**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**********************************************************************